Excel Classes

Quick Tips for Excel
People who can make Microsoft Excel dance are the envy of their co-workers. Truth be told, these 10 simple steps... Read More



Ten Must-Know Functions
There are almost 500 functions built into Microsoft Excel, but the vast majority of work is carried out by these... Read More




Avoid Manual Formatting with Conditional Formatting
We’ve all seen the worksheet where someone painstakingly color-coded information based on its status, amount, or next steps. But what... Read More




Visualize Information with Charts
If a picture is worth a thousand words, why are you writing so much? Charts are a great way to... Read More




Tables and PivotTables for Beginners
Many users assume that Microsoft Excel information is already in a Table. It has lines and rows and columns –... Read More






Lookup Functions in Excel
Matching data between two sets of information is one of the first tools that most advanced Microsoft Excel users learn.... Read More






Logical Functions in Excel
Microsoft Excel allows you to perform many amazing calculations by combining logical functions with operation functions. For example, “count how... Read More






PivotTables for Data Geeks
When you’ve progressed beyond the bare basics of PivotTables you start to realize how much more is possible by linking... Read More






Dashboards with Pivot Charts, Power Query and Power Maps
A dashboard is the holy grail of data. You allow non-data users to interact with your data in a way... Read More






The Data Model and DAX Formulas
Microsoft has created a special language to write formulas and measures for PivotTable and Power PivotTable data called DAX. Though... Read More