Here’s your chance to review the basics of working with Microsoft Excel, including: creating, formatting, and entering data into a workbook with multiple worksheets; adding a Summary worksheet; using relative and absolute cell references in formulas; creating and referencing a VLOOKUP table; and more.
The attached file provides step-by-step instructions. Please right-click the link to the “Instructions” file below, download or save to a location where you can easily find it, and then open the file to follow along.
Basics Review Part 1
Basics Review Part 2
Disclaimer: Instructions for each exercise are written in MS Office 2016 on a PC. All videos demonstrate completing exercises using Windows 10 and MS Office 2016. If you are using a Mac computer, a Mac version of MS Office, an older PC operating system, or a different version of MS Office, you may notice differences. Remember, Google can be your best friend when it comes to technology questions!
