Beginner
Mastering Excel 2021 – Basics
- 14 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
Working with Logical Functions
Changing Page Breaks and Scaling
Configuring Headers and Footers
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.