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

Make Quick Work with these 10 Excel Skills

By Jeff Lenning | September 18, 2019 |

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

Excel Breakout Puzzle 7

By Jeff Lenning | August 12, 2019 |

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

Stop Wasting Time 4

By Jeff Lenning | May 6, 2019 |

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

Excel Breakout Puzzle 6

By Jeff Lenning | April 23, 2019 |

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

2018 Scholarship Winners

By Jeff Lenning | August 29, 2018 |

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

Excel Breakout Puzzle 5

By Jeff Lenning | August 7, 2018 |

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

Excel Breakout Puzzle 4

By Jeff Lenning | April 24, 2018 |

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

Excel Breakout Puzzle 3

By Jeff Lenning | April 18, 2018 |

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

Tips from 20 Excel Experts

By Jeff Lenning | February 7, 2018 |

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

Excel University Graduate Certification + Breakout Puzzle :)

By Jeff Lenning | August 2, 2017 |

I am super excited to announce the next Excel University course! It is an Excel certification course, so upon completion, you’ll be a Certified Excel University Graduate. I want to cover some of the high points in this post, and then provide a link with additional information. Plus, I’d like to share my next Excel…

Read More