This intermediate Excel course is designed for professionals with foundational skills who want to elevate their data management and presentation capabilities. You will learn to organize complex datasets using multi-column sorting, custom filters, and dynamic functions such as SORT, SORTBY, and FILTER. The course covers a wide range of chart types—from bar and line to histograms and sunbursts—along with tools like sparklines and trendlines to visualize trends. You will also master working with dates, times, and text. The course applies mathematical and logical functions for problem-solving and explores Excel's various optimization tools.
Additional topics covered include enhancing worksheet appearance with images and formatting, secure collaboration through workbook protection, and customizing Excel's interface with ribbons and add-ins. Lastly, the practical exercises throughout the course will ensure you build efficient, professional spreadsheets that get the job done.
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.