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
Need more details? Contact us
We are here to assist. Contact us by phone, email or via our Social Media channels.