Advanced Techniques in Excel

Prerequisites: Instructor-Managed Waitlist & Course Application. This short course explores techniques that enable sophisticated problem solving and data analysis in Microsoft Excel. Topics include implementing advanced logic using complex formulas and intermediate calculations; managing complexity with Excel's auditing features; importing, parsing and cleaning raw data; pulling data together using lookup functions; and summarizing and analyzing data with conditional aggregate functions and PivotTables. This course does not focus on specific policy or financial applications, but instead explores general concepts and techniques that can be flexibly applied to different solutions in Excel.