- BY Kevin Lehrbass
- POSTED IN Efficiency
- WITH 2 COMMENTS
- PERMALINK
- STANDARD POST TYPE

# Author: Kevin Lehrbass

- 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…)

- 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…)

- 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…)

- 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…)

- 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…)

- 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…)

- 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…)

- 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…)

- 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…)