This Microsoft Excel course covers advanced Excel skills utilizing analytical tools, including the Analysis ToolPak, forecast sheets, and various statistical methods alongside Goal Seek, Solver, and What-If Analysis tools for scenario-based analysis. Data integrity is emphasized through data validation rules, error-checking formulas, conditional formatting, and version control. You will even gain skills in automating tasks with macros and VBA.
PivotTables and PivotCharts are also explored in depth, from basic creation to advanced customization and multi-source analysis. By the end of this Microsoft Excel training program, you will be proficient in Excel's advanced features, ready to apply them to real-world scenarios.
About The Instructor
Chad Wambolt
Chad Wambolt has spent his entire professional career in the finance field, working for both private and publicly-held companies with sales ranging from $500 million to $3 billion. He is a graduate of Boise State University, where he obtained his bachelor's degree in accounting. Through the course of his career, Wambolt became an expert user of Microsoft Excel. Since 1997, he has taught Excel to students of varying skill levels and helped organizations streamline internal processes.