How to learn Excel

Looking to learn Excel basics or want to improve your skills and become an Excel expert?

There are many ways to learn Excel from the ground. You can read a book, however one of the best Excel book according to Amazon ratings the Excel Bible is more than 1000 pages. It is a real challenge to read this amount of information. Another possibility is to attend a course in a local training center. This can be quite pricy and you have no control on the schedule but you have the possibility to ask questions to the teacher.

One of the most effective and easiest way today is to watching video training courses. You can schedule it as you want and the costs are also very low. There are a lot of well build Excel training materials on the internet you can learn from covering topics like basic data entering tasks, creating formulas and functions, formatting, creating charts, security and sharing options, pivot tables, macros and so on. You only need a dedicated video player to maximize the effectiveness.

To get the most out of video trainings you should follow some productivity advice:

  • Give yourself enough time. If the length of the course is 3 hours it doesn't mean that you will be an Excel expert after 3 hours of learning. You need extra time to try the material yourself.
  • Do the exercises. Try to do the same tasks yourself as well. Just to feel the knowledge in your hands.
  • Take notes. During the video lessons take your own notes. It also helps you to memorize things an later you can review your notes to refresh your knowledge.
  • Take a break. After every 40-50 minutes take some break and stand up, drink something and try to refresh your body.

Start learning Excel in 15 minutes

Follow the steps below to start learning Excel in just 15 minutes:

  • Download and install MoocPlayer. Register your email address and you will get the download link shortly.
  • Select a training. Import Excel video trainings from the pre-build catalog that contains the best YouTube Excel trainings or simply import your local course folder.
  • Take notes. Watch the course and take notes regularly. Try to organize your notes into groups like shortcut, questions or simple note.
  • Export your Excel notes and use the generated page as a reference card and look over regularly to transfer the information into the long term memory of your brain.

Recommended Excel video trainigs

Here you can find a list of the best Excel video courses on YouTube. You can easily import them into MoocPlayer using the Find course option.

Author: GCFLearnFree
Release date: 2013-04-19
Length: 1h : 57m
Lessons:28

Content:

  1. - New Features in Office 2013
  2. - Excel 2013: Getting to Know Excel
  3. - Excel 2013: Creating and Opening Workbooks
  4. - Excel 2013: Cell Basics
  5. - Excel 2013: Saving and Sharing Workbooks
  6. - Excel 2013: Modifying Columns, Cells, and Rows
  7. - Excel 2013: Formatting Cells
  8. - Excel 2013: Worksheet Basics
  9. - Excel 2013: Page Layout
  10. - Excel 2013: Printing Workbooks
  11. - Excel 2013: Simple Formulas
  12. - Excel Formulas: Solving Real-Life Problems in Excel
  13. - Excel 2013: Complex Formulas
  14. - Excel 2013: Cell References
  15. - Excel 2013: Functions
  16. - Excel 2013: Freezing Panes and View Options
  17. - Excel 2013: Sorting Data
  18. - Excel 2013: Filtering Data
  19. - Excel 2013: Groups and Subtotals
  20. - Excel 2013: Tables
  21. - Excel 2013: Charts
  22. - Excel 2013: Sparklines
  23. - Excel 2013: Track Changes and Comments
  24. - Excel 2013: Finalizing and Protecting Workbooks
  25. - Excel 2013: Conditional Formatting
  26. - Excel 2013: PivotTables (Part 1)
  27. - Excel 2013: PivotTables (Part 2)
  28. - Excel 2013: What-If Analysis
Author: Hun Kim
Release date: 2013-02-09
Length: 3h : 28m
Lessons:33

