Home Sample Files
Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills
2016 2013 2010 2007 Apple Mac
Learn Excel 2013 Basic Skills With The Smart Method

Free Excel 2013 Tutorial

Used to learn Excel by students from:
NASA US Army Pepsi MIT John Deere CMU UPS University of Washington Nike NYU 7-11 University of Texas HP Florida Gulf Coast University SeaWorld EW University DHL East Carolina University Australian Government Trinity College Dublin NYC.Gov LG Toyota Cornell University Liberal Democrats Panasonic Georgetown University Louisiana State Government Wells Fargo Edinburgh College NHS Leeds University 3M Akron University ASU Melbourne University FujiFilm Seattle Central University Barclays Universidad Complutense Madrid Honeywell Michican University DuPont HULT International Business School OXY Thunderbird School of Global Management Deutsche Bank Lee College Northrop Grumman Portland State University Thrifty Car Rental Columbia College Transport Canada Vermont University Cardinal Health Clark College Eltek Colorado University TD Bank Financial Group Columbia University Western Pilot Service Vanderbilt University Guelph University Mayo Clinic Michigan Flint University Minnesota University Montgomery Museum of Fine Arts Cornell University Nevada System of Higher Education NM State University Pace University San Diego University Southern Methodist University Southwestern Oklahoma State University Texas Christian University Tulane University UCD Dublin University of Illinois at Chicago Virginia Commonwealth University Wisconsin University
For over fifteen years, Smart Method® classroom courses have been used by large corporations, government departments and the armed forces to train their employees.
This Excel 2013 tutorial is provided completely free of charge so that you can use the same materials to learn (or teach) Excel 2013. Our tutorials are used by schools, colleges and universities all over the world.
Instant one-click access
No registration required
Free Excel Tutorial 100+ page book.
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 sample files Sample files save a lot of typing. Forums Ask one of our Excel experts.
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
apple
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: 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
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
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.