Mastering Excel 365: Basics (2024)

Learn how to use the world’s most popular software tool for analyzing and reporting on data. In this course you’ll learn to make your spreadsheets easily readable and visually appealing, while including complex functions and summary reports.

When you master Excel, you have one of the most practical and valuable skillsets in modern business. Excel expert Kathy Jones 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.

Topics covered are:

• Managing rows, columns, and worksheets
• Creating and using named ranges
• Adding logical and conditional functions
• Addressing formula errors
• Applying cell and number formats, including cell styles and themes
• Modifying charts
• Creating Tables and PivotTables
• Configuring page settings and headers/footers for printing

This course includes:

• Approximately 3 hours of video lessons.
• Downloadable templates and resources to help you apply what you've learned.
• A quiz with multiple-choice questions to check your understanding.