In this hands-on workshop, you will use comprehensive Excel learning files to learn more about what Excel can do – and maybe even become an Excel expert! You will practice using advanced Excel formulas and Excel features specifically chosen for their broad applicability and utility to complete a variety of exercises. Prerequisite: ability to manually create simple formulas, Excel 365 for desktop preferred, but content is almost entirely compatible with Excel 2016+ (Windows or Mac). 

After attending or viewing the workshop session, you will be able to: 

• Explain formulas, formula parts and their variations, embedded formulas, and absolute versus relative referencing. 
• Build the following formulas in Excel using the formula-building approach of your choice: conditional formulas (sumIf, sumIfs, OR, AND, IF), lookup formulas (VLookup or XLookup), and more (countA, maybe text formulas such as left, mid, right, find). 
• Practice using the following built-in Excel features: remove duplicates, paste as values, go to special, advanced find/replace, and flash fill.