Mastering Excel 2021 – Basics

Description

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

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

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

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!

TAKE THIS COURSE