1-866-266-4966info@auroracollege.nt.ca
Transformation

« All Events

  • This event has passed.

Excel Advanced – Instructor-led Online Series

October 30, 2023 @ 9:00 am – 4:00 pm

This 1-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: October 30, 2023
Time: 9:00 a.m. – 4:00 p.m.
Cost: $350.00
Instructor: Heather Lyon

Related Events