Excel Level 3

Price
Net: 397,00 €
VAT.: 75,43 €

Duration
1 day

For companies and job seekers:
this course is 100% fundable!

Location

Course Language
German

Training Solutions
WalkIn^®

Request a consultation Add to favorites Print as PDF

Structured data analysis increases transparency and efficiency in companies. Advanced Excel functions help to accurately evaluate complex information and present it in a comprehensible way.

Key topics

Advanced formulas and function combinations.
PivotTables and PivotCharts for reporting.
Scenario analyses and target value calculations.
Basics of macro creation.
Informative charts and visualizations.

Prerequisite
Solid basic knowledge of Excel and practical experience in working with tables and standard functions.

Target group
People from controlling, finance, administration, and project environments who need professional data analysis.

In-depth Excel skills create clear structures, automated processes, and reliable decision-making bases in the digital work context.

Print as PDF

Course content

Manage worksheets and folders

Introduction: Worksheets and folders
Referencing worksheets and folders
Using 3D references
Introduction: Consolidating data
Consolidating data
Quiz

Monitor references and formulas

Reference functions – Introduction
Reference functions
Predecessor and successor cells – Introduction
Predecessor and successor cells
Formula monitoring
Formula evaluation
Quiz

Backing up and sharing workbooks

Collaborative editing of workbooks – Introduction
Editing workbooks
Exporting workbooks
Protecting worksheets and workbooks – Introduction
Protecting worksheets
Protecting workbooks
Comments and @mentions
Document review
Quizzes

Automated processes

Implement data verification
Implement data verification
Identifying incorrect data and formulas
Working with macros
Macros with relative references
Saving macros in workbooks
Customizing macros
Using macros safely
Quiz

Using sparklines and maps

Creating sparklines: Introduction
Creating sparklines
Working with maps (2D maps)
Quiz

Data forecasts

Introduction to What-If Analysis
What-If Analysis with Data Table
What-if analysis with Scenario Manager
Goal Seek – Introduction
Applying Goal Seek
Introduction to Data Forecasting
Creating a data forecast
Quiz
Summary

Your training will be 100% funded

Our funding schemes are available exclusively to participants who live or work in Germany. Funding is not available outside Germany.

For career starters, job seekers, career changers, startups, experienced professionals, those looking to advance their careers, specialists, etc.

The QCG program for everyone in the company

Further information

The education voucher for all job seekers

Further information

Frequently asked questions

What is taught in Excel Level 3?

Excel Level 3 offers professional knowledge for complex data analysis, macros, Power Query, pivot reports, formulas with matrix references, and automated workflows.

What are the requirements for Excel Level 3?

Solid knowledge of Excel Level 2 is important. If you regularly work with functions, pivot tables, and charts, this is the right place for you.

Who benefits most from Excel Level 3?

Ideal for professionals in controlling, data analysis, project management, or administration who work with large amounts of data and automated processes.

Why is Excel Level 3 useful for everyday working life?

Process data faster, automate processes, build reports efficiently—ideal for demanding tasks in data-driven environments.

Is there a certificate after the course?

Yes, at the end of the course, participants receive an official certificate as proof of advanced Excel skills—a plus for any job application.

Is the course also suitable for Microsoft 365 users?

Yes, Excel Level 3 covers all modern versions—including dynamic functions, cloud collaboration, and Excel tools from Microsoft 365.

What is the difference to Level 2?

Level 2 works with classic functions. Level 3 goes deeper: with automation, data modeling, and advanced analysis tools.

Do you have any further questions? Please contact us.

Select your nearest center: *

0800 258 258 055

website@newhorizons.de

First Name *

Surname *

Telephone Number *

Postcode *

E-Mail *

I would like to receive funding for further training – I am currently: *

Company Name

Your message

I hereby confirm that I have taken note of the privacy notice. *