Join us for the second of three courses that will take participants from the foundational basics of Excel to more advanced functionality. During this course participants will learn various intermediate and advanced functions that allow a user to analyze data in an effective way, as well as put Excel to work for the user. Participants of this course will also receive documentation of the functionality discussed during the course which can be used as a reference later on.
Where possible, participants should bring a Windows laptop with Excel 2007 or later. Mac laptops will run a version of Excel however there may be drastic differences.
Excel functionality you’ll learn:
• Conditional Formatting
• Sparklines
• Vlookups
• IF Statements & Nested IF Statements
• Macros
• Hlookups (Written documentation will be provided, will not be reviewed in this session)
** Registration required prior to workshop