• Black Google+ Icon
  • Black Facebook Icon

© 2017 by Tech Help

Call 269-428-7226
Microsoft Excel

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

Please reload

 
 
 
Need more details? Contact us

We are here to assist. Contact us by phone, email or via our Social Media channels.