Review of Excel Business and Finance Functions

• Using Conditional Formatting for Reconciliation and Analysis
• Table Tools and Automatic Updating
• Defining and Managing Names
• Evaluating and Auditing Formulas
• Workspaces and Updating Links

Must Know Accounting and Business Functions for Reporting and Reconciliation

• Financial and Business Formulas
• Logical Functions
  • AND, IF, OR, IFERROR, NOT
• Efficient Text Functions
  • LEFT, RIGHT, MID, LEN, FIND, TEXT, VALUE, CONCATENATE
• Powerful Lookup and Reference
  • VLOOKUP, CHOOSE, INDEX
• Information Functions
  • ISNUMBER, ISERROR, ISBLANK
• The Array-Sum Function

Dynamic Data Management and Manipulation

• Text-to-Columns and Dynamic Trimming
• Validating User Input with Message Alert
• Using List to Automate and Authenticate Data Validity
• Consolidation Different Files and Creating Links to Source Data
• Grouping, Ungrouping, Subtotaling Data and Goal Seek

Mastering Pivot Tables and Pivot Charts

• Inserting Pivot Tables
• Performing Analysis Using Data Manipulations
• Inserting Formulas in Pivot Tables
• Pivot Formatting, Sorting and Filtering
• Preparing Reports Using the Show Pages Function
• Conditional Formatting with Pivot Tables
• Preparing Dynamic Charts and Dynamic Labeling
• Creating Charts with 3-Axis
• Dynamic Labeling in Graphs
• Data Analysis using the Show Values As
• Expand/Collapse Feature in Pivot Tables
• Pivot Table Options
• Date Manipulation Using Pivot Tables
• Show Data Using the Summarize Data Fields By
• Linking Excel with PowerPoint
• Creating Dynamic Pivot Tables and Pivot Charts

Scenario Reporting and Analysis

• Multiple Level Scenarios
• Scenario Spinner and What-If-Analysis

Power Excel Business Techniques

• Designing Dynamic Spinners
• List Box and Option Button Modeling
• Check Box Data Reporting
• Advanced Filter Analysis

Introduction to Macro Recording

• Record and Edit Macros
• Design Buttons and Menus to Activate and Run Macros