Mastering Excel 365 – Basics (2024)
Duration
2h 58m
Students
0
Last Updated
December 10, 2024
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.
- 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
Free
Course Includes
- 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 8
