Excel

Table of Contents Chapter 1: Master Excel Through Projects  Why Learn Through Projects  Cell Reference and Formula  Formula  Cell Reference in Formulas  Autofill or Copy  Experiment 1  Experiment 2  Experiment 3  Functions to Learn  SUM, AVERAGE, MAX, MIN, and COUNT  CHAR and CODE  MID RANDBETWEEN LOOKUP IF IFERROR Autofill Formulas  Relative Cell Reference  Absolute Cell Reference  Work on the Project  Chapter Tip  Review Points  Chapter 2: Food Nutrition Ranking  Functions to Learn IF ISBLANK AND, OR VLOOKUP Work on the Project  Name Manager and Data Validation  Instructions to Complete the Project Chapter Tip  Review Points  Chapter 3: Payroll Calculation Functions to Learn  ROUND SUBSTITUTE INDEX MATCH INDIRECT Work on Project 1 Federal Tax Withholding Explanation and Worksheet Setup  Instructions to Complete Project 1 Work on Project 2 Table Setup and Naming ...

  Contents SECTION 1 GETTING ORIENTED 1 1 Necessary Foundation for Decision Support 3 2 The Common Development Environment 12 3 Acquisition, Cleaning, and Consolidation 41 SECTION 2 STRUCTURING INTELLIGENCE 87 4 Estimating and Appreciating Uncertainty 89 5 Visualizing Data, Dynamics and Risk 142 SECTION 3 PRESCRIPTION DEVELOPMENT 197 6 The Analytics of Solution Search 199 7 Searches in Highly Complex and Uncertain Landscapes 255 SECTION 4 ADVANCED AUTOMATION AND 8 VBA Editing and Code Development 307 9 Application and User Interfacing 362