This post gives you lots of free Excel Training and Tutorial resources, many of which I have collected while working on our new page, Microsoft Office Training Tutorials, which is linked from our Programming, Computer and I.T. Resources page. There is a wide range of help articles and tutorials here for learning Microsoft Excel, from the quick start guides to more advanced topics such as formulas and pivot tables. If needed, you also check out our Word tutorial post.
Microsoft Excel Video Training Tutorials
Quick start | Intro to Excel | Rows & columns |
Cells | Formatting | Formulas and functions |
Tables | Charts | PivotTables |
Share & co-author | Linked data types | Get to know Power Query |
Take a tour Download template | Formula tutorial Download template | Make your first PivotTable Download template |
Get more out of PivotTables Download template |
Microsoft Excel 2019 Ebook, Quick Reference & Start Guides (pdf)
- Using Microsoft Excel (11.7mb, 439 pgs)
- Excel Quick Start Guide
- Microsoft Excel Associate 2019 training ebook (7.45MB)
- Microsoft Excel Expert 2019 training ebook (7.10MB)
- Excel 2019 Basic Quick Reference Guide
- Excel 2019 Basic Skills Cheat Sheet
- Excel Basics Projects Handout
- Excel 2019 Intermediate Quick Reference Guide
- Excel 2019 Advanced Quick Reference Guide
- Excel Intermediate Formulas Handout
- Advanced Excel – Pivot-Tables Handout
- Advanced Excel VLookup Handout
- Office 365 Excel Forms Reference Guide
- Excel Templates
- Microsoft Office Tips and Tricks
- Excel for Mac Quick Start Guide
- Excel for Mac Basic Quick Reference Guide
- Excel for Mac Intermediate Quick Reference Guide
Excel Help Articles and Tutorials
- Excel Easy – excellent tutorial on how to use Excel
- Overview of Formulas in Excel
- Get Started with Formulas Workbook
- Switch between relative, absolute and mixed references for functions
- Using calculation operators in Excel formulas
- The order in which Excel performs operations in formulas
- Using functions and nested functions in Excel formulas
- Define and use names in formulas
- Guidelines and examples of array formulas
- Delete or remove a formula
- How to avoid broken formulas
- Find and correct errors in formulas
- Excel keyboard shortcuts and function keys
- Excel functions (by category)
- List of all Excel functions available
- Use XLOOKUP to find what you need
- Work with stocks and geography data
- Turn your data into insights
- VLOOKUP function
- IF function
- Create a drop-down list
- Combine text from two or more cells
- Freeze panes to lock rows & columns
- Create a PivotTable to analyze worksheet data
- Design the layout and format of a PivotTable
- Sort data in a PivotTable or PivotChart
Excel 2016 Lessons , Quick Reference & Step-By Step Guide (pdf)
- Introduction To The Excel Spreadsheet
- More On The Use Of The Spreadsheet
- Excel 2016 Quick Start Guide
- Excel 2016 Step-By-Step Guide
- Excel 2016 Quick Reference Guide
- Excel 2016 Fundamentals Guide
- Excel 2016 Basic and Advanced Formulas
- Excel 2016 Practice Exercise 1 Instructions
- Excel 2016 Practice Exercise 2 Instructions
- Excel 2016 for Mac Quick Start Guide
Excel 2013 Videos and Tutorials
- Getting Started with Microsoft Excel 2013 (pdf, 2.83 MB)
- Excel 2013 Quick Start Guide (pdf)
- Excel 2013 Course Training with Examples (pdf, 6.64 MB)
- Learn Excel 2010-2013 from Beginner to Advanced (pdf, 8.24MB)
- Doing More with Excel 2013 (pdf)
- Intermediate Excel 2013 Handout (pdf)
Beginner
- Start using Excel
- Create a chart
- Add numbers in Excel 2013
- Basic math in Excel 2013
- Top tips for working in Excel Online
- Understand and use cell references
- Use AutoFill and Flash Fill
Intermediate
- Add or subtract time
- Average a group of numbers
- Insert headers and footers
- Make the switch to Excel 2013
- Sort and filter data
- Take conditional formatting to the next level
- Use conditional formatting
- VLOOKUP: When and how to use it
Advanced
- Advanced IF functions
- Array formulas
- Create and manage drop-down lists
- Create a PivotTable and analyze your data
- Password protect workbooks and worksheets
- Print worksheets and workbooks
- Work with macros
Quick Reference Cards for Excel 2010 & 2007 versions (pdf)
Excel 2007 and 2010 Tutorials (pdf)
- Introduction To The Excel Spreadsheet
- More On The Use Of The Spreadsheet
- Excel 2010 Training Manual
- Formatting Spreadsheets in Excel 2010
- Using Formulas and Functions in Excel 2010
- Advanced Formulas and Functions in Excel 2010
- Doing More with Excel 2010
- Macros in Excel 2010, Recording, Running, Editing
- Advanced Excel 2010 Tutorial
- Excel 2007 Concatenate Functions
- Excel 2007 Working with Chart Elements
- Creating PivotTables in Excel 2007
- Doing More with Excel 2007
Excel 2003 Training
Microsoft Excel 2003 Training Tutorial, part 1 (30 pages, pdf)
Upon completion of this Excel training module, you will know and be able to:
- Use the Menu bar, Standard and Formatting Toolbars;
- Know the parts of an Excel worksheet;
- Know how to open and save a workbook;
- Use the Page Setup Dialog box;
- Insert a row, column, or worksheet;
- 6. Format a cell;
- Change the font type, style, size and color of a cell or range of cells;
- Create a border around a range of cells;
- Use basic Excel formulas;
- Know how to use the Chart Wizard to create a chart
Microsoft Excel 2003 Training Tutorial part 2 (17 pages, pdf)
Contents:
- Overview
- Setting up the Spreadsheet
- Inputting Data
- AutoSum
- Average Formula
- Multiplication Formula
- Minimum Formula
- Maximum Formula
- Types of Charts
- Creating a Chart
– love learning -your best ed lessons guide, Scott