Excel 2019 2021 2024 Fundamentals

Learn Excel basics in a practical way: create tables, calculate data, and analyze information.

In this two-day fundamentals workshop, participants will learn the most important features of Microsoft Excel.
The course teaches how to efficiently enter, format, calculate, and evaluate data.

A special focus is placed on analyzing large data sets, creating clear reports and charts, and using basic formulas and functions.

Your Benefits at a Glance

• Efficient work with tables and lists
• Basic data analysis, calculations, and chart creation
• Tips and tricks for fast navigation and efficient work in Excel
• Participation possible in person or online

Seminar Contents

Basic Program Operation

• Use and customize tabs and ribbons
• Personalize the workspace including the Quick Access Toolbar
• Create, save, and organize workbooks

Creating and Editing Tables

• Enter numbers and text
• Move, copy, and use paste options
• Delete or insert rows and columns
• Tips for fast navigation in tables
• Use AutoFill features

Formatting Tables

• Apply text and number formats
• Create borders and background formats
• Add headers and footers
• Use table styles

Working with Large Lists

• Freeze rows and columns, split tables
• Sort and filter lists
• Analyze data in dynamic tables
• Create subtotals

Printing Tables and Print Preparation

• Adjust page margins, print areas, and print titles
• Optimize page breaks

Performing Basic Calculations

• Basics of formulas and functions
• Add, multiply, divide, and subtract values
• Use functions: SUM, MAX, MIN
• Understand relative and absolute references

Creating Charts

• Chart types and their use
• Create simple charts
• Customize chart options

Prerequisites

• Basic knowledge of Office or any earlier Office version is an advantage

Target Audience

• Users who work with Excel to create tables, calculate values, and analyze data
• Beginners and employees who need a solid foundation for further Excel training