Loading Events

« All Events

  • This event has passed.

Excel Advanced (CMPT 0269) – Instructor-led Online Series – Online / Multi-Day

Event Series Event Series (See All)

June 27 @ 9:00 am 4:00 pm

This 2-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: June 20 & 27, 2024
Time: 9:00 am – 4:00 pm
Cost: $700.00
Instructor: Heather Lyon