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.

Speed Loop

Speed Loop 3: Realize Gain

By Jeff Lenning | April 14, 2020 |

This is the third and final post in the Speed Loop series. In the first post, we identified and prepared our recurring-project workbooks for speed. In the second post, we increased their value by improving efficiency and accuracy. Now it is time to leverage our time savings. The final step is: Realize Gain. Before we…

Read More

Speed Loop 2: Appreciate Assets

By Jeff Lenning | April 6, 2020 |

This is the second post in the Speed Loop series, where I’m sharing the process that helped me dramatically improve efficiency. In the first post, we covered the Invest Time stage. We identified our recurring-project workbooks. We inserted our lead sheets. We are now ready to move on to the second stage: Appreciate Assets. Let’s…

Read More

Speed Loop 1: Invest Time

By Jeff Lenning | March 30, 2020 |

To work fast in Excel, you need two things: process and skills. Having one without the other means you may not be maximizing efficiency. By process, I mean the overall framework, strategy, or approach you use to optimize your workbooks. By skills, I mean Excel skills like XLOOKUP, SUMIFS, PivotTables, and Power Query. Both process…

Read More