This course delves into a variety of topics beyond the basics. You will learn how to use a wide range of financial, logical, text, and statistical functions; analyze data with the scenario manager; apply conditional formatting; and use the new Sparkline feature. Database management, PivotTables, PivotCharts and Slicers are covered in detail, as well as importing and exporting Excel data between applications.This IAAP-certified counts for 3 recertification points for the CAP certification under the Operational Functions content area. Email with proof of completion of the course to obtain your certificate.