Home Sample Files e-Books Books Wholesale Forums & Support Contact
Login
2016 2013 2010 2007 Apple Mac
Learn Excel 2016 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 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. Contact Us
Download the Free e-book Download the entire e-Book. We'll do all we can to help solve any problem.
Download the sample files Sample files save a lot of typing.
What you will learn:
Session 1: Basic Skills
Lesson 1-1: Start Excel and open a new blank workbook
Lesson 1-2: Check whether your Excel version is up to date
Lesson 1-3: Change the Theme in Office
Lesson 1-4: Maximize, minimize, re-size, move and close the Excel window
Lesson 1-5: Download the sample files and open or navigate a workbook
Lesson 1-6: Save a workbook to a local file
Lesson 1-7: Understand common file formats
Lesson 1-8: Pin a workbook and understand file organization
Lesson 1-9: View, move, add, rename, delete and navigate worksheet tabs
Lesson 1-10: Use the Versions feature to recover an unsaved Draft file
Lesson 1-11: Use the Versions feature to recover an earlier version of a workbook
Lesson 1-12: Use the Ribbon
Lesson 1-13: Understand Ribbon components
Lesson 1-14: Customize the Quick Access Toolbar and preview the printout
Lesson 1-15: Use the Mini Toolbar, Key Tips and keyboard shortcuts
Lesson 1-16: Understand views
Lesson 1-17: Hide and Show the Formula Bar and Ribbon
Lesson 1-18: Use the Tell Me help system
Lesson 1-19: Use other help features
Session 2: Doing Useful Work with Excel
Lesson 2-1: Enter text and numbers into a worksheet
Lesson 2-2: Create a new workbook and view two workbooks at the same time
Lesson 2-3: Use AutoSum to quickly calculate totals
Lesson 2-4: Select a range of cells and understand Smart Tags
Lesson 2-5: Enter data into a range and copy data across a range
Lesson 2-6: Select adjacent and non-adjacent rows and columns
Lesson 2-7: Select non-contiguous cell ranges and view summary information
Lesson 2-8: AutoSelect a range of cells
Lesson 2-9: Re-size rows and columns
Lesson 2-10: Use AutoSum to sum a non-contiguous range
Lesson 2-11: Use AutoSum to quickly calculate averages
Lesson 2-12: Create your own formulas
Lesson 2-13: Create functions using Formula AutoComplete
Lesson 2-14: Use AutoFill for text and numeric series
Lesson 2-15: Use AutoFill to adjust formulas
Lesson 2-16: Use AutoFill options
Lesson 2-17: Speed up your AutoFills and create a custom fill series
Lesson 2-18: Understand linear and exponential series
Lesson 2-19: Use automatic Flash Fill to split delimited text
Lesson 2-20: Use manual Flash Fill to split text
Lesson 2-21: Use multiple example Flash Fill to concatenate text
Lesson 2-22: Use Flash Fill to solve common problems
Lesson 2-23: Use the zoom control
Lesson 2-24: Print out a worksheet
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 e-book with free video walk-throughs of each lesson.
FREE
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.