This course is designed to be the intermediate level and increase knowledge of Excel 2013. Students will learn intermediate functions and formulas, including creating and using range names, and logical, lookup, date and time, and common text functions. Students will analyze large amounts of data by creating, manipulating, and modifying PivotTables, PivotCharts, and Excels Table features. In addition, students will display data graphically by creating and modifying Charts, and applying Conditional Formatting. Students will learn to master Flash Fill, create automatic subtotals with the Subtotals feature and apply outlining. Finally, students will learn how to customize the Excel environment to suit their needs.This IAAP-certified counts for 4 recertification points for the CAP certification under the Technology and Information Distribution content area. Email email@example.com with proof of completion of the course to obtain your certificate.