Course Outline
1 - MANAGING MULTIPLE WORKSHEETS AND WORKBOOKS
- Topic A: Utilising Links and External References
- Topic B: Applying 3-D References
- Topic C: Consolidating Data
2 - COLLABORATION AND WORKBOOK SECURITY
- Topic A: Working Together on a Workbook
- 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 - IMPLEMENTING LOOKUP FUNCTIONS AND FORMULA AUDITING
- Topic A: Applying Lookup Functions
- Topic B: Tracing Cells
- Topic C: Monitoring and Evaluating Formulas
5 - PREDICTIVE DATA ANALYSIS
- Topic A: Analysing Potential Outcomes Using Data Tables
- Topic B: Analysing Potential Outcomes Using Scenarios
- Topic C: Utilising the Goal Seek Feature
- Topic D: Projecting Data Trends
6 - GENERATING SPARKLINES AND VISUALISING DATA MAPS
- Topic A: Creating Sparklines
- Topic B: Visualising Data Maps
Requirements
To ensure optimal success, learners should possess practical, real-world experience in creating and analysing datasets using Excel. Key competencies include the ability to construct formulas and utilise Excel functions; create, sort, and filter datasets and tables; present data through basic charts; build and manipulate PivotTables, slicers, and PivotCharts; and customise the Excel environment. To fulfil these prerequisites, learners may have completed the following courses or possess 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,
