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