Excel 2: Boost Your Excel IQ: Mastering Functions

***IMPORTANT: PLEASE BRING YOUR OWN LAPTOP WITH DOWNLOADED SOFTWARE*** for workshops scheduled at Morgridge Hall! There are no desktop computers at this location and only a limited number of laptops to check-out from the front desk.

Download Excel for free from the Office 365 Portal (make sure you are signed in with your school email): https://portal.office.com/account

This workshop expands on the material in Excel 1 and introduces a wider array of built-in functions to make working with data easier.

Topics include:

• Logical functions including COUNT and COUNTIF
• Lookup, array, and summary functions
• Text formatting
• Linking data between workbooks and worksheets
• Formulas tab
• Keyboard shortcuts