Course Descriptions

Excel Services Overview

Options for Everyone

ComputerImages has Microsoft Excel services for novices and experts alike. We offer:

  • Public classes,
  • Private classes,
  • One-on-one training, and
  • Consulting.

Public Classes

We offer five different Excel classes at our Boston office. Click any class name for a detailed description.

Excel. Introductory class, no prior Excel knowledge required. Covers the Excel interface and shows you how to write and edit formulas, format cells and their contents, format printed reports, sort and filter data, use the SUM and IF functions and create charts.

Advanced Excel. Designed for Excel users who want to work faster and explore new tools. Covers formulas based on named ranges, cell styles, linking workbooks, date calculations, various functions, recording and editing macros and an overview of Pivot Tables.

Pivot Tables. In-depth Pivot Tables class covers organizing data for analysis, using Tables and advanced filtering with Pivot Table data, creating and updating Pivot Tables, Pivot Table options, Pivot Table calculations, Pivot Charts and working with Slicers.

Excel Macros. Reading and writing VBA, language structure, writing macros, creating message and input boxes, using loops and IF to control program flow, working with variables and constants, using VBA to write to cells and writing custom functions.

Excel Dashboards. Designing a dashboard, deciding what it should do, incorporating conditional formatting and drop downs, using calculations to determine which charts to display, adding slicers, creating a user interface and using worksheet protection to lock portions of the sheet.

Private Classes

Any of our classes can be given for a private group, either at your office or ours. We would be glad to tailor the curriculum to emphasize the features of greatest interest to your group. Our List of Excel Topics can help you decide what’s best. Details.

One-on-One Training

For those who want special help with a particular Excel issue, or prefer to work privately at their own pace. Details.

Project Consulting

Specific guidance on a particular project or workbook We can help you help you conceptualize a project and provide advice on the most effective way to implement it, or provide guidance on specific calculations or other questions. We can also implement part or all of a project if you prefer. Details.

Class Schedule

© Copyright 2019, 2018, ComputerImages. All rights reserved.
URL: / course_descriptions / excel-classes-overview.html
Excel Class Overview, Updated June 5, 2019.