Excel Intermediate

Who should attend

This class is for those who already use functions, formulas and cell references — but want to enhance their spreadsheets with responsive tables, advanced charts and pivot tables.

Team Pass by Learnit

Excel Intermediate

From $0
Two, 2-hour Modules (9am - 11:30am PT)

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 these 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.

After Intermediate Excel, you'll be ready for advanced Excel training.

Course ID
EXCELIxZcy
Available times
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17 & June 18, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am
June 17, 2021
9:00am-11:30am

Course Outline

Module 3: List/Table Essentials & Charting 

Learning Outcomes:

  1. Create tables to help make analyzing large data sets easier with table tools
  2. Using Filters and Sorting tools on a data sets show the data you are looking for
  3. Create and save visuals and charts for data sets

Topics:

  • What is a well-defined list?
  • Inserting Tables 
  • Flash fill
  • Multi-Level Sorting
  • Removing Duplicates
  • Filtering Records
  • Using Slicers to filter
  • Automatic Subtotals
  • The Quick Analysis Tools
  • Inserting Data Charts
  • Recommended Charts
  • Editing Chart Elements
  • Adding/Removing Data From A Chart
  • Creating Custom Chart Templates
  • Printing Charts
  • Inserting Sparkline

Module 4: Pivot Tables, Protecting & Linking Data

Learning Outcomes:

  1. Find discoveries within data sources using PivotTables
  2. Create Pivot Charts out of PivotTables for visual representations of reports.
  3. Protect and lock worksheets and workbooks to restrict users.

Topics:

  • Creating Pivot Tables From Lists Or Tables
  • Office 365 Pivot Table Enhancements
  • Filtering Pivot Tables
  • Multi-Select Slicers
  • Working With Pivot Charts
  • Data Validation Rules
  • Applying Built In Conditional Formatting
  • Creating Custom Conditional Formats
  • Comments
  • Linking Data
  • Cell, Sheet, And File Protection

Skills covered

No items found.

Excel Intermediate

Reviews

"I learned pivot tables, conditional formatting and just the little hints and tips that I never thought to use before."

Krista W.
Krista W.

"I got a clear understanding of tables, great worksheets were sent that can be used to practice later, and an excitement for pivot tables!"

Adrieanna V.
Adrieanna V.

"Learning a lot new tips. Looking forward to learn more Excel."

Beihong S.
Beihong S.

"So many great new tips. I learned quite a bit. Excellent class!"

Dianna M.
Dianna M.

"Mo's teaching style is focused, informative, attentive, and soothing. The information presented was concise, easy to follow, and valuable."

Nancy K.
Nancy K.