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.

Map

Treasure Maps 3

By Jeff Lenning | 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…

Read More

Treasure Maps 2

By Jeff Lenning | October 19, 2020 |

This is the second post in the Treasure Maps series, where we are discussing various ways to implement mapping tables. In the first post, we covered SUMIFS. In this post, we’ll talk about Power Query. Overview Let’s say we have a list of transactions in a CSV file, like this: We would like to use…

Read More

Treasure Maps 1

By Jeff Lenning | October 13, 2020 |

This is the first post in the Treasure Maps series, where we’ll be discussing the treasure (efficiency) that can be achieved by using mapping tables. Let’s review the big picture before jumping into the mechanics. Let’s say we export some data from a system, and it looks something like this (we’ll call this Point A):…

Read More

Geography Data Type

By Jeff Lenning | December 5, 2018 |

As a quick follow up to my previous post about the Stocks data type, I wanted to talk about another data type: Geography. With the Geography data type, we can retrieve rich geographical data into Excel. Let’s check it out. Objective Let’s say we are working on a project and we wanted to create a…

Read More