Excel 2021 Basic, Advanced & Expert with pretest

Benefit

Learn Excel from the basics to advanced level, including data entry, formatting, calculations, charts, managing large spreadsheets, pivot tables and advanced functions.

No special software is required for this online course. You will learn in a virtual environment directly in Excel 2021.

Target group

This course is ideal for you if you want to learn or refresh the basics of Excel and are also curious about advanced functions.

Requirements

You do not need any prior knowledge of Excel. Some initial experience is helpful, as it will enable you to achieve success in the training course even more quickly.

Learning content

Level 1: Basic knowledge

This module offers interactive training consisting of 45 lesson videos, 45 practical tasks and 5 theoretical tasks with additional information.

Discover Excel, fill in a table

• Introduction to spreadsheets 
• Opening a workbook 
• General information about the working environment 
• Navigating a workbook 
• Input aids: Entering data
• Selecting, copying and moving cells: Marking and deleting cells 
• Undoing and repeating actions 
• Adjusting column width/row height 
• Saving files: Saving a workbook 
• Editing the contents of a cell 
• Creating a new workbook

Create your first calculations

• Enter a calculation formula 
• Sum and other simple calculations 
• Calculate a percentage 
• Copy to adjacent cells

Present your data in a simple way

• Simple number formats 
• Apply a theme 
• Character adjustments (font and font size) 
• Align cell contents 
• Cell colour and cell borders

Print and format your workbooks

• Layout 
• preview and printing 
• Page break 
• Print area 
• Edit headers and footers

Work more efficiently

• Using Excel Help 
• Spell Check 
• Find and Replace 
• Zoom and View Options 
• Insert/Remove Rows, Columns and Cells 
• Move Cells Quick 
• Copy of Cell 
• Formats Merge Cells 
• Orientation of Cell 
• Content Cell Styles 
• Sort Data

Manage worksheets and display data

• Sheet names and table column colours 
• Inserting, deleting and setting backgrounds for sheets 
• Moving, copying and hiding sheets 
• Freezing columns/rows, splitting windows 
• Repeating column/row titles when printing 
• Hiding elements of a sheet 
• Grouping data in a plan

Level 2: Intermediate knowledge

This module offers interactive training consisting of 61 lesson videos, 61 practical tasks and 5 theoretical tasks with additional information.

Work with more complex tables

• Displaying multiple lines in a cell 
• Absolute references in a formula 
• Copying values, copying with links or transposing 
• Inserting calculation functions: System date and date format 
• Simple states 
• User-defined formats 
• Conditional formatting and its management 
• Naming cell ranges 
• Defining validation criteria 
• Using cell ranges in functions

Präsentiere Deine Zahlen in Diagrammen

• Diagramme erstellen und verschieben
• Diagramme verwalten
• Elemente eines Diagramms auswählen und formatieren
• Textelemente bearbeiten
• Legenden und Plotbereiche anpassen
• Diagramme drucken und formatieren

Present your figures in charts

• Edit data labels 
• Customise data series and axes 
• Create and use chart templates 
• Create and manage sparklines

Design your tables

• Create and edit graphic objects 
• Insert and manage images 
• Rotate, align and group objects

Work with data lists

• Calculate subtotals 
• Create and manage data lists 
• Apply filters and custom filters 
• Remove duplicate values

Using pivot tables and charts

• Create and customise pivot tables 
• Group data in pivot tables 
• Use filters and calculated fields

Level 3: Knowledge for advanced learners

This module offers interactive training consisting of 39 lesson videos, 39 practical tasks and 5 theoretical tasks with additional information.

Increase your efficiency

• Convert data 
• Create data series 
• Error checking and formula evaluation 
• Use the monitoring window

Use advanced calculation functions

• Search functions 
• Financial and text functions 
• Conditional functions 
• Matrix formulas and consolidation

Discover advanced features

• Target value search 
• Scenario management and solver 
• Customise Excel themes and templates

Share your data securely

• Protect and share workbooks 
• Create and protect forms

Microsoft Office Video: Use cases – Excel, Word and PowerPoint with a Microsoft 365 subscription

This module offers you the opportunity to watch a 21-minute video.

• Excel, Word or PowerPoint with a Microsoft 365 subscription 
• Office with or without a Microsoft 365 subscription: What are the differences? 
• Create and save Office documents in OneDrive, SharePoint Online or Teams 
• Edit a document from OneDrive, SharePoint or Teams 
• Share Office documents with colleagues or external partners 
• Work together on a file

Excel 2021 Video: Use Cases

This module offers you the opportunity to watch a 55-minute video.

Implementation of quality control

• Case presentation 
• Drafting statistical formulas 
• Preparing and creating a control chart 
• Improving the control chart 
• Conclusion

Analysis of library visits

• Case presentation 
• Creating a chart showing visitor numbers over time 
• Creating pivot tables 
• Conclusion

Carry out budget monitoring

• Case presentation 
• Creating pivot tables 
• Creating pivot charts 
• Setting up a dashboard 
• Conclusion

Solving a cost minimisation problem

• Case presentation 
• Implementation of formulas 
• Problem solving with the solver 
• Conclusion

Office 365 subscription: What are the differences?

• Create and save Office documents in OneDrive, SharePoint Online or Teams 
• Edit a document from OneDrive, SharePoint or Teams 
• Share Office documents with colleagues or external parties 
• Collaborate on a file

Excel 2021: The Reference Guide

This comprehensive reference work provides a detailed overview of all the features of the widely used spreadsheet programme Microsoft® Excel, version 2021. It is aimed at anyone who wants to learn how to use this programme or expand their knowledge of it.