Lacking confidence means that you are closer to becoming a guru

Table of Contents

Have you heard about the Dunning-Kruger Effect. It has been my motivation towards learning for years.

When I am first start to learn Excel back in ancient time, I felt really helpless like I am never going to figure how does it work. Apart from using SUM() instead of +, I literally know nothing at all.

Later in my learning journey, I learned Index Match and vlookup. I started gaining some confidence and being able to substitute manual calculation with different formulas.

When I learned pivot table and slicer, I felt like I can do everything with Excel. I am so self-absorbed and even started bragging about my Excel skills in job interviews. I put proficient in Excel in my resume. Haha. Who else did the same? Fortunately, no one really challenged me during those job interviews or I could be really embarrassed. Seriously, if anyone ever asked me about array formula, I would have dug a hole and jumped right into it.

There comes the day I learned about VBA. It totally opened my eyes. I felt really dumb for not knowing this earlier. All the time I have been doing my calculation could be a waste of time compared with the automation ability VBA gives. My confidence sunk. I was such a newbie to coding. Things like “dim” “set” could easily bury my motivation to learn Excel. Fortunately, I didn’t give up.

And I found out about this theory. Your confidence is not positively related to your competence. This has actually motivated me a lot.

International Open Academy

Join Our Newsletters!