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.

What is the Learning Curve?

It’s based on the proposition that labor hours decrease in a definite pattern as labor operations are repeated….based on the statistical finding that as cumulative production double, cumulative average time required per unit will be reduced by some constant percentage, ranging typically from 10% to 20%

For me, necessity & curiosity are incredible factors in the learning process.

By necessity I learned T-SQL in my last job. I enjoyed it but had to learn quickly and stay focused.

I’ve learned most of my vba due to curiosity. The “I wonder if it’s possible to…” has been a huge factor.

Effort (grit) is an incredible factor. Without it nothing else matters.

Decrease Learning Curve Percent

If we can decrease our learning curve percent we’ll learn faster!

How can we do that?

Find the material that works for you

Practice. Build stuff (necessity helps!)

Get help (don’t forget what you learn!)

Repeat & Improve (it gets easier)

If we don’t improve the percent will remain close to 1. See sheet ‘Learning Curve Percent’.

About Me

My name is Kevin Lehrbass. I’m a Data Analyst. I live in Markham Ontario Canada.

My Data Learning Curve started back in the late 1990s. I saw someone working in Excel and it intrigued me. I read a book and took a course. Then I read the Excel 2000 Bible by John Walkenbach cover to cover! In 2001 I started my first data job, learned SQL, took more courses, read more books… and the rest is history.

But…we have to keep using our skills or we’ll forget. My T-SQL (and PL-SQL) skills have dropped off because I haven’t used it in 10 years (I still use SQL). My Excel and DAX formula knowledge have increased. I still play around with VBA and it does come in handy but it’s not an essential part of my current job.