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.

Excel

Text Toolkit by Ablebits

By Jeff Lenning | July 20, 2021 |

This is the next post in the Add-Ins series, where we are exploring various add-ins that enhance and extend the capabilities of Excel. In this post, we’ll take a look at Text Toolkit by Ablebits. In summary, it enables us to easily make changes to text without writing formulas. What types of changes? Many! Examples…

Read More

CalCPA LET Article

By Jeff Lenning | July 6, 2021 |

Often, our Excel formulas are simple and short. As such, they are easy to read, understand and maintain over time. But, as the complexity of our workbooks increases, so can the complexity of our formulas. Sometimes, we end up with unwieldy formulas that are long and difficult to understand and maintain. One cause for such…

Read More

Geographic Heat Map

By Jeff Lenning | June 30, 2021 |

This is the fourth post in the Add-Ins series, where we are exploring various add-ins that enhance and extend the capabilities of Excel. In this post, we’ll take a look at the Geographic Heat Map add-in. In summary, it enables us to easily visualize data on a map. Objective Before we examine the details, let’s…

Read More

Visio Diagram from Excel Data

By Jeff Lenning | June 22, 2021 |

This is the third post in the Add-Ins series, where we are exploring various add-ins that enhance and extend the capabilities of Excel. In this post, we’ll take a look at the Microsoft Visio Data Visualizer add-in. In summary, it enables us to easily convert Excel data into a Visio diagram inside of Excel. It…

Read More

Bing Maps

By Jeff Lenning | June 8, 2021 |

This is the second post in the Add-Ins series, where we are exploring various add-ins that enhance and extend the capabilities of Excel. In this post, we’ll take a look at the Bing Maps add-in. In summary, this add-in makes it easy to plot location data from a worksheet column onto a map. It supports…

Read More

People Graph

By Jeff Lenning | May 26, 2021 |

This is the first post in a series where we’ll be exploring various add-ins that enhance and extend the capabilities of Excel. There are different types of add-ins and in this series, we’ll focus on those available in the Excel app store. Excel app store? Yep! Well, it isn’t technically an Excel app store ……

Read More

CalCPA LAMBDA Article

By Jeff Lenning | May 17, 2021 |

Excel has a lot of useful functions: FILTER, SUMIFS, VLOOKUP, XLOOKUP, SUM, SUBTOTAL and more. All in, Excel has about 500 functions, so it’s likely there’s one that returns the result you need. But now and again you may find yourself where there isn’t a built-in function that returns the value you are trying to…

Read More

Paste Special Add

By Jeff Lenning | April 13, 2021 |

In addition to the standard Copy and Paste commands, Excel offers a variety of options for pasting values and formulas. In this post, I’ll chat about one of those options … Paste Special Add. It works with values AND formulas. Let’s dig in. Overview Before we get into the details, let’s zoom out for a…

Read More

Hide and Unhide Multiple Sheets

By Jeff Lenning | April 6, 2021 |

Hiding a single worksheet from view is fairly straightforward … you can right-click the tab and select Hide. Hiding multiple worksheets at the same time is also fairly straightforward. You select multiple sheets by holding down Ctrl or Shift, and then right-click and select Hide. It is also fairly straightforward to Unhide a single sheet.…

Read More

Pivot Text Values with Power Query

By Jeff Lenning | March 23, 2021 |

In this post, we’ll talk about how to Pivot text values with Power Query. We would like to do this even if there are a variable number of fields per record. This can be REALLY hard to visualize based on a short text description, so I think it is best to show screenshots of the…

Read More