Content:

  1. - Excel 2013 Tutorial MOS Certification Practice 1.4a
  2. - Excel 2013 Tutorial MOS Practice 1.4b part 1
  3. - Excel 2013 Tutorial MOS Practice 1.4b part 2
  4. - MOS Excel 1.4c Certification Practice hiding worksheets
  5. - MOS Excel 2013 1.5a Certification Practice (77-882)
  6. - Excel 2013 Tutorial: MOS Certification 1.5b Training
  7. - Excel 2013 Tutorial: Inserting Data in Cells and Ranges (Certification Practice 2.1a)
  8. - Excel 2013 Tutorial - Inserting Data in Cells and Ranges (Certification Practice 2.1b)
  9. - Excel 2013 MOS Certification Tutorial 2.1c - Rotating Roster
  10. - Excel 2013 Tutorial - Certification Practice 2.2a
  11. - Excel 2013 Tutorial - MOS Certification Practice 2.2b
  12. - Excel 2013 Tutorial: Order and Group Cells and Ranges
  13. - Excel 2013 Tutorial: Sparklines (2.3b Certification Practice)
  14. - Excel 2013 Tutorial: Ordering and Grouping Cells and Ranges (Certification Training 2.3c)
  15. - Excel 2013 Tutorial: MOS Certification Practice 2.3d
  16. - Excel 2013 Tutorial: Manage Cells and Ranges - Certification Practice 2.3e
  17. - MOS Excel 2013 Tutorial: Certification Practice 3.1
  18. - Excel 2013 Help - MOS Certification Training 3.2
  19. - Excel 2013 Help: Tables (Certification Training 3.3)
  20. - MOS Excel 2013 Certification Practice (77-420) - Objective 4.1
  21. - Excel 2013 Tutorial - Certification Practice 4.2
  22. - Excel 2013 Certification Training 4.3a - SUMIF SUMIFS COUNTIF COUNTIFS
  23. - Excel 2013 Tutorial - MOS Certification Training 4.3b
  24. - Excel 2013 Tutorial - MOS Certification Training 4.4 Text Functions
  25. - Excel 2013 Tutorial - MOS Certification Training (Create and Format Charts) Part 1
  26. - Excel 2013 Tutorial - MOS Certification Training (Create and Format Charts) Part 2
  27. - Excel Tutorial: Gradebook Template for Teachers
  28. - Excel 2013 Tutorial - multiple graphs on one chart
  29. - MOS Excel 2013 77-420 Certification Objective 5.3
  30. - MOS Excel 2013 Exam 77-420 Information
  31. - Excel HLOOKUP Tutorial
  32. - Excel 2013 Tutorial: How to Save As Template
  33. - Excel 2013 Tutorial: Open a Workbook Automatically when Excel starts
Author: Thenewboston
Release date: 2014-10-29
Length: 3h : 15m
Lessons:25

Content:

  1. - Microsoft Excel 2013 Tutorial - 1 - Introduction
  2. - Microsoft Excel 2013 Tutorial - 2 - Making Data Beautiful
  3. - Microsoft Excel 2013 Tutorial - 3 - Working with Cells
  4. - Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers
  5. - Microsoft Excel 2013 Tutorial - 5 - Inserting Rows and Columns
  6. - Microsoft Excel 2013 Tutorial - 6 - Copy and Move Ranges
  7. - Microsoft Excel 2013 Tutorial - 7 - Worksheet Tips
  8. - Microsoft Excel 2013 Tutorial - 8 - Tables
  9. - Microsoft Excel 2013 Tutorial - 9 - Working with Tables
  10. - Microsoft Excel 2013 Tutorial - 10 - Total Row and Sorting Tables
  11. - Microsoft Excel 2013 Tutorial - 11 - Formatting Your Worksheet
  12. - Microsoft Excel 2013 Tutorial - 12 - Fitting Text and Merging Cells
  13. - Microsoft Excel 2013 Tutorial - 13 - Formatting Cells
  14. - Microsoft Excel 2013 Tutorial - 14 - Format Painter and Protecting Workbooks
  15. - Microsoft Excel 2013 Tutorial - 15 - Templates and Printing
  16. - Microsoft Excel 2013 Tutorial - 16 - Formulas and Functions
  17. - Microsoft Excel 2013 Tutorial - 17 - PEMDAS and Naming Ranges
  18. - Microsoft Excel 2013 Tutorial - 18 - Awesome Formula Tips
  19. - Microsoft Excel 2013 Tutorial - 19 - Referencing Cells Properly
  20. - Microsoft Excel 2013 Tutorial - 20 - Using Formulas in Tables
  21. - Microsoft Excel 2013 Tutorial - 21 - String Functions
  22. - Microsoft Excel 2013 Tutorial - 22 - More Cool String Functions
  23. - Microsoft Excel 2013 Tutorial - 23 - Boring Date and Time Stuff
  24. - Microsoft Excel 2013 Tutorial - 24 - Happy Erection Day!
  25. - Microsoft Excel 2013 Tutorial - 25 - Cool Counting Functions