This course is designed to be the intermediate level of Excel 2013. Students will learn intermediate functions and formulas, be introduced to and work with PivotTables and Tables, work with Charts, work with Flash Fill, work with subtotals and outlining, and learn how to customize the Excel environment.

Customizing Excel, Linking Workbooks & Worksheets, Working with Range Names, Analyzing Data with Common Logical Functions, Analyzing Data with Common Lookup Functions, Sorting and Filtering Range Data, Analyzing and Organizing with Tables, Using Conditional Formatting, Outlining with Subtotals and Grouping, Displaying Data Graphically, Understanding PivotTables, PivotCharts, and Slicers, Working with Flash Fill, Working with Date and Time Functions, Working with Common Text Functions