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 socialoff