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.

LOWER

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