Microsoft Excel - Level 2 / Med (2010, 2013, 2016)

Use Tables

• Create a Table From Data
• Modify Table Format and Structure
• Use Structured References in a Table

Formulas and Functions

• Understand Mathematical Operators
• Use AutoFunctions
• Use Relative and Absolute References
• Explore the Function Ribbon and Overview of Categories
• Use the Insert Function Wizard and Dialog Box
• Use Basic Text, Financial, Date, and Logical Functions
• Name and Use Ranges of Cells in Formulas
• Use Array Formulas
• Audit Formulas
• Trace and Remove Trace Arrows
• Use a Watch Window

Sort and Filter

• Use Basic Sort Options
• Advanced Sort Options
• Use Autofilters
• Create Custom Autofilters
• Use Advanced Filters
• Use Data Validation
• Use Database Functions

Enhance A Workbook

• Insert Symbols and Characters
• Add and Format Shapes
• Manipulate Shapes
• Use and Modify SmartArt
• Add a Signature Line
• Add and Format Text Boxes and WordArt
• Use Screenshot
• Link and Embed Objects

Protect and Finalize

• Add Protection
• Allow Edit Options within Protection
• Info Panel Options*
• Share Panel Options*
• Use the Document Inspector
• Check Compatibility and Mark as Final
• Customize Excel Options

Views

• Create Custom Views
• Hide Workbooks, Sheets and Cells
• Set File Properties

Use Tables

• Create a Table From Data
• Modify Table Format and Structure
• Use Structured References in a Table

Formulas and Functions

• Understand Mathematical Operators
• Use AutoFunctions
• Use Relative and Absolute References
• Explore the Function Ribbon and Overview of Categories
• Use the Insert Function Wizard and Dialog Box
• Use Basic Text, Financial, Date, and Logical Functions
• Name and Use Ranges of Cells in Formulas
• Use Array Formulas
• Audit Formulas
• Trace and Remove Trace Arrows
• Use a Watch Window

Sort and Filter

• Use Basic Sort Options
• Advanced Sort Options
• Use Autofilters
• Create Custom Autofilters
• Use Advanced Filters
• Use Data Validation
• Use Database Functions

Enhance A Workbook

• Insert Symbols and Characters
• Add and Format Shapes
• Manipulate Shapes
• Use and Modify SmartArt
• Add a Signature Line
• Add and Format Text Boxes and WordArt
• Use Screenshot
• Link and Embed Objects

Protect and Finalize

• Add Protection
• Allow Edit Options within Protection
• Info Panel Options*
• Share Panel Options*
• Use the Document Inspector
• Check Compatibility and Mark as Final
• Customize Excel Options

Views

• Create Custom Views
• Hide Workbooks, Sheets and Cells
• Set File Properties