Skip to content
SkillSpring

Cheat sheet

Microsoft Excel for Beginners

Basics, VLOOKUP, pivot tables, forecasting and a dashboard project.

Study & career skills · Beginner · English · 9 videos · 3 h 27 min · videos by Rishabh Mishra

By the end you should be able to

  1. Enter, format and sort data in Excel
  2. Use VLOOKUP and pivot tables
  3. Build a simple dashboard

Watch in this order

  1. 1.Microsoft Excel Tutorial for Beginners - FREE Online Excel Course (part 1)32 min
  2. 2.Microsoft Excel Tutorial for Beginners - FREE Online Excel Course (part 2)27 min
  3. 3.Create Pivot Tables In Excel12 min
  4. 4.How to use VLOOKUP formula in Excel5 min
  5. 5.Pivot Tables in 1 Minute1 min
  6. 6.VLOOKUP Formula in 2 Minute2 min
  7. 7.Forecasting in Excel - Must Skill for Data Analyst15 min
  8. 8.Full Project in Excel with Interactive Dashboard37 min
  9. 9.Excel Tutorial For Beginners in Hindi1 h 16 min

Before you start: Computer basics

skillspring · Videos belong to Rishabh Mishra and play from YouTube. Printed for personal study.