Course Outline
1 - Working with Multiple Worksheets and Workbooks
- Topic A: Utilizing Links and External References
- Topic B: Applying 3-D References
- Topic C: Consolidating Data
2 - Sharing and Protecting Workbooks
- Topic A: Collaborative Workbook Management
- Topic B: Securing Worksheets and Workbooks
3 - Automating Workbook Functionality
- Topic A: Implementing Data Validation
- Topic B: Identifying Invalid Data and Formula Errors
- Topic C: Working with Macros
4 - Lookup Functions and Formula Auditing
- Topic A: Applying Lookup Functions
- Topic B: Tracing Cell Dependencies
- Topic C: Monitoring and Evaluating Formulas
5 - Forecasting Data
- Topic A: Analyzing Potential Outcomes with Data Tables
- Topic B: Assessing Outcomes Using Scenarios
- Topic C: Utilizing the Goal Seek Feature
- Topic D: Projecting Data Trends
6 - Sparklines and Data Mapping
- Topic A: Generating Sparklines
- Topic B: Mapping Data
Requirements
To ensure optimal success, participants should possess practical experience in creating and analyzing datasets in Excel. Key competencies include the ability to construct formulas, utilize built-in functions, and perform sorting and filtering on datasets and tables. Additionally, you should be comfortable presenting data through basic charts, working with PivotTables, slicers, and PivotCharts, and customizing your Excel interface. To satisfy these prerequisites, students are expected to have completed the following courses or hold equivalent skills:
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,
