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? Continue reading
Harvard CEO Ranking
Author Archives → Kevin Lehrbass
The Learning Curve in Excel
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.
Continue reading
Excel Sorting Challenge
In this guest post Alan Murray (computergaga) compares two solutions to a challenging data sorting issue. I know my preference, what about you?
Continue reading
Concatenate Values to Create a Key
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! Continue reading
Dynamic Charts
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. Continue reading
Let Excel’s Solver do the heavy math!
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? Continue reading
Using Microsoft Excel for your hockey pool
See how my Microsoft Excel template can give you an big advantage in your hockey pool! Continue reading
Creating Mondrian Art in Excel
See how my vacation to Montreal inspired me to create Mondrian style art in Excel using VBA. Continue reading
Allocating costs
In this post I’ll show you how to allocate expenses (or any number) over a period of time. I will use years but it could also be months, weeks or days. Continue reading
Ken Puls Power Query Challenge #2
In this post I’ll review my solution to Ken Puls’ Power Query challenge #2. Online challenges are fun and it’s a great way to learn from others. Continue reading