(888) 804-1132


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.
Have more than 6 people for a course? Call us at (888) 804-1132 and ask about our group rates.
SAT Saturday Class
  • June 27
    1 day, 8:00 AM PDT - 3:30 PM PDT
    Presented by Chris Murphy
    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


    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


    Excel Level 2 Brochure 169.47 KB 32 downloads



    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. 

    error: Alert: Content selection is disabled!!