University of Evansville

Ready to level up? This workshop takes your Excel skills beyond the basics and focuses on tools that streamline your work and improve accuracy. You’ll learn how to manage larger data sets, use conditional formatting, work with multiple worksheets, and apply functions like IF, VLOOKUP, and COUNTIF. By the end, you’ll be able to make your spreadsheets more powerful and insightful, saving time and reducing errors in your day-to-day tasks. Key skills you’ll gain:  Working with formulas for more complex calculations Linking and managing data across multiple sheets via 3D references, external references as well as using hyperlinks to link worksheets to other Microsoft office documents Using logical and lookup functions to extract insights Applying conditional formatting for quick data analysis Learn how to Nest functions with rounding your solutions & and/or/if Learn how to utilize Excel Tables to expedite formatting and perform calculations Learn how to filter your data via multiple tools This offering can be part of a 3 part series on Excel.