Excel 2013 - Part 2

Students will build upon the foundational Microsoft® Office Excel® 2013 knowledge and skills already acquired and learn to create advanced workbooks and worksheets, including advanced formulas, tables, PivotTables, PivotCharts and data filtering.

Lesson 1: Customizing the Excel Environment

» Configure Excel Options
» Customize the Ribbon and the Quick Access Toolbar
» Enable Excel Add-Ins

Lesson 2: Creating Advanced Formulas

» Use Range Names in Formulas
» Use Specialized Functions
» Use Array Formulas

Lesson 3: Analyzing Data with Functions and Conditional Formatting

» Analyze Data by Using Text and Logical Functions
» Apply Advanced Conditional Formatting

Lesson 4: Organizing and Analyzing Datasets and Tables

» Create and Modify Tables
» Sort Data
» Filter Data
» Use SUBTOTAL and Database Functions

Lesson 5: Visualizing Data with Basic Charts

» Create Charts
» Modify and Format Charts

Lesson 6: Analyzing Data with PivotTables, Slicers, and PivotCharts

» Create a PivotTable
» Analyze PivotTable Data
» Present Data with PivotCharts
» Filter Data by Using Slicers