Excel Intermediate

Who should attend

This class is for anyone who manages, creates or edits large spreadsheets of data and would like to efficiently analyze, summarize, and visualize data. Knowledge of Excel Introduction preferred.

Team Pass by Learnit

Excel Intermediate

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

Microsoft Excel is the most commonly used spreadsheet application. Learning how to use Excel is an investment in both your personal and professional life. Excel makes it easy to monitor financial performance, such as business profit or loss, calculate payments on large purchases, plan a budget, or stay organized with checklists.

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