ComputerImages
Course Descriptions

Advanced Microsoft Excel Class

What You Will Learn

This workshop is designed for Excel users who want to use the program more efficiently, have it automate tasks and work with functions and data analysis tools. Class discussion and exercises cover —

  • Using named ranges to write formulas and navigate within a workbook,
  • How to define and apply reusable cell format styles,
  • Formulas that link to cells in other Excel workbooks,,
  • How date and time calculations work in Excel,
  • How functions work, using the Function wizard, required versus optional arguments, use of common Date, Logical, Lookup and Statistical functions,
  • Recording and editing macros,
  • How to decide what steps to include in a macro,
  • When to record a macro using Relative References, and
  • How to create and modify a Pivot Table.

6 hours, $260 (available for Windows and Macintosh)
Purchase with Excel class for discounted package price of $430.

Training Format

  • Live trainer in room — not on-line or remote learning,
  • Exercise-based, hands-on classroom instruction,
  • Emphasis on questions and student participation,
  • Small size (limited to 8), personal attention.

Class Location

Dates and Registration

Prerequisites

Knowledge of fundamental Excel operations, including entry of data and formulas, autofill, relative and absolute cell references, worksheet formatting, autosum and IF function, sorting and charting.

RELATED CLASSES

Classes: Excel, Excel Dashboards, Excel Macros and Pivot Tables.

We also offer consulting, private classes and one-on-one training. See Excel Services page for more information.

Mailing List and Further Information

Monthly newsletter and schedule: join our Mailing List.
For more information, please contact us.

Class Schedule · ComputerImages Excel Resources · Excel Support Links · Excel Tips

© Copyright 2018, 1995, ComputerImages. All rights reserved.
URL: www.computerimages.com / course_descriptions/ d_adv_excel_class.html
Advanced Microsoft Excel Course Outline, Updated April 24, 2018.