This in-person session [MT419A], is a BYOD (Bring Your Own Device) bootcamp, where participants can elevate their Excel Skills with hands-on practice. We'll start with essential formulas and functions to streamline your calculations, then dive into powerful LOOKUP and reference functions for advanced data handling. Learn how to manage and organize large datasets efficiently, and finish by creating dynamic charts that bring your data to life. This session is perfect for anyone looking to master Excel and boost productivity in the workplace.  

What You'll Learn 

Arrival & Setup: 8:30 am-9:00 am 

• Connect to Wi-Fi

First Half of Session (Excel Formulas, Functions, and LOOKUP Functions): 9:00 am- 10:30 am 

• Apply essential Excel functions

• Retrieve data with LOOKUP functions

• Use MATCH to locate values within data sets

• Apply HSTACK to support the analysis of multiple fields

Second Half of Session (Managing Data, Creating & Editing Charts): 10:30 am-12:00 pm 

• Use sorting and filtering to manage data. 

• Apply freeze panes working with large data sets. 

• Convert data ranges to tables. 

• Create and edit charts for meaningful visuals. 

NOTE: We will be using Microsoft 365. This training is come and go as needed. You do not have to stay for the entire training if only section applies to you. 

What to Expect 

Participation: Level 2/3: Engage & Exchange (Medium Participation)   
Description: Opportunities to exchange perspectives and deepen understanding through dialogue.   
Activities: Follow-Along Demo, Q&A, Hands-On Practice 
Learn More: Learn More About Participation Levels 

Who Should Attend 
Any UAB Staff and Faculty 
NOTE: Learning & Development programs and services are provided as a benefit to UAB Staff and Faculty.  

Need Assistance?  
For questions or accommodation requests, please contact Learning & Development at learndev@uab.edu or call (205) 934-3359.