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

Hello,

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
  • 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,

André

(edited)

Was this answer helpful?
3
Ian
Expert
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:

https://blog.hubspot.com/marketing/learn-excel-resources

https://www.udemy.com/share/101Wde/ (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 (https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA)

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

Khaled

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

Hi,

You can have a look at this youtube chain

https://www.youtube.com/playlist?list=PL_iwD7O7FG7jzLQIYm6-9Gx3hvXVUG7C5

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

David

Was this answer helpful?
3
Clara
Expert
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?