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.


UPPER lower Proper Case (3 ways)

By Jeff Lenning | December 5, 2023 |

The objective of this tutorial is to demonstrate three different methods to change the case of text in Microsoft Excel: Flash Fill, formulas, and Power Query. By the end of this tutorial, you will be confident in using these techniques to convert text to upper case, lower case, and proper case. Video Walkthrough Let’s walk…

Read More

Excel How To Join or Combine Text (3 ways)

By Jeff Lenning | October 3, 2023 |

Welcome to this tutorial on combining text in Excel! In this post, we will explore three different ways to join or combine text values in Excel. Whether you want to use Flash Fill, concatenation, or the TEXTJOIN function, we will cover them all. So let’s get started! Video Step-by-step Tutorial The objective of this tutorial…

Read More
Woman quickly entering data sets on two computer monitors using the Excel fill handle

How to Save Time Using the Microsoft Excel Fill Handle

By Excel University | August 30, 2022 |

Long lists of data can be time-consuming to enter in Excel. Here’s how to use the Excel fill handle to save yourself hours of work!

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

Flash Fill Times

By Jeff Lenning | November 26, 2019 |

Flash Fill is a marvelous feature that is designed to fill values down based on an example in an adjacent column. That is, you have a column of values and then you enter an example of a derived value in an adjacent column. Flash Fill attempts to recognize the pattern from your example and then…

Read More
FlashFill Meets GNT by Jeff Lenning

FlashFill Meets Get & Transform

By Jeff Lenning | June 20, 2017 |

Do you love FlashFill? Do you love Get & Transform queries? If so, you’ll love the most recent Excel update pushed out by Microsoft: New Column by Example. It is essentially FlashFill inside PowerQuery. It is way cool. Check it out. Objective Let’s say we have some data. It doesn’t matter where it is, it…

Read More

FlashFill is an Alternative to CONCATENATE and Text-to-Columns

By Jeff Lenning | August 15, 2013 |

Have you ever split one column in to many columns, or vice versa, combined many columns into a single column?  If so, you have likely relied on the text-to-columns feature to split a single column into many and the CONCATENATE function to join many columns into a single column.  Beginning with Excel 2013, Microsoft provides…

Read More