Getting Started
Spreadsheet Basics course
- offered Offered by DataCamp for free (but you do need to create an account)
- uses Uses Google Sheets, but covers basics (how a spreadsheet works, cell references, and formulas) for both Sheets and Excel
- you You get a statement of accomplishment upon completion!
Microsoft Office documentation
...
...
- help center
- Excel 2016 for Mac Windows Training
Tutorials
These links are (mostly) to Excel 2013 video tutorials. Most of these instructions will apply to later versions of Office 2016 as well. Some of the options will have different locations in the menus/ribbon in other versions of Excel (especially between Mac and Windows products).
You can see what version(s) of Excel each video/article applies to at the bottom top of each page.
- Basic tasks in Excel for Windows
- Creating and Editing a Workbook
- Freeze or lock panesrows/columns
- Printing Excel Sheets and Workbooks
- Tutorial: Import Data into Excel, and Create a Data Model
- Tables and charts
- Mail Merge using an Excel spreadsheet
- IF AND OR Functions
- Logical functions - a list of the logical functions with links to articles on each one
- Conditional Formatting, and Advanced Conditional Formatting
- VLOOKUP
- XLOOKUP function
- PivotTables
- Password protect workbooks and worksheets
- Work with macros
DataCamp offers a free course on Data Analysis with Spreadsheets that you may also find useful.
Excel 2013 for Windows
...
...
Excel 2011 for Mac
- Learning roadmap for Excel for Mac 2011
- This page provides links to videos and articles walking you through the functions of Excel
- Excel for Mac 2011 Basics .pdf tutorial
- Excel for Mac 2011 Training
- Another page linking to both articles and videos guiding you through specific features of Excel
- VLOOKUP: What It Is, and When To Use It
Workshop Handouts
Preparing an Excel Workbook for Presenting to Others
...
- Arithmetic in Excel
- Excel Basics: Formulas and Functions (YouTube)
- Excel Basics: Formulas Using Cell Data (YouTube)
- Transferring Data Tables and Graphs to MS Word