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.
Training
My Excel-friend John Michaloudis has compiled a podcast with tips from 18 Excel experts and MVPs. He does this annually, and this year he has put together a great collection of tips. This year, you’ll hear tips from: John Michaloudis Jeff Lenning Bill Jelen Mynda Treacy Chandoo Kasper Langmann Alan Murray Jon Acampora Danielle Stein…
Read More
Excel is big … really big. It has hundreds of functions and features, but which of these have the most potential to save time and help us work faster? The answer depends on what you’re working on. For common accounting and finance tasks, I believe the following 10 Excel skills can help improve the efficiency…
Read More
The next Excel breakout puzzle is ready! And it’s a goodie 🙂 I realize fall doesn’t officially start for a few weeks, but, our kids start school next week and so it already feels like fall is upon us. Fall means back-to-school, cooler weather, falling leaves, and … american football. My son plays, and so…
Read More
In this post, we are going to use the data model to improve our reporting process. This is the fourth post in the Stop Wasting Time series, and this is where everything we’ve learned comes together. By the time we have finished this post, updating our report will be extremely easy. In fact, it will…
Read More
I think it’s about time for another breakout puzzle … yes! This breakout puzzle has an astronomy theme … you know, stars, constellations, the milky way, telescopes, and so on. I’ve always enjoyed looking up at the night sky. Being able to recognize stars and constellations helps me feel at home when I travel to…
Read More
I am thrilled to announce this year’s Excel University scholarship winners! These scholarships are supported by the Excel University Alumni Association, so thanks to all of you who have helped make these awards possible! A special thank you this year to Gary Zeune of The Pros and The Cons who has generously donated time helping…
Read More
I think it’s about time for another breakout puzzle … yes! This breakout puzzle is inspired by The Matrix. The Matrix? Yes, the movie, you know … with Neo. If you haven’t seen it, it was a popular movie about 20 years ago. (Wow does time fly.) Anyhow, I love that movie and so decided…
Read More
It is time for another breakout puzzle … yay! Have you ever played Sudoku? My family loves doing these puzzles, in fact, last week we had a full-on Sudoku race and competition. Who won? Not me. My daughter totally crushed it. I’d get like 5 squares done, and she’d be like, “done!” Again and again.…
Read More
It is time for another Excel Breakout Puzzle! Excel Breakout Puzzle? Yes … they are totally fun 🙂 You have to use your Excel knowledge and skills to find the hidden code. I’ve hidden a 5 digit code in an Excel workbook, and if you are up for the challenge, see if you can find…
Read More
My Excel-friend John Michaloudis does an annual interview of Excel experts from all over the world. The format of his interview is an audio podcast. This year, you can hear directly from 20 Excel experts as they share their best Excel tips and ideas. The tips include shortcuts, functions, and features, and it is a…
Read More