Image
Click on image to expand.
Event Details
This advanced-level course is designed for experienced Excel users who want to master powerful tools for data analysis, automation, and decision-making. Students will explore complex functions, advanced charting, and productivity-enhancing features to streamline workflows and gain deeper insights from data.
Students will learn to:
- Use advanced functions such as INDEX, MATCH, INDIRECT, and nested formulas
- Create and customize advanced PivotTables and PivotCharts
- Perform data analysis using What-If tools (Goal Seek, Scenario Manager, Data Tables)
- Use Power Query to import, clean, and transform data from multiple sources
- Create and manage dynamic dashboards with interactive elements
- Automate repetitive tasks using macros and the Visual Basic for Applications (VBA) editor (intro level)
- Apply advanced data validation techniques and error checking
- Use advanced chart types (e.g., combo charts, waterfall charts, sparklines)
- Protect and share workbooks with advanced security settings
- Consolidate data from multiple worksheets and workbooks
- Troubleshoot and audit complex formulas using tracing and evaluation tools
- Optimize workbook performance and manage large datasets efficiently
Admissions and Additional Details
To register and submit payment, simply click the “Click Here to Register” button above to access our official registration and payment portal.
📍 Visit us: 1351 S. Redondo Center Dr., Yuma, AZ 85365
📞 Call us: 928-317-7674
📧 Email: continuinged@azwestern.edu
Location Details
This workshop will take place at the AWC Reskilling & Technology Center.
1351 S Redondo Center Dr.
Yuma, AZ, 85365
Attachment(s)
Excel 2021365 1, 2, & 3 Flyer 11.7 - 11.21.25.pdf