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.

Keyboard Shortcuts

Man multitasking while using Microsoft Excel macros to make his spreadsheets faster

Make Your Spreadsheets Faster Using Microsoft Excel Macros

By Excel University | August 2, 2022 |

Do you use Excel frequently and find that you often have to repeat the same tasks over and over? If so, you can use Microsoft Excel macros to automate those tasks and cut down on how much time it takes to complete them! You can create a macro by recording your keystrokes and mouse clicks,…

Read More
Woman looking through a magnifying glass at how to highlight duplicates in excel

How to Highlight Duplicates in Excel

By Excel University | July 26, 2022 |

A duplicate value is a value that shows up more than once in a spreadsheet. These pop up all the time when working with datasets, and they can be tedious to sort through if you don’t know the quick ways to find them. Learn how to highlight duplicates in Excel to make the process take…

Read More
Woman pointing to the left while thinking about advanced Excel tips

Even Pros Could Learn a Thing or Two From These 8 Advanced Excel Tips

By Excel University | June 21, 2022 |

Looking for some advanced Excel tips to help you become a spreadsheet pro? We’re sharing 8 tips that will take your skills to the next level!

Read More
Man sitting at a computer with an hourglass trying to learn how to get better at Excel

How to Get Better at Excel (Without Wasting Time)

By Excel University | April 25, 2022 |

Wondering how to get better at Excel? Whether you’re a new user or a pro, these are some easy steps to help you quickly master new skills.

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

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: You’ll definitely…

Read More

Excel Speed: Hidden Commands and QAT Buttons

By Jeff Lenning | October 23, 2018 |

Working fast is about knowing features and functions, for sure, but, it is also about how quickly we communicate with Excel. We can set up QAT buttons to activate frequently used commands … and … hidden commands. Hidden commands? Yes … Excel has far more commands than are provided in the standard ribbon tabs. It…

Read More

Excel Speed: 3 Keyboards Shortcuts worth Memorizing

By Jeff Lenning | October 17, 2018 |

In addition to knowing which features and functions can help you work faster in Excel, knowing a few keyboard shortcuts will help as well. You see, the faster you can communicate with Excel the faster you’ll get your Excel-work done. So, in this post, I’ll talk about 3 of my most-used shortcuts and then show…

Read More

Accounting Number Formats QAT

By Jeff Lenning | January 20, 2016 |

Excel has cell formatting designed just for accountants. Not surprisingly, it is called the Accounting Number Format. The built-in ribbon commands apply the format with two decimals and the currency symbol. This post demonstrates how to set up two handy QAT icons so that we can quickly apply this format with no decimals and without a currency…

Read More

Create Keyboard Shortcuts for your Favorite Excel Commands

By Jeff Lenning | June 19, 2014 |

Generally, you can improve your speed by keeping your hands on your keyboard. But, what do you do if there is no built-in keyboard shortcut to execute your favorite command? Well, one approach is to customize the QAT. This post discusses the Quick Access Toolbar and the related keyboard shortcuts it creates. QAT Shortcuts Microsoft…

Read More