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 Sparklines feature. Database management, PivotTables, PivotCharts, and Slicers are covered in detail, as well as importing and exporting Excel data to and from other applications.
The recommended prerequisite for this course is Basic Microsoft Windows and Intermediate Microsoft Excel 2010 training or equivalent experience.
This IAAP-certified course counts for 3 recertification points for the CAP certification under the Operational Functions content area. Email [email protected] with proof of completion of the course to obtain your certificate.