Course Outline
1 - MANAGING MULTIPLE WORKSHEETS AND BOOKS
- Topic A: Implement Links and External References
- Topic B: Utilize 3-D References
- Topic C: Consolidate Data Sets
2 - COLLABORATION AND SECURITY FOR WORKBOOKS
- Topic A: Enable Collaborative Editing
- Topic B: Secure Worksheets and Workbooks
3 - AUTOMATING WORKBOOK PROCESSES
- Topic A: Configure Data Validation Rules
- Topic B: Identify Invalid Data and Formula Errors
- Topic C: Manage Macros for government workflows
4 - UTILIZING LOOKUP FUNCTIONS AND FORMULA AUDITING
- Topic A: Apply Lookup Functions
- Topic B: Trace Cell Dependencies
- Topic C: Monitor and Evaluate Formulas
5 - FORECASTING AND ANALYTICAL MODELING
- Topic A: Analyze Potential Outcomes Using Data Tables
- Topic B: Simulate Outcomes with Scenarios
- Topic C: Employ the Goal Seek Feature
- Topic D: Project Data Trends
6 - DATA VISUALIZATION AND GEOGRAPHIC MAPPING
- Topic A: Generate Sparklines for Compact Visualization
- Topic B: Create Geospatial Maps from Data
Requirements
To ensure program outcomes, participants must demonstrate hands-on proficiency in constructing and evaluating datasets via Microsoft Excel. Essential competencies include formulating equations and utilizing built-in functions; organizing, sorting, and filtering data tables; visualizing information through fundamental charts; developing PivotTables, PivotCharts, and slicers; and configuring the application workspace. Individuals seeking to satisfy these prerequisites may enroll in the courses listed below or demonstrate comparable mastery of Excel functionalities tailored for government operations:
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,
