Southern Illinois University Edwardsville Logo
Apply to SIUE
School of Business

Cougar Business Resource Center

School of Business

VLOOKUP & Complex Formulas

This exercise provides practice with AVERAGE, IF, and VLOOKUP functions; cell and worksheet formatting; calculations using dates; complex formulas; getting external data from MS Access; MS Query Wizard; nesting functions; and Pivot Tables and Pivot Charts to summarize and analyze collected statistics.

Attached are three (3) files: Instructions, a starting file, and a MS Access database file to import. Please right-click each link, download or save to a location where you can easily find them, and then open the Instructions file for step-by-step instructions to begin your work. NOTE: If you do not have MS Access installed on your computer, you cannot open the database file directly. You do not need to open the MS Access file – you will only import the data into MS Excel!

VLOOKUP & Complex Formulas Video

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 googleplusoff tumblroff socialoff