Course Outline
1 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
- Topic A: Utilize Links and External References
- Topic B: Implement 3-D References
- Topic C: Consolidate Data
2 - SHARING AND PROTECTING WORKBOOKS
- Topic A: Facilitate Collaboration on a Workbook
- Topic B: Secure Worksheets and Workbooks
3 - AUTOMATING WORKBOOK FUNCTIONALITY
- Topic A: Apply Data Validation Rules
- Topic B: Identify Invalid Data and Formula Errors
- Topic C: Develop and Manage Macros
4 - USING LOOKUP FUNCTIONS AND FORMULA AUDITING
- Topic A: Deploy Lookup Functions
- Topic B: Trace Cell Dependencies
- Topic C: Monitor and Evaluate Formulas
5 - FORECASTING DATA
- Topic A: Model Potential Outcomes with Data Tables
- Topic B: Analyze Potential Outcomes Using Scenarios
- Topic C: Leverage the Goal Seek Feature
- Topic D: Project Data Trends
6 - CREATING SPARKLINES AND MAPPING DATA
- Topic A: Generate Sparklines
- Topic B: Visualize Mapped Data
Requirements
To ensure optimal success, students are expected to have hands-on, real-world experience in creating and analyzing datasets using Excel. Essential competencies include: developing formulas and utilizing Excel functions; generating, sorting, and filtering datasets and tables; presenting information through basic charts; constructing and manipulating PivotTables, slicers, and PivotCharts; and customizing the Excel user environment. To satisfy these prerequisites, students should either have completed the following courses or demonstrate an equivalent level of proficiency:
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
Every step of the way, I was learning something.
