Course Outline
1 - MANAGING MULTI-SHEET AND MULTI-WORKBOOK ENVIRONMENTS
- Topic A: Establishing External Links and References
- Topic B: Implementing 3-D References
- Topic C: Data Consolidation Procedures
2 - WORKBOOK COLLABORATION AND SECURITY PROTOCOLS
- Topic A: Facilitating Concurrent Workbook Editing
- Topic B: Applying Worksheet and Workbook Protection Measures
3 - WORKBOOK AUTOMATION ENHANCEMENTS
- Topic A: Configuring Data Validation Rules
- Topic B: Identifying Invalid Data and Formula Errors
- Topic C: Executing and Managing Macros
4 - LOOKUP FUNCTIONS AND FORMULA AUDIT PROCEDURES
- Topic A: Deploying Lookup Functions
- Topic B: Tracing Cell Dependencies
- Topic C: Monitoring and Evaluating Formulas
5 - DATA FORECASTING AND ANALYSIS
- Topic A: Projecting Outcomes via Data Tables
- Topic B: Assessing Outcomes via Scenario Analysis
- Topic C: Utilizing the Goal Seek Tool
- Topic D: Analyzing Data Trends for Forecasting
6 - SPARKLINE GENERATION AND DATA VISUALIZATION
- Topic A: Constructing Sparklines
- Topic B: Mapping Data Geographically
Requirements
To ensure successful engagement with this material, participants should possess practical experience in creating and analyzing datasets using Excel. Competencies required for government include: constructing formulas and utilizing Excel functions; creating, sorting, and filtering datasets and tables; presenting data through basic charts; building and managing PivotTables, slicers, and PivotCharts; and customizing the Excel interface. To satisfy these prerequisites, participants should have completed the following courses or demonstrated equivalent skill levels:
Microsoft® Office Excel®: Basic
Microsoft® Office Excel®: Intermediate
Testimonials (2)
Flexibility in the course delivery and the interactive approach. The trainer was open to questions, clarified doubts clearly and also considered participants suggestions during the sessions. The training was well structured and informative.
Soundarya Mohan - Mizuho Bank Europe N.V.
Course - Financial Analysis in Excel
the trainer's patience,
