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

Free Excel Tutorial for Apple Mac: Course teaches Excel in 5 hours.

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
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 the zoom control
Lesson 2-20: 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 a free e-book. Click here to download the free printable PDF file.
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.