Reviews 5,0
Reviews 5,0
Excel Level 3
Those who don’t just manage data but evaluate and automate it purposefully work more efficiently and make better-informed decisions. Excel Level 3 provides the tools to do exactly that.
Key topics
- Recording, customising, and safely using macros.
- Applying What-If analyses and Goal Seek.
- Protecting and collaboratively editing workbooks.
- Using sparklines and map visualisations.
- Creating and evaluating data forecasts.
Prerequisite
Well-grounded knowledge from Excel Level 2 and regular practice with PivotTables, formulas, and charts.
Target group
Professionals in controlling, analysis, project management, or administration who use Excel for complex tasks and reporting.
Excel Level 3 enables automated workflows, precise reports, and reliable analyses – for greater confidence when working with data.
Course content
Structuring worksheets and workbooks
- Worksheets and workbooks – overview
- Referencing worksheets and workbooks
- Using 3D references
- Consolidating data – basics
- Merging data from multiple sources
- Quiz
Reviewing formulas and references
- Reference functions – introduction
- Applying reference functions purposefully
- Overview of predecessor and successor cells
- Tracing dependencies in formulas
- Monitoring and auditing formulas
- Step-by-step formula evaluation
- Quiz
Protecting and sharing workbooks
- Collaborative editing – basics
- Editing and sharing workbooks
- Exporting workbooks
- Protecting worksheets and workbooks – overview
- Setting up worksheet protection
- Configuring workbook protection
- Using comments and @mentions
- Reviewing and finalising documents
- Quiz
Automating workflows with macros
- Setting up data validation
- Implementing data validation in practice
- Identifying errors in data and formulas
- Recording and running macros
- Using macros with relative references
- Storing macros in workbooks
- Editing and customising macros
- Using macros responsibly
- Quiz
Visualising data with sparklines and maps
- Sparklines – introduction and basics
- Creating and designing sparklines
- Displaying geographical data with 2D maps
- Quiz
Developing scenarios and forecasts
- What-If analysis – basics
- What-If analysis with data tables
- What-If analysis with Scenario Manager
- Goal Seek – introduction
- Applying Goal Seek in practice
- Data forecasting – basics
- Creating and evaluating data forecasts
- Quiz
- Summary and outlook
Up to 100% funding for your continuing education
Attractive funding opportunities are available for numerous continuing education programs – depending on the funding program, up to 100% funding is possible.
The requirement is that you live or work in Germany. Our funding opportunities are not available outside of Germany.
Funding opportunities are available for career starters, job seekers, career changers, startups, experienced professionals, those seeking career advancement, and specialists.
