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 Excel’s 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.