Excel Level III @USI

Advanced Analysis, Reporting, and Productivity. Take your Excel skills to the next level with Microsoft Excel Level III, an advanced course designed for experienced users who want to work smarter, analyze data more effectively, and create professional-quality reports. In this 4-hour, hands-on session, participants will expand their knowledge of Excel's powerful analytical tools and advanced functions.
Some topics covered include:

• Advanced functions and formulas, including IF, VLOOKUP, and text functions
• Using Function Wizards and managing complex and nested formula arguments
• Advanced filtering and data management techniques
• PivotTable Slicers for easier data analysis
• Goal Seek and What-If Analysis tools
• Working within Data tables for forecasting and scenario planning
• Sparklines and visual data summaries
• Introduction to macros for automating repetitive tasks