You’ll gain hands-on experience with advanced logical and financial functions, explore Excel’s What-If analysis tools like Scenario Manager, Goal Seek, and Data Tables, and discover how to protect, validate, and clean your data to ensure accuracy. You’ll also learn how to build dashboards and visual tools that communicate key insights with clarity and confidence.

Course Outcomes

1. Apply advanced logical functions (including AND, OR, NOT, and IF statements) to evaluate complex business conditions.
2. Perform financial calculations using Excel’s built-in functions to compute loan payments, interest, present value, and payment periods.
3. Use What-If Analysis tools, including Scenario Manager, Goal Seek, and Data Tables, to forecast and compare business outcomes.
4. Implement data validation rules to protect data integrity and avoid entry errors and duplication.
5. Import and export data between workbooks and other sources while maintaining data accuracy.
6. Protect workbooks and sensitive data, ensuring accuracy and security in shared files.
7. Create pivot tables and dashboards to summarize and visually display insights for confident business decision-making.

• Professionals working with budgets, forecasting, or data analysis
• Managers and business analysts who need to model and evaluate complex data scenarios
• Experienced Excel users ready to move beyond intermediate skills
• Entrepreneurs and financial decision-makers looking to make strategic decisions based on clean, accurate data
• Anyone responsible for preparing, protecting, and presenting data to guide organizational outcomes

There are still openings remaining at this time.