Quick Tips for Excel

Fundamental

People who can make Microsoft Excel dance are the envy of their co-workers. Truth be told, these 10 simple steps will propel you into their ranks as you learn that you don’t have to do everything the hard way. Come to the easy side of Excel and learn the secrets …Read the full article

Class Length: 1 hour. Can include up to 50 attendees in one session.

Ten Must-Know Functions

Fundamental

There are almost 500 functions built into Microsoft Excel, but the vast majority of work is carried out by these top-ten powerhouses. Starting with the venerable Sum function, you’ll quickly move into Aggregate functions that will count how many, calculate the highest number and average large sums. But functions are …Read the full article

Class Length: 1 hour. Can include up to 50 attendees in one session.

Avoid Manual Formatting with Conditional Formatting

Intermediate

We’ve all seen the worksheet where someone painstakingly color-coded information based on its status, amount, or next steps. But what to do when the next set of data comes in? Why, re-do all that work, of course! But when you learn about Conditional Formatting, you’ll learn that all that work …Read the full article

Class Length: 1 hour. Can include up to 50 attendees in one session.

Visualize Information with Charts

Intermediate

If a picture is worth a thousand words, why are you writing so much? Charts are a great way to convey complex data in a meaningful visual format. In fact, studies have proven conclusively that readers will look at a chart and trust it before they will the accompanying data. …Read the full article

Class Length: 1 hour. Can include up to 50 attendees in one session.

Tables and PivotTables for Beginners

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: 1 hour. Can include up to 50 attendees in one session.

Lookup Functions in Excel

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: 1 hour. Can include up to 50 attendees in one session.

Logical Functions in Excel

Advanced

Microsoft Excel allows you to perform many amazing calculations by combining logical functions with operation functions. For example, “count how many projects were completed ahead of time,” can be restated as “if a project was completed ahead of time, then count it.” Once you understand the lingo, the world of …Read the full article

Class Length: 1 hour. Can include up to 50 attendees in one session.

PivotTables for Data Geeks

Advanced

When you’ve progressed beyond the bare basics of PivotTables you start to realize how much more is possible by linking information from disparate sets and formatting it for other users to understand. The world of data will open up as you learn about the 3-D data model and the building …Read the full article

Class Length: 1 hour. Can include up to 50 attendees in one session.

Dashboards with Pivot Charts, Power Query and Power Maps

Advanced

A dashboard is the holy grail of data. You allow non-data users to interact with your data in a way that provides meaningful button-driven interfaces with visual Pivot Charts and Power Maps. Power Query is the behind the scenes beast that makes all of this possible, and even provides you …Read the full article

Class Length: 1 hour. Can include up to 50 attendees in one session.

The Data Model and DAX Formulas

Advanced

Microsoft has created a special language to write formulas and measures for PivotTable and Power PivotTable data called DAX. Though remarkably similar to regular Excel formulas, these new functions include filtering in the function and bridging the gap between database languages like SQL and traditional Excel. If you are a …Read the full article

Class Length: 1 hour. Can include up to 50 attendees in one session.