Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Basic Skills
Essential Skills Expert Skills Construction Kits
2016 2013 2010 2007 Apple Mac
Learn Excel 2013 Basic Skills With The Smart Method

Free Excel Tutorial: Learn Excel basics in 5 hours with this course.

This course is provided as an entirely free educational resource by The Smart Method. The course material has been taken from the first two sessions of our Essential Skills course. The course is intended for users who have never used Excel before or who have few existing Excel skills.
By the end of each course:
You'll feel really comfortable using Excel's basic features
Your Excel skills will be better than most office workers with many years experience
Your Excel skills will be greater and broader than almost all other Excel users in the workplace
Before you start:
When you need help:
Read: How to use the course Simple one-page guide. Search Find a lesson teaching a specific Excel feature
Download the entire e-book Download the entire e-Book.
Download the sample files Sample files save a lot of typing. Forums Ask one of our Excel experts.
Session 1: Basic Skills
book Session 1 Introduction
book Lesson 1-1: Start Excel and open a new blank workbook
book Lesson 1-2: Check whether your Excel version is up to date
book Lesson 1-3: Change the Theme in Office
book Lesson 1-4: Maximize, minimize, re-size, move and close the Excel window
book Lesson 1-5: Download the sample files and open or navigate a workbook
book Lesson 1-6: Save a workbook to a local file
book Lesson 1-7: Understand common file formats
book Lesson 1-8: Pin a workbook and understand file organization
book Lesson 1-9: View, move, add, rename, delete and navigate worksheet tabs
book Lesson 1-10: Use the Versions feature to recover an unsaved Draft file
book Lesson 1-11: Use the Versions feature to recover an earlier version of a workbook
book Lesson 1-12: Use the Ribbon
book Lesson 1-13: Understand Ribbon components
book Lesson 1-14: Customize the Quick Access Toolbar and preview the printout
book Lesson 1-15: Use the Mini Toolbar, Key Tips and keyboard shortcuts
book Lesson 1-16: Understand views
book Lesson 1-17: Hide and Show the Formula Bar and Ribbon
book Lesson 1-18: Use the help system
book Session 1 Exercise
book Session 1 Exercise Answers
An Apple for the teacher?
I hope you've found Session 1 useful. Before the 19th Century education was not generally funded by the government and teachers would offer their services free. Pupils would often bring food, or other gifts, to thank the teacher for their free tuition. This is the origin of today's tradition of giving an apple to the teacher.
In this modern age you can show your appreciation in a different way - by spreading the word about this free course via social media to anybody you think it might help. Just one click and you'll make this teacher very happy.
Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email
Session 2: Doing Useful Work with Excel
book Session 2 Introduction
book Lesson 2-1: Enter text and numbers into a worksheet
book Lesson 2-2: Create a new workbook and view two workbooks at the same time
book Lesson 2-3: Use AutoSum to quickly calculate totals
book Lesson 2-4: Select a range of cells and understand Smart Tags
book Lesson 2-5: Enter data into a range and copy data across a range
book Lesson 2-6: Select adjacent and non-adjacent rows and columns
book Lesson 2-7: Select non-contiguous cell ranges and view summary information
book Lesson 2-8: AutoSelect a range of cells
book Lesson 2-9: Re-size rows and columns
book Lesson 2-10: Use AutoSum to sum a non-contiguous range
book Lesson 2-11: Calculate an Average value in Excel using AutoSum
book Lesson 2-12: Create your own Excel formulas
book Lesson 2-13: Create Excel functions using Formula AutoComplete
book Lesson 2-14: Use AutoFill for text and numeric series
book Lesson 2-15: Use AutoFill to adjust cell references in Excel formulas
book Lesson 2-16: Use AutoFill options
book Lesson 2-17: Speed up your AutoFills and create a custom fill series
book Lesson 2-18: Use automatic Flash Fill to split delimited text
book Lesson 2-19: Use manual Flash Fill to split text
book Lesson 2-20: Use multiple example Flash Fill to concatenate text
book Lesson 2-21: Use Flash Fill to solve common problems
book Lesson 2-22: Use the zoom control
book Lesson 2-23: Print out a worksheet
book Session 2 Exercise
book Session 2 Exercise Answers
You've now completed the Basic Skills course. Perhaps this is all you need, but if you want to progress your Excel education we have two more courses you may wish to consider.

Basic Skills Cover
The free Basic Skills course will get you started with Excel fundamentals. Even though it is a basic skills course you'll still master many skills that professional Excel users are unable to use. Available entirely free as an online video course.
If this free course has helped you, you can thank us by spreading the word to anybody else that the course might help. Just click one of these icons to share:
Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email
Yellow Arrow
Essential Skills Cover
This course adds another six sessions to build upon the two that you have completed (in the Basic Skills course).
If you need Excel skills to get a job - but you've never used Excel before, this course will give you all the skills an employer would expect. By the end of the Essential Skills course your Excel skills will be better than most office workers (even those with many years of Excel experience).
Yellow Arrow
Expert Skills Cover
After the Essential Skills course you'll be really, really good with Excel. If you want to join the tiny elite of power-users who can do absolutely everything with Excel you can take this course and become a true Excel guru. This is a true Expert-level course. By the end of this course your Excel skills will be greater and broader than almost all other Excel users in the workplace.