Learn how to use Excel’s dynamic array formulas to automate data pairing, save time, and unlock new insights in your analysis. Excel arrays ...

Excel's PIVOTBY function allows you to group your figures without needing to recreate your data in a PivotTable. What's more, ...

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Learning how to perform statistical data analysis in Microsoft Excel can help you improve your analytics and reporting. This guide takes you ...

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? A. The PIVOTBY function in ...

Just as Excel can perform basic data analysis functions, it has a surprising number of data visualization tools under the hood.

Using What-If Analysis, you can visualize the effects of different variables, making it easier to assess risks and opportunities. In Excel, three primary tools are available for performing What-If ...

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

Microsoft Excel gives users the flexibility to configure data and perform very basic operations, such as addition, subtraction, multiplication, or division by using shortcuts or custom formulas. This ...

Success in business and science means making smart decisions. And those require the kind of information you can only get from sophisticated data analysis. It’s a growing field with huge opportunities.