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.

Techniques

Woman looking at her laptop computer reading how to find merged cells in Excel

How to Find Merged Cells in Excel (& What You Can Do Instead)

By Excel University | January 24, 2023 |

You’ve probably come across situations where Excel didn’t allow you to make certain changes to your data because some of the cells you selected were merged. But, it can be tough to find merged cells in Excel because they often look so similar to others.  Working with large datasets makes it even more difficult as…

Read More

Skipping Excel 3

By Jeff Lenning | December 13, 2022 |

In this third and final post of the Skipping Excel series, we’ll connect all the dots and use Zapier to complete our automation. In case you are just joining the series … I’ve been documenting my journey for getting my e-commerce sales into QuickBooks Online. In an ideal situation, there would be a direct built-in…

Read More

Skipping Excel 2

By Jeff Lenning | November 29, 2022 |

In this post, the second in the Skipping Excel series, I’ll walk you through the details of the next iteration of this process. In case you are just joining this series, in the first post Skipping Excel 1, I reviewed the manual process of getting my e-commerce transactions into QuickBooks Online. It took about 30…

Read More
Padlock on top of a keyboard that represents how to hide formulas in Excel

How to Hide Formulas in Excel (And Protect Your Worksheets)

By Excel University | October 18, 2022 |

Let’s say you’ve been building a worksheet to share with your coworkers. When you share it, they’ll be able to see, edit, and change everything that’s in the workbook, including your formulas. It can sometimes be a little too easy to make those changes accidentally. That’s why it’s a good idea to lock and even…

Read More
Piggy bank with a clock on top to represent time saved by learning Excel tips and tricks

Top 8 Excel Tips and Tricks to Save You Time

By Excel University | April 5, 2022 |

These top 8 Excel tips and tricks will free up tons of time and allow you to get more work done even faster.

Read More

Create a Dynamic PivotTable Style Report with One Formula

By Jeff Lenning | March 29, 2022 |

Historically, we’ve had two basic ways to create reports in Excel. We could enter the report labels and use formulas to compute the report values or we could use a PivotTable. Both options had pros and cons. We’d have to pick the report type based on the context of our workbook. In this post, I’ll…

Read More

Excel Tips from 25 Experts

By Jeff Lenning | February 8, 2022 |

My friend John Michaloudis does an annual survey of Excel MVPs and experts and asks for their best tip. He compiles the tips into an audio podcast along with show notes and related links. This is a great resource and I love sharing it every year. This year, he rounded up tips from: Bill Jelen…

Read More

Convert Foreign Currencies to USD

By Penny Li | January 4, 2022 |

My name is Penny Li, a cross-border tax accountant, and I often come across instances in my work where I need to convert foreign currencies to US dollar. I have decided to build a foreign currency conversion tool in Excel that is capable of generating single-day as well as average foreign exchange rates for multiple…

Read More

Excel for Budgeting

By Moss Levenson | November 23, 2021 |

Overview During an Excel University webinar, Jeff gave a demonstration of Power Query that related to a company’s annual budget process. Initially, I was not familiar with Power Query but decided to learn it. Ultimately, I was able to incorporate Power Query into our annual budget process, eliminating the need for the software we were…

Read More

PivotTable Text Values Alternative

By Jeff Lenning | September 28, 2021 |

This post show how to use Power Query instead of a PivotTable to display text values in a report.

Read More