Business and Financial Reporting Using Excel 2007 Course in Abu Dhabi on 16 Sep 2012
Abu Dhabi, United Arab Emirates
Program Outline
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