Excel 2019 Advanced & Expert

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 advanced to expert functions.

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

Target group

For all users who want to learn advanced, as well as expert functions of Excel 2019.

Learning content

Excel 2019 - Level 2: Advanced knowledge

• Make your tables more complex
• Display 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 unexpected 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?
• Creating and saving 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
• Overview of the budget used and needed
• Minimize delivery costs