Microsoft Excel

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.

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 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

Logical Functions in Excel

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

Lookup Functions in Excel

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

Ten Must-Know Functions

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

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 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