When interviewing a job candidate for their technical skills in Excel, most interviewers ask, “Can you do a VLOOKUP?” One more skill set they should be asking for is, “Do you know how to do nested logic?” With these skill sets, an analyst can do amazing things with Excel. 

This course will go over examples of each of these skill sets and introduce you to spinner buttons. 

Spinner buttons are rarely utilized but are very easy to set up and use, particularly when you want to see immediate changes in your spreadsheet when changing variables. Even if you are not building these analyses, you should know of these capabilities in Excel.

Learning Objectives:

• Recall various examples of nested logic


• Identify how to use and build a spinner button


• Determine how to perform functions beyond a VLOOKUP