Excel Level 1
Spreadsheet skills are a core competency in any office environment. Excel Level 1 builds the foundation: from the user interface to basic formulas and first data evaluations.
Key topics
- Navigating the interface, work areas, and workbooks with confidence.
- Entering, structuring, and formatting data cleanly.
- Using formulas and functions for calculations.
- Representing data as charts.
- Setting print areas and configuring page layouts.
Prerequisite
Familiarity with Windows and general computer use is expected.
Target group
This training is aimed at people who want to use Excel in an office or administrative context and are looking for a structured introduction to working with spreadsheets.
Excel fundamentals go beyond basic technical skills – they are a prerequisite for efficient data management, clear analysis, and structured work in virtually any professional context.
- The Excel interface at a glance
- Navigating within a worksheet
- Understanding and using the ribbon
- Creating and saving workbooks
- Entering and editing data
- Copying, pasting, and undoing
- Using AutoFill and Flash Fill
- Using Excel Help
- Creating and applying formulas
- Integrating functions into formulas
- Understanding absolute and relative cell references
- Adjusting columns and rows
- Finding and replacing content
- Selecting the name box and cell contents
- Running a spell check
- Translating text
- Using Smart Lookup
- Checking and ensuring accessibility
- Formatting text and font
- Transferring and applying formats
- Inserting hyperlinks
- Defining number formats
- Aligning cell content
- Using themes and table styles
- Applying conditional formatting
- Creating custom templates
- Structuring worksheets
- Moving, copying, and formatting sheets
- Using cross-sheet cell references
- Customizing workbook views
- Managing file properties
- 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.