Excel_256x256.png

Choose your timezone

Register Below or Call (888) 804-1132
and Talk to a Training Specialist Today

$50 off each course when you book more than one course or more than one person per course. Discount will be applied at checkout.
Class sizes are kept small for a better learning experience. Limited to 15 people per class.
  • October 27
    1 day, 8:00 AM PDT - 3:30 PM PDT
    Presented by Michel Wakim
    Online via Zoom
    $350.00 per person
None of these dates work for you? Suggest another date & time

Want to run this as a private class for your team? Enquire about running this event as a private class

Description

This course builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel: how to manage complex workbooks, build more complex functions, use data analysis tools, and make an impact with powerful chart and presentation features.

Using Multiple Worksheets and Workbooks

  • Working with Multiple Worksheets
  • Freezing Panes
  • Viewing and Arranging Multiple Worksheet Windows
  • Navigating in Multiple Workbooks
  • Selecting and Viewing Multiple Workbooks
  • Moving and Copying Data Between Worksheets
  • Working with Named Ranges

Basic and Advanced Charting

  • Creating a Chart
  • Changing Chart Type, Style and Chart Sub-Type
  • Changes to the Chart Source Data
  • Add Data to an Existing Chart
  • Remove Data from a Chart
  • Managing Chart Objects
  • Moving and Resizing Chart Objects
  • Deleting Chart Objects
  • Adding Data Series
  • Formatting Chart Objects
  • Printing Charts

Working with Lists and Tables

  • Sorting and Filtering Data
  • Creating a Table
  • Quick Format a Table
  • Using Structured References
  • Using Data Validation

Summarizing Data

  • Using Consolidation
  • Getting Subtotals

PivotTables and PivotCharts

  • Working with PivotTables and PivotCharts
  • Identifying the Parts of a Basic PivotTable
  • PivotTable Reports
  • Create a PivotTable from Worksheet Data
  • Create a PivotChart Report from an Existing PivotTable Report

Using Slicers in PivotTables

  • Using Slicers
  • Formatting Slicers for a Consistent Look

Using Sparklines to Analyze Data

  • Types of Sparklines
  • Create a Sparkline
  • Customize Sparklines
  • Control which Value Points are Shown
  • Change the Style and Format Sparklines
 

Prerequisites

The course assumes you know how to use a computer, that you're familiar with Microsoft Windows, and that you've taken the Level 1 course or have equivalent introductory experience with Excel. 

Who should attend?

Those who want to use Excel to perform real-world tasks, such as rearranging and presenting complex data.