Free online resources to learn Excel basics

Excel free resources
Edited on Jun 08, 2020
5 Answers
1.0 k Views
Anonymous A asked on Jun 01, 2020


I am looking for ONLINE FREE materials to learn Excel.

From zero to "acceptable" level:

  • Simple formulas & tools: formating, sorting, sum, average, vlookup, etc.
  • Conditional formulas: sumif, averageif, etc.
  • Pivot tables

It can be videos, free courses or tutorials, whatever works!

Thanks for any hint!

Overview of answers

  • Upvotes
  • Date ascending
  • Date descending
Best answer
Anonymous updated the answer on Jun 08, 2020

Dear A,

Congratulations to your offer!

It would be helpful for you to learn the business-focused Excel features.

In business, about 80% of your work will come from 20% of the functionality of the Microsoft Excel.

The core skills of a competent business Excel user are something like:

  • Formatting & basic formulas
  • Mouse-free Excel navigation
  • Vlookups & conditional statements
  • Data analysis - filtering, sorting, and analyzing data
  • Data visualization - tables, charts, and dual axis charts
  • What-if-analysis
  • Pivot tables

If you can do these things, you’ll outperform 95% of people in the workplace.

To learn these concepts, you could:

  • Learn the concepts online for free
  • Take an online course

If you’re looking for something free, I’d recommend Googling & Youtube-ing those topics on my list. Tons of free material online. On Udemy you can also find some courses.

If you’re short on time, take a short business-focused online course.

I’d recommend the following business-focused course focused on mastering the 20% of functions that make up 80% of Excel work.

Also, for candidates like you, who have already secured the offer with a leading consulting firm, I have designed my program "Get ready for the first 100 days " as well as long-term career planning. This program touches all the important aspects: the mindset, the skills, knowledge, networking and ,managing yourself as well, your bosses and clients - everything that is important in your successful career.

In fact, I'm sharing my knowledge of 6 years career experience in consulting, where I was able to land on the fast track promotion and to be promoted from consultant to a project manager just within 3 years, which is extremely fast.

Happy to share these insights with you, feel free to reach out directly to me.

Good luck,



Was this answer helpful?
Content Creator
replied on Jun 02, 2020
BCG | 100% personal interview success rate (8/8) and 95% candidate success rate | Personalized interview prep

Hi there,

A few good resources: (Udemy is excellent. $15...basically free)

Important Tip: Don't just learn formulas etc. Test yourself! Download a free data set, ask yourself a question, and try to solve for it. Play with actual data solving real questions and building a real dashboard etc. Don't just passively take lessons :)

Was this answer helpful?
Anonymous replied on Jun 01, 2020

Hi there,

For me, I find the youtube channel of Leila Gharani very helpful (

She speaks a bit too slow for me, so I recommend to listen to her at 1.75 speed :) and she gives really good tutorials from basic stuff (e.g, conditional formatting) to advanced technique (e.g, data tables, pivot tables, dashboards)

Hope this helps


Was this answer helpful?
Anonymous replied on Jun 01, 2020


You can have a look at this youtube chain

There are a lot of tutorials on typical Excel functions (e.g. vlookup, pivot tables , ...). You can select the videos the most relevant for you.

Hope it helps


Was this answer helpful?
Content Creator
replied on Jun 02, 2020
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut
Was this answer helpful?