How a young employee achieved more with Excel?

Categories: : Your Dose of Excel

A girl standing on a cliff with her hands stretched wide

Image of the author, Ankush Chopra

 

Ankush Chopra

FOUNDER, Qling


Share

Share to LinkedIn Icon
Share to Facebook icon
Share to Twitter icon

Key Takeaways

  1. Limited understanding of Excel can prevent you from getting credible insights from data
  2. To be successful, you need to learn analysis and not the top 5 formulas
  3. Excel is an easily available tool that lets you find answers to business problem quickly

A bright start by a fine professional

The early years for any working professional are exciting, fun, and a great learning experience. It is lovely to see the enthusiasm they bring in and the openness towards learning. As a management consultant, you appreciate this openness even more.

It was one such assignment where I had onboarded a bright young colleague to the team. She seized the subtleties of the assignment and started adding tremendous value in no time. Looking at her potential, I started assigning more complex jobs to her.

One day, I took all the data that we had collected as part of that assignment and asked her to take a few days to find out any insights that she could. I suggested to her that Excel is a powerful tool, and there are amazing things you can do with Excel, and she should probably use it for analysis.

The first roadblock

From the next day, I could see that the enthusiasm had gone down, and she was spending long hours in the office.

After three days, when I enquired about the analysis, I understood the sudden behaviour change. On asking, she mentioned she did not understand Excel very well and was struggling to analyze data thoroughly, and therefore did not have any meaningful insights to share.

She knew that I taught Excel to young professionals as a guest faculty, which made her expect much more out of her. When I sat down with her, I realized she was making the first mistake that I had highlighted in my post on three common mistakes to avoid while working with Excel. She feared Excel because she did not understand a few complex formulas that well!

Limited understanding of Excel can prevent you from getting credible insights from data

Give a man a fish...

She expected I give her a few templates to replicate and finish her work quickly. It would have been easier for me to do that, and it would have also meant very little time investment from me. However, I remembered the famous saying, "Give a man a fish, and you feed him for a day; teach a man to fish, and you feed him for a lifetime."

I took the more challenging route. I worked out a plan with her on how to go about analyzing data.

Step 1: List down the client problem areas

Step 2: List down the assumptions

Step 3: Validate the problem by finding supporting data

Step 4: Validate the assumptions from the data at hand

Step 5: List down the potential solutions and create data models to evaluate their relevance

To be successful, you need to learn analysis and not the top 5 formulas

The hard work

Over the next few days, we went through each step and solved it. For each step, we would first debate it from the business lens and then identify the formulas and functions in Excel that could help us achieve our result. This approach of learning to solve a business problem helped her learn quickly.

In the initial days, I would give her specific areas to investigate to feel confident of using what she had learned. After halfway through, I started asking questions instead of providing solutions. For instance, one day, I mentioned that we seem to have some excellent insights; however, I am unsure if the client would be too interested in just numbers. That led to her realizing that she needs to learn attractive visual representation using charts in Excel.

Another day, I told her that the client is curious and is likely to ask for more analysis during the meeting and would expect an answer immediately. After some time, she realized the need to learn interactive dashboards, which I was more than happy to teach.

The reward

What really qualifies as learning?

The teaching and analysis went on for a few days, and then the final version was ready. The client appreciated it! I learned a few new tricks to answer some of my colleague's questions. And importantly, her enthusiasm was back.

From that point on, she was my go-to person for any analysis-related work!

Excel is an easily available tool that lets you find answers to business problem quickly

This story is just one example of how I have seen Excel help a professional. There are many more stories to share, but maybe some other day. Excel is a great tool, and I have observed that those who understand and use it well distinguish themselves from others.

If you would also like to master Excel and distinguish yourself, I would recommend learning it formally. If you prefer a practical, focused, and scenario-based approach to learning, I would recommend you look at what we have to offer in our course, Excel Masterclass.

In this course, you will get all the workbooks which will help you practice as we go along. At the end, you will also get a short assignment, so that you gain the confidence to use Excel independently at work. It is a course designed for young professionals who are busy and are looking to learn Excel faster and benefit quicker.

If you still have some questions in your mind, you could write to me at ankush.chopra@qling.net or you could read this blog post that could help you get more clarity.


Related Blogs

Picture of two dice with a magnifying glass drawn on one side

10 things most people do not know about Microsoft Excel

  1. You can always discover new and more creative ways to get more out of Excel
  2. You can write formulas faster and free-of-errors using dynamic arrays
  3. The new formulas in Excel 365 have significantly reduced the complexity in solving business problems

What really qualifies as learning?


Picture of a diary page with Act One written on it

How I started teaching Excel?

  1. Story of how an innocuous call led to a teaching assignment
  2. Teaching is the best way to learn more about any subject
  3. You get the most joy by making the experience relevant for your learners

What really qualifies as learning?


An exclamation sign made on a torn paper triangle

Three common mistakes to avoid while working with Excel

  1. With systematic learning, nothing can stop you from using Excel with ease over time 
  2. Most people teach how to use formulas in Excel. However people want to learn Excel to solve business problems
  3. Young professionals can benefit tremendously in their careers by mastering the skill of analyzing data in Excel

What really qualifies as learning?


Picture of a chessboard with a person in background

Thinking about taking our Excel Masterclass?

  1. Deciding which Excel course to take can be hard
  2. There are 5 important factors a working professional must consider while selecting an Excel course
  3. Good Excel skills enable you to add more value to your analysis, irrespective of your niche

What really qualifies as learning?


0px

Want updates? Let us know.

If you would liked to be notified when we release a new blog or have anything worthwhile to share, then please subscribe to our newsletter. We won't spam you. You can unsubscribe anytime.

I have read and agree to the terms & conditions.


LinkedIn Logo
Facebook Logo
Instagram Logo
Pinterest Logo