Excel 2019 Basic & Advanced

Benefit

Discover the spreadsheet program Excel, and learn to master all its functions. In this course, you'll learn everything you can do with the software, from basic to advanced 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 or review the basics of Excel and learn advanced functions.

Learning content

Excel 2019 - Level 1: Basic knowledge

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

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

• Office with or without 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
• Overview of the budget used and needed
• Minimize delivery costs