# Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

# Power Pivot

## Learn How to Use Pivot Tables in Excel – Our Top 5 Posts

| April 12, 2022 |

Excel’s PivotTables are one of its most useful features. Learn how to use pivot tables in Excel with our Top 5 PivotTable posts!

## What Excel Skills are Employers Looking For in 2022?

| March 1, 2022 |

Need Excel skills for work? Save time job searching by finding out exactly what Excel skills employers are looking for.

## Treasure Maps 3

| October 26, 2020 |

This is the third post in the Treasure Maps series where we are talking about various ways to implement mapping tables. In this series, we are using mapping tables to help translate labels between the data and the report. In the first post, we used SUMIFS to pull the values into the mapping table. In…

## Power BI CalCPA Article

| January 9, 2019 | Comments Off on Power BI CalCPA Article

You’ve heard the terms “Power BI,” “Power Query” and “Power Pivot,” but maybe aren’t sure what they are. Good news! They are free tools from Microsoft and this article will talk you through them. And, while we’re at it, we’ll also talk about Pivot Tables and Pivot Charts. Power and Pivot

## Impossible PivotTables 4 – Average of Distinct Count

| July 24, 2018 |

This is the 4th and final post in the Impossible PivotTables series, where we are exploring Power Pivot by looking at some limitations encountered with traditional PivotTables. In this post, we’ll look at how to compute the average when there are multiple rows per item. That is, where a simple sum divided by the count…

## Data Model Walkthrough CalCPA Article

| July 17, 2018 |

Have you heard people talking about Power Pivot and the data model, but you aren’t exactly sure what they are or how to use them? Well, in this article, we’ll use them to build a basic PivotTable. Workbooks used to summarize exported data can potentially be improved by using Power Pivot and the Data Model. Check…

## Impossible PivotTables 3 – Multiple Data Tables

| July 10, 2018 |

This is the 3rd post in the Impossible PivotTables series. This series is designed to explore Power Pivot. I thought looking at a few limitations of traditional PivotTables would be a fun way to do this. So, in this post, we will look at how traditional PivotTables support a single data table while Power Pivot…

## Impossible PivotTables 2 – Show Values As

| July 2, 2018 |

This is the second post in the Impossible PivotTables series, where we are exploring Power Pivot. In the first post, we examined the limitation of calculated field references in a traditional PivotTable. In this post, we’ll address the limitation of using the Show Values As option for subsequent calculations. If we use the Show Values…

## Impossible PivotTables 1 – Calculated Fields

| June 27, 2018 |

This is the first post in a series called Impossible PivotTables. The purpose of this series is to explore Power Pivot. I thought a fun way to do that would be to demonstrate how using the data model enables us to build PivotTables that are either impossible with traditional PivotTables or that require workarounds. I…