Reviews 4,2
Reviews 4,5
100% fundable

Excel Level 2

Excel Level 2 goes a step further: mastering more complex functions, PivotTables, and structured data ranges means getting more from your data – faster, more clearly, and with less manual effort.

Key topics

  • Creating named ranges and using them in formulas.
  • Applying statistical, text, and date functions purposefully.
  • Preparing charts and adding trend lines.
  • Highlighting relevant values using conditional formatting.
  • Using table objects for structured data models.

Prerequisite
A working knowledge of Excel is expected: creating and formatting tables, using simple formulas, and saving workbooks.

Target group
This training is aimed at employees who already have a basic knowledge of Excel and want to build on those skills for analysis, reporting, and data evaluation.

Solid Excel Level 2 skills make the difference between data maintenance and real data analysis. Those who can confidently work with PivotTables, advanced functions, and charting tools take their work to a significantly higher level.

Course content
  • Using formulas purposefully
  • Naming and managing cell ranges
  • Incorporating named ranges into calculations
  • Exploring advanced functions
  • Understanding and using logical functions
  • Applying the IF function
  • Evaluating multiple conditions with IFS
  • Combining AND, OR, and NOT
  • Nesting and combining functions
  • Conditional evaluations with SUMIF and COUNTIF
  • Working with date and time functions
  • Core functions for date and time
  • Calculating workdays and determining calendar weeks with NETWORKDAYS, WORKDAY, ISOWEEKNUM
  • Working with text functions
  • Using LEFT, RIGHT, and MID for text segments
  • Locating text with FIND
  • Separating text into columns
  • Merging text with TEXTJOIN
  • Controlling capitalisation and removing extra spaces with UPPER, LOWER, PROPER, TRIM
  • Overview: sorting and filtering
  • Sorting data by one or more criteria
  • Filtering data purposefully
  • Using database functions for queries
  • Summarising subtotals in a structured way
  • Creating and customising tables
  • Using structured references in table objects
  • Defining formatting rules using formulas
  • Creating and designing charts
  • Using chart templates and creating combination charts
  • Inserting trend lines
  • Using funnel charts for process flows
  • Integrating pictograms into charts
  • Building a PivotTable report
  • Evaluating data using PivotTables
  • Using PivotTable tools purposefully
  • Using PivotCharts for visual analysis
  • Filtering data with timelines and slicers
  • Overview of further topics

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.