NOTE: Please make your submissions no later than Monday, August 14th at 1:00 pm EST, so the data can be compiled before class.
Download Instructions:
Create a New Folder on your Desktop (or somewhere on your computer where you can easily find it). Rename the New Folder “Spotlight Pivot Tables Resources“.
Download each of the files below by Right-Clicking and choosing “Save link as…” (or “Download Linked File As…”). Find the “Spotlight Pivot Tables Resources” folder and save the file inside that folder.
Create a New Folder on your Desktop (or somewhere on your computer where you can easily find it). Rename the New Folder “Spotlight Pivot Tables Exercises“.
Download each of the files below by Right-Clicking and choosing “Save link as…” (or “Download Linked File As…”). Find the “Spotlight Pivot Tables Exercises” folder and save the file inside that folder.
This training program will be taught using Excel on a PC computer. Having said that, the material is transferable to both MAC users as well as Google Sheets users. The shortcuts and user interface in the training may differ slightly, but the concepts are the same.
Internet
If possible, it is strongly recommended to NOT use WiFi during the training sessions, since it may not provide a reliable connection.
Instead, connect your computer to your modem/router using an ethernet cable for the highest speed and most reliable connection.
Computer
You may use a laptop or a desktop computer for this class, but because of the nature of the class and the hands on exercises, you may NOT use an iPad, tablet, or smartphone.
If using a laptop, bring a power charger so you do not run out of battery! (Sadly, it has happened before).
Zoom Etiquette
Be considerate: Please be considerate of other participants by turning off the TV, music, or any other background noise that you can control.
Headphones/Earphones: You must use headphones/earphones during the class, to avoid distracting echos.
Close all other programs: Please close all other programs except for Zoom and Excel/Google Sheets during the class. Not only will your computer run more smoothly, but in case you decide to share your screen, you will avoid potentially embarrassing moments (unfortunately, it has also happened before).
Excel Users ONLY
Tech Requirements
If you will be using Microsoft Excel (PC or MAC) for this training program, you must have a fully functional version of Microsoft Excel installed on your computer. That means it has been purchased, and there is a license key. That means you are NOT using a free trial version.
Versions of Excel that WILL work with this class:
Excel 365 for PC Excel 2021 for PC Excel 2019 for PC
Excel 365 for Mac Excel 2021 for Mac Excel 2019 for Mac
Versions of Excel that will NOT work with this class:
Any Free Trial version for PC Any Free Trial version for Mac Excel 2016 for PC or earlier Excel 2016 for Mac or earlier
Google Sheets Users ONLY
Tech Requirements
If you will be using Google Sheets (PC or MAC) for this training, it is strongly recommended to use the Google Chrome web browser. Any web browser can run Google Sheets, but if you use a web browser that is NOT Google Chrome, then certain shortcuts may be impacted and it will not be as smooth of an experience for you.
Or, if you already have it installed, please ensure you have the latest version of Google Chrome by following the steps in this help article to Update Google Chrome.
