Excel Level 2

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

Columns of numbers don't have to be confusing. With the right functions and analysis tools, Microsoft Excel transforms raw data into clear information, supports reporting structures, and makes trends visible at a glance.

Key topics

Working with named ranges and dynamic references.
Use of statistical, text, and date functions for precise evaluations.
Professional design of charts, including trend lines.
Conditional formatting to visually highlight relevant values.
Use of table objects for clean, structured data models.

Prerequisite
Familiarity with basic Excel functions such as cell formatting, simple calculations, basic charts, and saving workbooks.

Target audience
Designed for people who regularly create reports, evaluate key figures, or manage projects and want to use reliable tools in Microsoft Excel for this purpose—regardless of industry or company size.

Those who use Excel specifically for analysis, structure, and visualization work more efficiently and can communicate relationships more clearly. Confident use of tables, functions, and charts supports data-oriented working methods and enhances digital professionalism in everyday work.

Print as PDF

Course content

Apply functions

Working with formulas
Naming and editing ranges
Using named ranges in formulas
Discovering new functions
Applying logical functions
IF function
IFS function
AND, OR, NOT functions
Combine functions
SUMIF, COUNTIF, AVERAGEIF
Applying date and time functions
Basic date functions
NETWORKDAYS, WORKDAY, ISOCALENDERWEEK
Applying text functions
LEFT, RIGHT, PART
FIND function
Split text into columns
TEXT CONCATENATION
UPPER, LOWER, UPPER2, SMOOTH

Lists in everyday life

Introduction: Sorting and filtering data
Sorting the data
Filtering data
Querying data with database functions
Summarizing partial results

Data analysis

Creating and editing tables
Using structured references
Applying conditional formatting with formulas

Visualization with diagrams

Creating and formatting charts
Chart templates and composite charts
Adding trend lines
Creating funnel charts
Using pictograms

PivotTables and PivotCharts

Create a PivotTable report
Analyze data with PivotTable
Using PivotTable tools
Use PivotCharts for visualization
Apply filters with timeline and data slice
Outlook

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 covered in Excel Level 2?

Excel Level 2 deepens your knowledge of functions, charts, data analysis, and formatting. The focus is on efficiency, automation, and analysis.

What prior knowledge is required for Excel Level 2?

Basic knowledge of Excel is required: formatting cells, using simple formulas, and creating tables. Some experience with the program is advantageous.

Who benefits from Excel Level 2?

Perfect for anyone who works with data, creates reports, or wants to improve processes—in the office, controlling, sales, or project management.

What content is the focus on?

Topics covered include logical functions, nested formulas, relative and absolute references, pivot tables, charts, and custom formatting.

Why is Excel Level 2 worthwhile in the workplace?

Solve complex tasks faster, evaluate data better, avoid errors, automate reports—ideal for modern office and data work.

Is there a certificate at the end?

Yes, a certificate of participation is included. It documents your knowledge and is suitable for professional development and as proof of qualification.

What is the difference between Excel Level 1 and Level 2?

Level 1 teaches the basics, Level 2 goes deeper: complex functions, data links, charts, pivot tables, and structured evaluations.

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. *