Home Sample Files Register Books and e-books Forums Support Contact Search
Basic Skills
Essential Skills Expert Skills
Excel 2016 Excel 2013 Excel 2010 Excel 2007
Learn Excel 2013 Basic Skills With The Smart Method
Free Video Course. Learn Excel in less than five hours with this FREE video course. Download the entire free e-book Download the Excel sample files free e-book how to best use the course
Session 1: Basic Skills
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
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 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: Use AutoSum to quickly calculate averages
book Lesson 2-12: Create your own formulas
book Lesson 2-13: Create functions using Formula AutoComplete
book Lesson 2-14: Use AutoFill for text and numeric series
book Lesson 2-15: Use AutoFill to adjust 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
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 video courses/books you may wish to consider.
Basic Skills Cover
This free course consists of the first two sessions of Essential Skills. It will get you started with Excel basics. 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 includes the Basic Skills material and adds another six sessions. By the end of the Essential Skills course your Excel skills will be better than most office workers with many years of experience.
Yellow Arrow
Expert Skills Cover
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.