Mastering Excel 365 - Basics

About Mastering Excel 365 - Basics

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.

Topics covered include:

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

Almost 3 hours of high-quality HD content in the “Uniquely Engaging”TM Bigger Brains Teacher-Learner style!

Course Goal: Users will know how to use and customize the basic elements of Excel 365 and start performing data analysis.

Target Audience: Users who know the basic elements of Excel 365 and want to learn additional features.

Objectives. You will be able to:

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