Mastering Formulas and Functions in Excel
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 more…
Class Length: 2 hours. Can include up to 15 attendees in one session.
Data Design and PivotTables
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 more…
Class Length: 2 hours. Can include up to 15 attendees in one session.
Advanced Formulas and Functions
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 more…
Class Length: 2 hours. Can include up to 15 attendees in one session.