Southern Illinois University Edwardsville Logo
Apply to SIUE

School of Business

Cougar Business Resource Center

School of Business

Basics Review 

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!


facebookoff twitteroff vineoff linkedinoff flickeroff instagramoff socialoff