Intermediate Microsoft Excel


This Intermediate Microsoft Excel training class is meant for students who want to advance their skill set by learning to work with advanced formulas, lists, and illustrations.  Students will also work with charts and advanced formatting including styles.  

Course length: 3 days, Delivery: Online or in-person.

Call us at (475) 328-2227 with questions.


Who Should Attend

Students who have basic skills with Microsoft Excel who want to learn intermediate-level skills or students who want to learn the topics covered in this course in the Microsoft Excel interface.


Course Objectives

  • Learn to use formulas and functions.

  • Create and modify charts.

  • Convert, sort, filter, and manage lists.

  • Insert and modify illustrations in a worksheet.

  • Learn to work with tables.

  • Learn to use conditional formatting and styles.


Class Prerequisites

Experience in the following is required for this Microsoft Excel class:

  • Introduction to Excel  (or Basic Excel)



  • Microsoft Office Excel 2016

  • Microsoft Office Excel 2016 Expert


Upcoming Dates:

Course Overview

Configure worksheets and workbooks

  • Find and Replace Data

  • Review a worksheet or workbook

  • Printing worksheets and workbooks 

Filter and sort data

  • Filter a data table or range

  • Sort worksheet data 

  • Create custom lists

  • Summarize data in worksheets and workbooks

  • Summarize data by using Sparklines

  • Outline data

Manipulate worksheet data

  • Create a simple VLOOKUP using a single value

  • Combine data from multiple sources

  • Create Scenarios

Create charts and objects

  • Create charts

  • Format graphic elements

  • Insert and format objects

Create PivotTable

  • Filter, show, and hide PivotTable data

  • Create dynamic charts by using PivotCharts

Work in Excel More Efficiently

  • Customize the Quick Access Toolbar

  • Customize the Ribbon