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: "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.
-
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
-
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.
-
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.
-
Learn how to create formulas and charts, use functions, format cells, and do more with your spreadsheets.
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.
Internet
-
Improve your Internet skills so you can connect, use the cloud, download and upload files, and do more online.
-
Staying safe online is essential in today’s world. Use these Internet safety tips to keep yourself and your loved ones protected.
-
Learn tips and strategies to keep your kids safe from hackers, predators, and cyberbullies.
-
Learn how to use social media to stay in touch with friends and family, promote your cause, or keep up with news
-
Learn Zoom’s main functions. Includes how to set up an account, join/host meetings, and more.
-
Learn how to get started with computer programming, including what it is, what you need to know to succeed, and what tools it requires. This tutorial will prepare you for the Basic HTML and Basic CSS tutorials.
-
Learn the basics of HTML, a computer language for building webpages. We’ll show you how to write HTML, create your own webpages, and more.
-
Learn the basics of CSS, a computer language for styling webpages. We’ll show you how to write CSS, incorporate it into your own webpages, and more.
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.
