Course Outline
1 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
- Topic A: Utilizing Links and External References
- Topic B: Applying 3-D References
- Topic C: Data Consolidation
2 - SHARING AND PROTECTING WORKBOOKS
- Topic A: Workbook Collaboration
- 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: Managing Macros
4 - USING LOOKUP FUNCTIONS AND FORMULA AUDITING
- Topic A: Employing Lookup Functions
- Topic B: Tracing Cells
- 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: Applying the Goal Seek Feature
- Topic D: Predicting Data Trends
6 - CREATING SPARKLINES AND MAPPING DATA
- Topic A: Developing Sparklines
- Topic B: Data Mapping
Requirements
To ensure a successful learning experience, students should possess practical, real-world experience in creating and analyzing datasets using Excel. This includes the ability to formulate and utilize Excel functions, create, sort, and filter datasets and tables, present data through basic charts, and build and manage PivotTables, slicers, and PivotCharts, as well as customize the Excel environment. To satisfy these prerequisites, students should have completed the following courses or demonstrate an equivalent level of skill:
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,
