Fundamental

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

This entry was posted in Excel, Webinars and tagged , , .

Fundamental

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

This entry was posted in Excel, Webinars and tagged , , .

Intermediate

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

This entry was posted in Excel, Webinars and tagged , , .

Intermediate

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

This entry was posted in Excel, Webinars and tagged , , .

Intermediate

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

This entry was posted in Excel, Webinars and tagged , , .

Advanced

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

This entry was posted in Excel, Webinars and tagged , , .

Advanced

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

This entry was posted in Excel, Webinars and tagged , , .

Advanced

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

This entry was posted in Excel, Webinars and tagged , , .

Advanced

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

This entry was posted in Excel, Webinars and tagged , , .

Advanced

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

This entry was posted in Excel, Webinars and tagged , , .