How to Analyze Data Using Excel PivotTables. By Helen Bradley. Aug 15, 2012 6:00 pm PDT.

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.

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.

Learn how Power Query, Power Pivot, and VBA can transform your Excel skills. Choose the right tool and boost your ...

Using Excel’s PivotTables and PivotCharts, you can quickly analyze large data sets, summarize key data, and present it in easy-to-read format. Here’s how to get started with these powerful tools.

Select B4:C4, click Data, and then choose Scenario Manager from the What-If Analysis drop-down in the Data Tools group. In the resulting dialog, don’t change anything. You’ve already set it ...

The first focuses on data retrieved from a company's financial statements (fundamental analysis), which can provide Excel with the building blocks for advanced equations.

Key Points NORMSINV is an Excel function used along with normal distributions. It allows you to conduct calculations faster ...

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