Applied Excel - LIVE!

This intensive workshop is designed to improve the participant's ability to efficiently use Excel to clean up, analyze and interpret data. Including advanced excel functionality focused on data manipulation and management.

By the end of this session, participants will have gained hands-on experience and practical skills in using Excel to work efficiently with data, perform in-depth data analysis, conduct scenario modeling, and present insights visually.

Key topics covered:-

•Working with client data:
-Text to columns
-Text functions within Excel: LEFT, RIGHT, UPPER, LOWER, CONCATENATE)
•Analyzing data:
-Lookup functions (XLOOKUP, VLOOKUP, HLOOKUP)
-INDEX and MATCH Functions
-Analyzing data using SUMIF, COUNTIF, Nested IF, and SUMPRODUCT
-Pivot Tables
•Scenario analysis:
-Sensitivity analysis including data tables
-Conditional formatting
-Scenario analysis using CHOOSE & OFFSET functions
-Utilizing ""named"" cells
•Introduction to graphing and visualizations:
-Introduction to Excel charts
-Basic functionality of charts