Excel 2019 Basic, Advanced & Expert with pretest

Benefit

Discover the spreadsheet program Excel and master all its functions. In this course, you'll learn everything you can accomplish with the software, from basic to expert functions. A pretest before the course begins will test your current knowledge of Excel 2019 and tailor appropriate learning modules to your skill level.

No proprietary software is required for this online course. You learn in a virtual environment directly in Excel 2019.

Target group

For all users who want to learn or review the basics of Excel and get to know advanced, as well as expert functions.

Learning content

Excel 2019 - Level 1: Basic Skills

• Explore Excel and complete a workbook
• Perform your first calculations
• Apply minimal presentation to your data
• Print your workbooks and set up the page layout
• Work more efficiently
• Manage the sheets and display of your data

Excel 2019 - Level 2: Advanced skills

• Make your tables more complex
• Represent your numbers in charts
• Improve the presentation of your charts
• Make your tables more attractive
• Use your tables with data lists
• Create and use PivotTables

Excel 2019 - Level 3: Advanced skills

• Increase effectiveness
• Use advanced calculation functions
• Discover unimagined functions
• Sharing and security
• More...

Office 2019: Use Cases- Excel, Word or PowerPoint with an Office 365 subscription.

• Office with or without an Office 365 subscription: what's the difference?
• Create and save Office documents in OneDrive, SharePoint Online or Teams.
• Edit an Office document via OneDrive, SharePoint or Teams
• Share Office documents with colleagues or with external people
• Create files collaboratively

Excel 2019: Use Cases

• Create a quality assurance chart
• Statistics on the number of visitors to a library
• Keep track of the budget used and needed
• Minimize delivery costs