Mastering Excel 365 – Basics (2024)
- 20 Sections
- 2h 58m Duration
Introduction
Open and Save a Workbook
Modifying Rows and Columns, Part 1
Modifying Rows and Columns, Part 2
Managing Worksheets, Part 1
Managing Worksheets, Part 2
Using Absolute References
Creating Named Ranges
Using Named Ranges in Functions
Working with IF Functions
Working with Logical Functions
Creating Functions Based on Conditions
Tracing Formulas
Addressing Formula Errors
Aligning Cell Contents
Adding Borders and Shading
Applying Number and Date Formats
Using Format Painter
Applying Cell Styles and Themes
Changing Chart Types
Go beyond the basics of data entry to analyze your data and create visually appealing workbooks.
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. Excel expert Kathy Jones will also show you how to address function errors, customize your charts, and create and use tables and PivotTables to easily manipulate and summarize your data.