Course Outline
1 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
- Topic A: Implementing Links and External References
- Topic B: Applying 3-D References
- Topic C: Consolidating Data
2 - SHARING AND PROTECTING WORKBOOKS
- Topic A: Collaborating 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 - USING LOOKUP FUNCTIONS AND FORMULA AUDITING
- Topic A: Leveraging Lookup Functions
- Topic B: Tracing Cells
- Topic C: Monitoring and Evaluating Formulas
5 - FORECASTING DATA
- Topic A: Assessing Potential Outcomes via Data Tables
- Topic B: Evaluating Outcomes Using Scenarios
- Topic C: Utilizing the Goal Seek Feature
- Topic D: Projecting Data Trends
6 - CREATING SPARKLINES AND MAPPING DATA
- Topic A: Generating Sparklines
- Topic B: Visualizing Data on Maps
Requirements
To succeed in this course, participants should have practical, real-world experience in building and analyzing datasets within Excel. Competencies that should be established include: constructing formulas and applying Excel functions; generating, sorting, and filtering datasets and tables; visualizing data through basic charts; creating and manipulating PivotTables, slicers, and PivotCharts; and tailoring the Excel interface. These prerequisites can be met by completing the following courses or demonstrating 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,
