13
Feb 2018
- BY Kevin Lehrbass
- POSTED IN Efficiency
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Author: Kevin Lehrbass
08
Feb 2018
- BY Kevin Lehrbass
- POSTED IN Tips
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
How can we rank within groups in Excel? Most experts will tell you to use the SUMPRODUCT function. Why? It’s the only solution they know or maybe they’re concerned about compatibility. Is anyone still using Excel 2003? Let’s compare SUMPRODUCT and COUNTIFS. (more…)
01
Feb 2018
- BY Kevin Lehrbass
- POSTED IN Get & Transform
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
An ounce of prevention is worth a pound of cure but how does this apply to Microsoft Excel? In this post I will show you a common example. Too late for prevention? I’ll show you two solutions. (more…)
29
Jan 2018
- BY Kevin Lehrbass
- POSTED IN Gurus, Solutions
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Last year I started visiting some REDDIT Excel groups. A few weeks ago I saw an interesting Excel question and provided a simple two step solution. (more…)
26
Jan 2018
- BY Kevin Lehrbass
- POSTED IN Auditing, Gurus
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
21
Jan 2018
- BY Kevin Lehrbass
- POSTED IN Efficiency
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Some Excel models have so many complex formulas that they just can’t calculate any more. These models often need to be re-created. Some models can be saved by making formulas more efficient. One technique is to add an OFF SWITCH to heavy formulas. (more…)
17
Jan 2018
- BY Kevin Lehrbass
- POSTED IN Formulas
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
We need to extract unique values from a list to be used in a data validation drop down list. There are many ways to solve this. The best solution depends on asking the right questions. (more…)
13
Jan 2018
- BY Kevin Lehrbass
- POSTED IN Solutions
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Is your data validation list is so long that the endless scrolling makes you want to close Excel and never use it again? This post will review several solutions to this problem. (more…)
11
Jan 2018
- BY Kevin Lehrbass
- POSTED IN The EXCEL Path
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Do you want to become a Microsoft Excel master? The first step might be to convince yourself that it’s possible (it is!). Then, you need some good material and determination! (more…)
07
Jan 2018
- BY Kevin Lehrbass
- POSTED IN Reviews
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Stand-up mathematician Matt Parker did a comedy routine about spreadsheets. Hmm….why not create a post about this? How can I make it interesting? My quest to find an interesting angle led me to….well…creating a YouTube Transcript spreadsheeet! (more…)
Your Excel Coach
