Microsoft Excel Classes
Microsoft Excel is the meat and potatoes of data analysis. It’s where all of the grunt work gets done in building reports and dashboards, and can be used as either a flat- or 3-D-database. Whether you’re tracking a budget or a list of projects, you want to be fluent in all that Excel has to offer.
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
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
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
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
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
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
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
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
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
Document Structure in Office and Acrobat
Most everyone has had the experience of groping around in a dark room trying to find the light-switch. People who... Read More