Excel 2019 Intermediate (2022)

Expand your Excel knowledge - enhance your spreadsheets with Pivot Tables, advanced charts, and more

What you'll learn:
Make analyzing large data sets easier by creating tables and using table tools
Display the exact data you are looking for with filters and sorting tools
Create and customize visuals and charts
Learn Pivot Tables to discover and display the most essential parts of your data
Create Pivot Charts out of Pivot Tables for visual representations of reports
Protect and lock worksheets and workbooks to restrict users

Requirements:
Fundamental Excel knowledge
Recommended: Completion of our Excel 2019 Beginner course

Description:
Mastery of Excel is developed in stages: first you learn basic formatting, functions and formulas, and build a few spreadsheets yourself. Easy enough. But moving to the next level of proficiency is hard! To create truly professional-looking spreadsheets, you'll need to know how to organize data into elegant, interactive tables that dynamically generate colorful charts and graphs. To bring you up to an intermediate-level usage of Excel, we'll train you in how to use the following core features.
Advanced Tables - Beyond organizing data in rows and columns, we'll show you how to create filters that display only certain rows: for example, all the rows where the "City" column is set to "New York." You'll also learn how to sort entire tables based on values in one or more columns: for example, sorting customers by annual revenue. You'll learn how to instantly colorize, stripe, filter and subtotal a simple table of data using Excel's ever-popular "Format As Table" feature.
Charts - Excel has 10 major chart types, everything from basic line charts to scatter plots. We'll show you how to add impressive data visualizations to your spreadsheets: line charts, bar graphs, pie charts, and more.
Pivot Tables - One of Excel's most powerful — and least understood — features, pivot tables auto-magically convert static rows and columns of data into a responsive table that will re-organize itself to instantly display subtotals, averages, or other aggregate functions — depending on which fields you choose. Instead of creating 3 different tables to see sales by customer rep, customers by city, and revenue by state, you'll learn how to create a single pivot table to display all 3 sets of information in one place, based on your selection of different field groupings. You'll also learn how to generate pivot charts from the data.
Tips & Tricks - The training also covers a few techniques we've selected as the most useful in your journey toward Excel mastery. These include "conditional formatting": coloring cells based on their values (e.g., heat maps); removing duplicates (common in data cleanup); data validation: preventing anything except certain data types (e.g., dates) being entered in a cell; and cell protection: preventing accidental typing into a cell with a formula.
This is course 2 of 3 in Learnit Anytime’s Excel 2019 training series.

Who this course is for:
Users with some Excel experience looking to gain Intermediate-level knowledge
Experienced Excel users looking for a quick refresher

More Info