22
Jan 2019
- BY Kevin Lehrbass
- POSTED IN Efficiency
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Author: Kevin Lehrbass
13
Jan 2019
- BY Kevin Lehrbass
- POSTED IN Auditing
- WITH 8 COMMENTS
- PERMALINK
- STANDARD POST TYPE
=SUMPRODUCT(MID(G2,{1;2;3},1)*1) I found this formula in a notebook. Can you understand it’s purpose? I’ll explain it in this post. I’ll also expand it for a more complex case. (more…)
04
Jan 2019
- BY Kevin Lehrbass
- POSTED IN Efficiency, Errors
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
The term False Friends is used in various fields including linguistics and chess. In this post I’ll explain how it applies to Microsoft Excel! (more…)
21
Dec 2018
- BY Kevin Lehrbass
- POSTED IN T_Planning
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
My super fit cousin Joe Perry contacted me with a few questions about an Excel spreadsheet he uses to track his running. (more…)
17
Dec 2018
- BY Kevin Lehrbass
- POSTED IN Free Data
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Harvard Business Review ranked the top 100 CEOs with three weighted categories (80%, 10%, 10%). I downloaded their data and added some formulas to modify the weighting. Does it make a difference? (more…)
14
Dec 2018
- BY Kevin Lehrbass
- POSTED IN T_Business, The EXCEL Path
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
I’ve had this ‘Business Formulas’ book sitting around for years. I decided to explore the learning curve formula: (a) create it in Excel and (b) think about the factors that go into learning Excel.
(more…)
28
Nov 2018
- BY Kevin Lehrbass
- POSTED IN Gurus
- WITH 5 COMMENTS
- PERMALINK
- STANDARD POST TYPE
In this guest post Alan Murray (computergaga) compares two solutions to a challenging data sorting issue. I know my preference, what about you?
(more…)
04
Nov 2018
- BY Kevin Lehrbass
- POSTED IN Efficiency, Tips
- WITH 4 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Excel users who don’t know this concept waste hours manually looking through their data. A filter helps but creating a valid lookup key is what Mr Carlson needs! (more…)
21
Oct 2018
- BY Kevin Lehrbass
- POSTED IN Tips
- WITH 0 COMMENTS
- PERMALINK
- STANDARD POST TYPE
Dynamic charts automatically adjust when new data is added in Excel. I’ll show you several ways to create dynamic charts and a few bonus tricks. (more…)
28
Sep 2018
- BY Kevin Lehrbass
- POSTED IN Tips
- WITH 1 COMMENTS
- PERMALINK
- STANDARD POST TYPE
HOW DO WE SOLVE THIS PUZZLE? I’m 7 times as old as Lisa is now. In 20 years Lisa will be just half the age I will be then. How old is Lisa now? (more…)
Do You Excel?
