Free Stuff
Exercise Files + Tips 'n Tricks
Excel | Word | PowerPoint | Access | SQL | Power BI
How can I download and open these exercise files?
Step 1: Download the File
- Click the link.
- A small window may appear asking if you want to Save or Open the file.
If prompted choose Save (or Save As if you’d like to choose where it goes).
If not prompted, the will probably be saved in your Downloads folder.
Step 2: Locate the File
- On a Windows PC:
- Press Windows Key + E to open File Explorer.
- Click Downloads from the left-hand menu.
- On a Mac:
- Open Finder and select Downloads from the sidebar.
Step 3: Open the File in Excel
- Double-click the file.
- If the related application is installed, it will open automatically.
- If prompted with a security warning (e.g., “Enable Editing”), click Enable Editing to begin working.
💡 Tip: If you don’t see the file, try sorting your Downloads folder by Date Modified—your newest files will appear at the top.
Microsoft Excel
- Tip: "Microsoft Excel Cursor Types and What They Mean" from KnowledgeWave
- Tip: "Using structured references with Excel tables" from Microsoft
-
Download the exercise files that accompany TechMentors’ Excel Review and Quick Reference course
-
Test your Excel formatting skills by creating a diagram of Ansoff’s strategic planning tool
-
Learn how to create a monthly calendar. Includes opportunities to practice formulas, formatting, resizing columns, inserting rows, applying custom number formats, and data validation.
-
Learn how to create a monthly calendar. Includes opportunities to practice essential Excel skills like how to AutoFill a series, create Named Ranges, enter formulas in plain English, apply various formatting tricks, add conditional formatting and more.
-
Follow this step-by-step exercise to format and enhance a list of properties in Hasbro’s Monopoly game.
-
This sample file lists 5406 movies, their rating, category, and release year.
-
This sample file contains a list of of over 2000 orders for the Northwind Traders Company
-
This sample file contains sales data for the Xtreme Bicycle Sales company.
Microsoft PowerPoint
-
Microsoft provides a list of keyboard shortcuts for PowerPoint for Windows, macOS, iOS, Android and Web versions.
-
This sample file lists 5406 movies, their rating, category, and release year.
-
This sample file contains a list of of over 2000 orders for the Northwind Traders Company
Free Courses
Computer Skills
-
Study how computers work, the difference between hardware and software, the different types of computers, operating systems, applications and the cloud.
-
Provides a short introduction to computer science topics like programming, the use of algorithims, binary, hardware, software and more.
-
Master basic mouse skills through an interactive tutorial and by playing some games.
-
Use this interactive course to improve your typing skills.
-
Learn the basic skills you need to use a computer. Learn how to use Help, Undo mistakes, download files, PDF files, setting up a printer, and a whole lot more.
-
Master the basics of and tips and tricks for using Microsoft Windows.
-
Learn the basics of running an Apple Macintosh computer.
-
Find out what’s different with Micrsoft 365 on an Apple Macintosh computer.
-
Learn 17+ useful tips and tricks that will boost your efficiency with a computer.
Spreadsheets
-
This beggining Excel book (PDF) covers essential spreadsheet skills including formulas, formatting, data entry, and printing with hands-on exercises and TechMentor tips.
-
This Zip file contains the exercise files and PDF manuals used in the Excel Introduction – Intermediate classes at Bridgerland Technical College
-
This Zip file contains the exercise files and PDF manuals used in the Excel Introduction – Intermediate classes at Bridgerland Technical College
-
Learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.
-
Learn these Excel tips and tricks so you can do more with this popular spreadsheet program.
Word Processing
-
Learn how to format text, save and share documents, modify line and paragraph spacing, use tables and columns, and do more with your documents.
-
Learn tips and tricks to create professional, polished documents.
Presentations
-
Learn how to use themes and background styles, add pictures and clip art, modify charts and lists, and do more to create standout presentations.
-
Learn these PowerPoint tips and tricks so you can do more with this popular presentation program.
-
Learn these PowerPoint tips and tricks so you can do more with this popular presentation program.
-
Learn these PowerPoint tips and tricks so you can do more with this popular presentation program.
Databases
-
Learn the basics of using and creating a Microsoft Access database with tables, queries, forms, and reports.
Family History and Geneology
-
The Family History Guide is a free website that represents a best-in-class learning environment for family history.
-
A six-lesson beginner-friendly online course designed to help learners build foundational genealogy skills including Recording Genealogical Information, Building a Family Tree, Using Genealogy Software, and Locating Vital Records.
-
Learn how to use FamilySearch.org to Build Your Family Tree, Search Historical Records, Discover Information about your Ancestors, Save Your Family Memories (Photos, Stories, Documents) for Future Generations, and Enjoy Family History fun with creative activities that make genealogy more accessible and enjoyable.
-
Video and Step-by-step instructions to create a free account on FamilySearch.org.
