Participants will explore some of Excel’s most rewarding features in this engaging and practical course. Despite the “Advanced” label, the class builds on intermediate skills rather than presenting high difficulty. Topics include mastering Pivot Tables, consolidating workbooks, creating shared and saved workspaces, and using data validation with range names. Attendees will also learn how to remove duplicate records, outline spreadsheets, work with advanced macros, and use the Text to Columns command. Additional skills covered include protecting formula-containing cells, creating Pareto charts and histograms, using advanced Goal Seek, and working with VLOOKUP functions.

This course is a part of a four-week training program recurring for four weeks on Tuesday, June 10, 17, 24, and July 1.