Basic Excel--Level 1 (2 classes--attend both or either one)

Microsoft Excel-Introduction:

​

One session. (There are no currently scheduled classes. Contact us if you are interested in this class.)

​

• Spreadsheet navigation

• Data entry

​​

Applies to any version of Microsoft Excel for Windows from 2007 to 2016.

Prerequisite: Basic computer skills

​

​

​

​

Microsoft Excel-Formatting & Formulas:

​

One session.  (There are no currently scheduled classes. Contact us if you are interested in this class.)

​

• Format

• Print

• Create and use basic formulas

​​

Applies to any version of Microsoft Excel for Windows from 2007 to 2016.

Prerequisite: Basic computer skills

​

​

​

Using Excel to Manage Data--Excel Level 2

(There are no currently scheduled classes. Contact us if you are interested in this class.)

​

• Set up database

• Enter data with drop down lists or data forms

• Sort or filter to manipulate data

• Group and subtotal data

​

Applies to any version of Microsoft Excel for Windows from 2007 to 2016.

Prerequisite: Basic Excel skills

​

​

​

Pivot Tables--Excel Level 2

(There are no currently scheduled classes. Contact us if you are interested in this class.)

​

• What are pivot tables

• How to create pivot tables

• Work with one and two dimensional pivot tables

• Filter results

• Change calculations

​

Applies to any version of Microsoft Excel for Windows from 2007 to 2016.

Prerequisite: Basic Excel skills

​

​

Excel Charts/Graphs--Excel Level 2

There are no classes currently scheduled for this topic. If you would like to take this class in the future, or would like some tutoring on this topic, please contact us​.

​

• Translate numerical information into a chart (graph)

• Understand charts elements

• Change design and formatting

​

Applies to any version of Microsoft Excel for Windows from 2007 to 2016.

Prerequisite: Basic Excel skills

VLOOKUP for Microsoft Excel or Google Sheets--Level 2

No classes are currently scheduled. Please contact us if you are interested in attending this class in the future or if you would like one-on-one tutoring.

​

• Learn the basics of VLOOKUP in Microsoft Excel or Google Sheets

• Join data from different sources

• If using Google Sheets, bring your user name and password to class

​

Applies to any version of Microsoft Excel for Windows from 2007 to 2016.

Prerequisite: Basic Excel skills

​

​

​