Course Outline
1 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
- Topic A: Utilize Links and External References for Government
- Topic B: Employ 3-D References
- Topic C: Consolidate Data
2 - SHARING AND PROTECTING WORKBOOKS
- Topic A: Collaborate on a Workbook for Government
- Topic B: Secure Worksheets and Workbooks
3 - AUTOMATING WORKBOOK FUNCTIONALITY
- Topic A: Implement Data Validation
- Topic B: Identify Invalid Data and Formulas with Errors
- Topic C: Manage Macros
4 - USING LOOKUP FUNCTIONS AND FORMULA AUDITING
- Topic A: Utilize Lookup Functions for Government
- Topic B: Trace Cell Dependencies
- Topic C: Monitor and Evaluate Formulas
5 - FORECASTING DATA
- Topic A: Assess Potential Outcomes Using Data Tables
- Topic B: Analyze Potential Outcomes Using Scenarios
- Topic C: Utilize the Goal Seek Feature for Government
- Topic D: Forecast Data Trends
6 - CREATING SPARKLINES AND MAPPING DATA
- Topic A: Create Sparklines for Government
- Topic B: Map Data
Requirements
To ensure success, participants should have practical, real-world experience creating and analyzing datasets using Excel. Specific tasks participants should be able to perform include: developing formulas and utilizing Excel functions; creating, sorting, and filtering datasets and tables; presenting data through basic charts; creating and working with PivotTables, slicers, and PivotCharts; and customizing the Excel environment. To meet these prerequisites, participants can take the following courses, or should possess equivalent skill levels:
Microsoft® Office Excel®: Basic for government
Microsoft® Office Excel®: Intermediate
Testimonials (5)
active interaction between trainer and participants
DEEWEELYN DE LUNA - TRACTEBEL RED INC.
Course - Financial Analysis in Excel
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
I was recently struggling with some pivot table issues and the course gave me the knowledge to work with pivot tables quicker, smarter and more efficiently.
Arina Moayed-Dzenisa - Universal-Investment-Gesellschaft mbH Branch Poland Sp. z o. o.
Course - Microsoft Office Excel - poziom średnio zaawansowany
examples and looking for solutions
Monika Lesniewska - Takenaka Europe GmbH Sp. z o.o. Oddzial w Polsce
Course - Excel Data Analysis
The tips for many of the functions that the trainer presented, which we can easily remember and implement in our future work
