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.
Content:
- - New Features in Office 2013
- - Excel 2013: Getting to Know Excel
- - Excel 2013: Creating and Opening Workbooks
- - Excel 2013: Cell Basics
- - Excel 2013: Saving and Sharing Workbooks
- - Excel 2013: Modifying Columns, Cells, and Rows
- - Excel 2013: Formatting Cells
- - Excel 2013: Worksheet Basics
- - Excel 2013: Page Layout
- - Excel 2013: Printing Workbooks
- - Excel 2013: Simple Formulas
- - Excel Formulas: Solving Real-Life Problems in Excel
- - Excel 2013: Complex Formulas
- - Excel 2013: Cell References
- - Excel 2013: Functions
- - Excel 2013: Freezing Panes and View Options
- - Excel 2013: Sorting Data
- - Excel 2013: Filtering Data
- - Excel 2013: Groups and Subtotals
- - Excel 2013: Tables
- - Excel 2013: Charts
- - Excel 2013: Sparklines
- - Excel 2013: Track Changes and Comments
- - Excel 2013: Finalizing and Protecting Workbooks
- - Excel 2013: Conditional Formatting
- - Excel 2013: PivotTables (Part 1)
- - Excel 2013: PivotTables (Part 2)
- - Excel 2013: What-If Analysis
Content:
- - Excel 2013 Tutorial MOS Certification Practice 1.4a
- - Excel 2013 Tutorial MOS Practice 1.4b part 1
- - Excel 2013 Tutorial MOS Practice 1.4b part 2
- - MOS Excel 1.4c Certification Practice hiding worksheets
- - MOS Excel 2013 1.5a Certification Practice (77-882)
- - Excel 2013 Tutorial: MOS Certification 1.5b Training
- - Excel 2013 Tutorial: Inserting Data in Cells and Ranges (Certification Practice 2.1a)
- - Excel 2013 Tutorial - Inserting Data in Cells and Ranges (Certification Practice 2.1b)
- - Excel 2013 MOS Certification Tutorial 2.1c - Rotating Roster
- - Excel 2013 Tutorial - Certification Practice 2.2a
- - Excel 2013 Tutorial - MOS Certification Practice 2.2b
- - Excel 2013 Tutorial: Order and Group Cells and Ranges
- - Excel 2013 Tutorial: Sparklines (2.3b Certification Practice)
- - Excel 2013 Tutorial: Ordering and Grouping Cells and Ranges (Certification Training 2.3c)
- - Excel 2013 Tutorial: MOS Certification Practice 2.3d
- - Excel 2013 Tutorial: Manage Cells and Ranges - Certification Practice 2.3e
- - MOS Excel 2013 Tutorial: Certification Practice 3.1
- - Excel 2013 Help - MOS Certification Training 3.2
- - Excel 2013 Help: Tables (Certification Training 3.3)
- - MOS Excel 2013 Certification Practice (77-420) - Objective 4.1
- - Excel 2013 Tutorial - Certification Practice 4.2
- - Excel 2013 Certification Training 4.3a - SUMIF SUMIFS COUNTIF COUNTIFS
- - Excel 2013 Tutorial - MOS Certification Training 4.3b
- - Excel 2013 Tutorial - MOS Certification Training 4.4 Text Functions
- - Excel 2013 Tutorial - MOS Certification Training (Create and Format Charts) Part 1
- - Excel 2013 Tutorial - MOS Certification Training (Create and Format Charts) Part 2
- - Excel Tutorial: Gradebook Template for Teachers
- - Excel 2013 Tutorial - multiple graphs on one chart
- - MOS Excel 2013 77-420 Certification Objective 5.3
- - MOS Excel 2013 Exam 77-420 Information
- - Excel HLOOKUP Tutorial
- - Excel 2013 Tutorial: How to Save As Template
- - Excel 2013 Tutorial: Open a Workbook Automatically when Excel starts
Content:
- - Microsoft Excel 2013 Tutorial - 1 - Introduction
- - Microsoft Excel 2013 Tutorial - 2 - Making Data Beautiful
- - Microsoft Excel 2013 Tutorial - 3 - Working with Cells
- - Microsoft Excel 2013 Tutorial - 4 - Formatting Numbers
- - Microsoft Excel 2013 Tutorial - 5 - Inserting Rows and Columns
- - Microsoft Excel 2013 Tutorial - 6 - Copy and Move Ranges
- - Microsoft Excel 2013 Tutorial - 7 - Worksheet Tips
- - Microsoft Excel 2013 Tutorial - 8 - Tables
- - Microsoft Excel 2013 Tutorial - 9 - Working with Tables
- - Microsoft Excel 2013 Tutorial - 10 - Total Row and Sorting Tables
- - Microsoft Excel 2013 Tutorial - 11 - Formatting Your Worksheet
- - Microsoft Excel 2013 Tutorial - 12 - Fitting Text and Merging Cells
- - Microsoft Excel 2013 Tutorial - 13 - Formatting Cells
- - Microsoft Excel 2013 Tutorial - 14 - Format Painter and Protecting Workbooks
- - Microsoft Excel 2013 Tutorial - 15 - Templates and Printing
- - Microsoft Excel 2013 Tutorial - 16 - Formulas and Functions
- - Microsoft Excel 2013 Tutorial - 17 - PEMDAS and Naming Ranges
- - Microsoft Excel 2013 Tutorial - 18 - Awesome Formula Tips
- - Microsoft Excel 2013 Tutorial - 19 - Referencing Cells Properly
- - Microsoft Excel 2013 Tutorial - 20 - Using Formulas in Tables
- - Microsoft Excel 2013 Tutorial - 21 - String Functions
- - Microsoft Excel 2013 Tutorial - 22 - More Cool String Functions
- - Microsoft Excel 2013 Tutorial - 23 - Boring Date and Time Stuff
- - Microsoft Excel 2013 Tutorial - 24 - Happy Erection Day!
- - Microsoft Excel 2013 Tutorial - 25 - Cool Counting Functions
