Mastering 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: 2 hours. Can include up to 15 attendees in one session.

Data Design and PivotTables

Intermediate

Many users assume that Microsoft Excel information is already in a Table. It has lines and rows and columns – oh my! Truthfully, the core power of Excel only comes out when you convert that information into Tables and PivotTables. It’s so easy to filter and sort your information that …Read the full article

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

Advanced Formulas and Functions

Advanced

Matching data between two sets of information is one of the first tools that most advanced Microsoft Excel users learn. For example, it allows you to take an account number from one list and look up the payments from another list. It forever relieves you of manually filtering data and …Read the full article

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