Mastering Excel 2021 – Intermediate
- 27 Sections
- 3h 26m Duration
Introduction
Flash Fill
Text to Columns
Find and Replace
Sort and Filter
Proofing and Researching Tools
Group Mode
Workbook Properties
Freeze and Split Windows
Workbook Views
Custom Views
Custom Number Formats
Conditional Formatting for Text and Dates
Comparative Analysis with Conditional Formatting
Customizing Conditional Formatting
Functions in Conditional Formatting
Nested Functions
Logical Functions
Statistical Functions
Chart Elements
Chart Formats
Sparklines
Graphics
SmartArt
Summarizing Data in Tables
Web Queries
Forecasting with Data Tables
Learn many of Excel’s tools for analyzing and sharing your data.
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 great tools to modify your data and refine your workbook. Excel expert Kathy Jones will also show you how to nest functions and modify and format charts. You’ll even learn to enhance your visualizations by adding sparklines, pictures, and SmartArt. And if you need to work with others, you’ll learn some of the tools available when sharing your workbooks, including comments, hyperlinks, track changes, and share options.
And if you need to know more about forecasting, you’ll learn how to conduct What-If analysis using Excel’s special features.