Behind the Spreadsheet in Excel

Fundamental

Peek behind the spreadsheet and learn Microsoft Excel the right way. Because so many adult learners are self-taught, there are often basic skills that we fail to pick up. This class assumes you have opened the program but aren’t secure that you know all the basics.   Keyboard Shortcuts Creating …Read the full article

Class Length: 4 hours. Can include up to 15 attendees in one session.

Formulas and Functions in Excel

Intermediate

Formulas and Functions are the meat and potatoes of Microsoft Excel. They are the tools that give the program power to achieve our goals. We’ll review the basics of Formulas and Functions in this class before diving headlong into more advanced Functions. This class also takes a look at special …Read the full article

Class Length: 4 hours. Can include up to 15 attendees in one session.

Visual Communication in Excel

Intermediate

Collecting data and storing it is just one part of the Microsoft Excel toolkit. In fact, all those columns of numbers wouldn’t be worth much if we couldn’t communicate them to other people. This class will explore the impressive array of tools built in to the program that will help …Read the full article

Class Length: 3 hours. Can include up to 15 attendees in one session.

Data Analysis in Excel

Advanced

Now that you’ve got all of that information, what are you going to do with it? Senior managers and entry-level personnel all benefit from taking this class, where you’ll learn the ins and outs of Pivot Tables and Charts, as well as how to import data from databases.  Creating Pivot …Read the full article

Class Length: 4 hours. Can include up to 15 attendees in one session.

Macros in Excel

Advanced

Long thought to be the province of supergeeks, macros will come alive in this exciting class. You will learn how to record macros, be introduced to the Visual Basic programming language, and write simple code statements The Developer tab on the Ribbon Recording Macros Playing back Macros with Keystrokes Adding …Read the full article

Class Length: 4 hours. Can include up to 15 attendees in one session.