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: Facilitating 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: Applying Lookup Functions
- Topic B: Tracing Cell Dependencies
- Topic C: Monitoring and Evaluating Formulas
5 - FORECASTING DATA
- Topic A: Analyzing Potential Outcomes via Data Tables
- Topic B: Assessing Potential Outcomes Using Scenarios
- Topic C: Utilizing the Goal Seek Feature
- Topic D: Predicting Data Trends
6 - CREATING SPARKLINES AND MAPPING DATA
- Topic A: Generating Sparklines
- Topic B: Visualizing Data on Maps
Requirements
To maximize your success in this course, you should possess practical experience in building and analyzing datasets within Excel. Essential competencies include the creation of formulas, the application of built-in functions, and the management of data through sorting, filtering, and table structures. Furthermore, you should be familiar with presenting information via basic charts, utilizing PivotTables, slicers, and PivotCharts, as well as customizing your Excel workspace. These requirements can be met by completing the following courses or demonstrating 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
the trainer's patience,
