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

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
Man sitting at a desk with an open computer learning How to Clean Data in Excel

How to Clean Data in Excel – 8 Easy Ways

By Excel University | November 8, 2022 |

Man sitting at a desk with an open computer learning How to Clean Data in Excel

Read More
Holding an Excel formulas cheat sheet in one hand and a pencil in the other

Excel Formulas Cheat Sheet for Beginners

By Excel University | May 17, 2022 |

Excel is one of the most powerful accounting software tools out there, and most of that power comes from the ability to use Excel formulas to automate your work. When you’re first learning how to use them, it’s easy to get a little overwhelmed – luckily, this Excel formulas cheat sheet is here to help…

Read More

Data Validation with ALL CAPS

By Jeff Lenning | November 10, 2016 |

In recent back-to-back webinars, two different attendees asked how to check to see if a user entered a text string with all caps. Specifically, they asked how to set up a data validation rule to determine if all letters are capitalized. So, I figured I would write a quick post about the technique. Objective Let’s just take a moment…

Read More