Learn how to use one of the most powerful tools Microsoft Excel has to offer.

PivotTables work in a similar way to Excel's PIVOTBY function —they're both great tools for summarizing and reorganizing data for detailed analysis. However, the methods for using them differ ...

If you've have lots of data and lots of analysis to do, but little time or skill, you need Excel's Power Pivot feature. Here's how to get started with it.

Find out how to perform financial analysis through Microsoft Excel, a widely used business management software among finance professionals and investors.

Microsoft Excel, provides a comprehensive set of tools that enable you to harness the power of the Pareto Principle in your data analysis.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Much of the data that you use Excel to analyze comes in a list form. You might need to sort the data, filter it, sum it, and perhaps even chart it. Excel tables provide superior tools for working ...

The Data Analysis for Excel Video Series is designed to supplement Lesson 3 in the AQ-IQ curriculum. Learn about units of Air Quality PollutantsAQ-IQ Mentor Elise Mesenbring explains the concentration ...

Computer-assisted qualitative data analysis software is too advanced and sophisticated when all we want is to sort and structure the text. A new method, using Microsoft Word and Excel, has been ...