Loading Events

« All Events

  • This event has passed.

Excel Advanced – Instructor-led Online Series

March 26 @ 9:00 am 4:00 pm

This two day workshop is for experienced users of the Excel program. In this session, we learn some of the more advanced features of Excel, including advanced functions such as lookup, date & time, and financial functions; how to nest functions; Data analysis using Pivot Tables and Pivot Charts; and how to perform What-if Analyses. We also learn how to create forms in Excel. Students should have a good understanding of the basics of the program before taking this course.

Functions & Formulas:

  • Named Ranges
  • Lookup Functions
  • Date & Time Functions
  • Checking for Formula Errors
  • Data Verification
  • Financial Functions
  • Nesting Functions

Pivot Tables & Pivot Charts:

  • Customizing Pivot Tables
  • Filters
  • Data Slicers
  • Grouping Data
  • Creating a Pivot Chart
  • Changing Pivot Chart Options
  • Drilling Down

Creating Forms in Excel:

  • Adding Command Buttons
  • Spin Buttons and Scroll Bars
  • Check Boxes and Option Buttons
  • List Boxes and Combo Boxes
  • Group Box
  • Text Boxes

Performing What-if Analysis:

  • Using the Goal Seek Tool
  • Working with Scenarios
  • Using Cell Watch

Date: March 19 & 26, 2024

Time: 9:00 a.m. – 4:00 p.m.

Cost: $700.00

Location: Online

Instructor: Heather Lyon