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
As a motorcycle safety instructor, I tell new riders that learning to ride a motorcycle is like showering. One shower does not keep you fresh and clean the rest of your life, just like taking one motorcycle class does not give you everything you need to stay safe on a motorcycle. You need to practice…
Read More
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
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
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