LibGuides: Computer and Technology Skills and Resources Guide: MS Excel for Windows and Mac

Microsoft Excel Tutorials

Excel Tutorial for Windows

Excel Tutorial for Mac

GCF Global Comprehensive Excel 2016 tutorial
Tutorial from GCF Global
Excel Tutorials from Excel Easy
Tutorials from Excel Easy website
AutomateExcel
Interactive Excel Tutorials with hints and challenges to work on in the website. You need to create a free account with an email address to take full advantage of the lessons, and your progress is recorded. Created by developer Steve Rynearson.
40 Best Excel Tutorials for Beginner to Advanced Users
A list of a variety of online learning tutorials focusing on many different aspects of Microsoft Excel by Brenda Barron, Freelance Writer.
Microsoft Office 365 Training
From Microsoft, this website offers a variety of tutorials in video and text format to provide basic training in any of the Microsoft Office products including Office 365, Excel, OneNote, Outlook, PowerPoint, Word, OneDrive, Skype for Business, Access, Delve, Project Online, Publisher, SharePoint, Visio, and Yammer. Training is provided on versions 2007, 2010, 2013, 2016, and Office 365

For MacOS - MS Excel 2016 Workbook and Practice Exercises

MS Excel 2016 Workbook for the Mac
This 49-page document gives step-by-step instructions on how to create a simple spreadsheet, and, subsequently, build on the knowledge gained to create charts, Pivot tables, formulas, and more.
Callahoose Grades
An example of a class list of various grades and averages, and a graph showing the results.
CLASS LIST
A sample CLASS LIST to work with -- learn the Max, Min, and Average functions to construct meaningful formulas.
Family and Friends Database
This family and friends database has been pre-constructed so the user can experiment with mail merging to labels within the Excel program.
Pivot Table Excericse
From Microsoft's Tutorials, this Pivot Table exercise is meant to get users started with using this powerful report-building tool.
Sales
Understand absolute values when using this spreadsheet. Troubleshoot the errors and correct them. See how absolute referencing can be used with the more-popular relative referencing tools.
Salespersons Commission Without Formulas
This exercise, from Professor Furman's website, explores not only absolute referencing, but use of the STDEV and AVERAGE functions as well as the IF function.
Zale's Simplified
This spreadsheet displays an imaginary amount of money taken in by a store for selling a certain amount of inventory. Formulas are used to compute the amount taken in as well as the totals taken in thus far. A graph can be created comparing inventory on hand with sold inventory so the "store" can see where it stands at any given time.

For Windows PC - MS Excel 2016 Workbook and Practice Exercises

MS Excel 2016 Workbook for Windows PC
This 44-page booklet, in PDF form, is the curriculum used by Kathy Handy in the Saratoga Springs Public Library's "MS Excel 2016 Part I" class. See the current class schedule for times this class is offered in the library's Computer Education Center.
Callahoose Grades
An example of a class list of various grades and averages, and a graph showing the results.
Class List
A sample CLASS LIST to work with -- learn the Max, Min, and Average functions to construct meaningful formulas.
Friends List 1
A database of 5 imaginary names and addresses for use in creating a fictitious mailing label list in a mail merge exercise.
Pivot Tables
From Microsoft's Tutorials, this Pivot Table exercise is meant to get users started with using this powerful report-building tool.
Sales
Understand absolute values when using this spreadsheet. Troubleshoot the errors and correct them. See how absolute referencing can be used with the more-popular relative referencing tools.
Salespersons' Commission Without Formulas
This exercise, from Professor Furman's website, explores not only absolute referencing, but use of the STDEV and AVERAGE functions as well as the IF function.
Zale's Simplified
This spreadsheet displays an imaginary amount of money taken in by a store for selling a certain amount of inventory. Formulas are used to compute the amount taken in as well as the totals taken in thus far. A graph can be created comparing inventory on hand with sold inventory so the "store" can see where it stands at any given time.

Excel Tips, Tricks, and Extras

GCF Global Quick Tips for Excel
Tips from GCF Global
GCF Global Excel Formulas
Formulas from GCF Global
Excel Tips Every User Should Master
Article from techrepublic
Excel Tips to Help You Become a Spreadsheet Pro
Article from pcmag
When and How to use VLOOKUP in Excel
Information from Microsoft Support
Paste Links for data, charts and formulas in Excel
May 25, 2019 Article from Lifewire by Ted French.
Video Tutorial Creating Macros in MS Excel
From "Technology for Teachers and Students" on YouTube -- about 14.5 minutes long, nice pace, created in July 2019.
Stackoverflow.com
Have a specific question about how to do something in Excel? Stackoverflow may already have the answer, check their message boards for helpful information