Microsoft Excel

Microsoft Excel Online Training



Microsoft ExcelMastering Excel is a process. Our live online classes offer hands-on experience with an expert instructor to guide you at every step, and a textbook pdf you can keep as a reference. Combine the three Excel class levels for maximum skills, or take a single class to move your talent up a notch. Excel gives you the power to organize, calculate, analyze, update and present your data, helping decision-makers move in the right direction.

$159 / course



PART 1 - Basics Course

This introductory Excel class provides critical skills for new users and lays a foundation for future learning.


  • Navigate the Excel User Interface
  • Use Excel Commands
  • Create and Save a Basic Workbook
  • Enter Cell Data
  • Use Excel Help
  • Create Worksheet Formulas
  • Insert Functions
  • Reuse Formulas
  • Insert, Delete, and Adjust Cells, Columns, and Rows
  • Search for and Replace Data
  • Use Proofing and Research Tools
  • Modify Fonts
  • Add Borders and Colors to Worksheets
  • Apply Number Formats
  • Align Cell Contents
  • Apply Styles and Themes
  • Apply Basic Conditional Formatting
  • Create and Use Templates
  • Preview and Print a Workbook
  • Define the Page Layout
  • Manage Worksheets
  • Manage Workbook and Worksheet Views
  • Manage Workbook Properties
  • Microsoft Office Excel Exam 77-727
  • Microsoft Office Excel Expert Exam 77–728
  • Microsoft Excel Common Keyboard Shortcuts
  • Adding Borders and Colors to Worksheets
  • Basic Excel Customization

Course Preview 0:22

Course Preview Video

Sep 13, 2024

8:30 AM - 4:30 PM


 

PART 2 - Intermediate Course

You have basic Excel knowledge, but you want more. This mid-level class offers skills needed to create customized, advanced Excel workbooks and sheets. You will begin to analyze data by using functions, conditional formatting and PivotTables.


  • Configure Excel Options
  • Customize the Ribbon and the Quick Access Toolbar
  • Enable Excel Add-Ins
  • Use Range Names in Formulas
  • Use Specialized Functions
  • Use Array Formulas
  • Analyze Data by Using Text and Logical Functions
  • Apply Advanced Conditional Formatting
  • Create and Modify Tables
  • Sort Data
  • Filter Data
  • Use SUBTOTAL and Database Functions
  • Create Charts
  • Modify and Format Charts
  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Slicers

Course Preview 0:21

Course Preview Video


To get the most from the intermediate class, you should already know how to:

  • Create, format, save and print a workbook
  • Insert, delete and adjust cells, columns and rows
  • Search for and automatically replace data
  • Use worksheet formulas, functions and formats
  • Manage Worksheets and Workbooks (views and properties)

Mar 29, 2024

8:30 AM - 4:30 PM


Oct 11, 2024

8:30 AM - 4:30 PM


 

PART 3 - Advanced Course

Build on your knowledge from the first two classes. With advanced Excel skills, you can wield the full power of Excel. Advanced skills allow you to get answers from vast amounts of data, use forecasting data, map data and collaborate with colleagues.


  • Use Links and External References
  • Use 3-D References
  • Consolidate Data
  • Use Lookup Functions
  • Trace Cells
  • Watch and Evaluate Formulas
  • Collaborate on a Workbook
  • Protect Worksheets and Workbooks
  • Apply Data Validation
  • Search for Invalid Data and Formulas with Errors
  • Work with Macros
  • Create Sparklines
  • Map Data
  • Determine Potential Outcomes Using Data Tables
  • Determine Potential Outcomes Using Scenarios
  • Use the Goal Seek Feature
  • Forecasting Data Trends
  • Microsoft Office Excel Exam 77-727
  • Microsoft Office Excel Expert Exam 77–728
  • Microsoft Excel Common Keyboard Shortcuts
  • Cube Functions
  • Importing and Export Data
  • Internationalizing Workbooks
  • Working with Power Pivot
  • Advanced Customization Options
  • Working with Forms and Controls

Course Preview 0:31

Course Preview Video


To get the most from the advanced class, you should already know how to:

  • Configure Excel options, customize the ribbon and toolbar, and enable Add-Ins
  • Use range names, specialized functions and advanced conditional formatting
  • Sort and filter data and use database functions
  • Create, modify and format charts
  • Create PivotTables and use them to analyze and present data

May 3, 2024

8:30 AM - 4:30 PM


Nov 15, 2024

8:30 AM - 4:30 PM





Technology Requirements

Registrants must have a computer with internet access, a webcam and mic. Further course preparation instructions will be provided upon registration. Contact Mark Berkowick with questions or concerns.