Mastering Excel 365 – Basics (2024)

Microsoft Excel is the most popular data analysis tool in the workplace, so using it effectively is a crucial skill for any business professional. In this course you’ll learn to make your spreadsheets easily readable and visually appealing, while including complex functions and summary reports. This course will show you how to address function errors, customize your charts, and create and use tables and PivotTables to easily manipulate and summarize your data.

• Open and save existing workbooks
• Manage rows, columns, and worksheets
• Create and use named ranges
• Add logical and conditional functions
• Address formula errors
• Apply cell and number formats, including cell styles and themes
• Modify charts
• Create Tables and PivotTables
• Configure page settings and headers/footers for printing