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

Master advanced Excel techniques tailored for professionals seeking to elevate their data management skills with comprehensive training in formulas, functions, and workbook protection.

Course Thumbnail

Essential Skills Gained

Checkmark

Understand and utilize advanced formulas and functions.

Checkmark

Create and format tables using structured references.

Checkmark

Enhance workbooks with graphics and SmartArt.

Checkmark

Apply protection and finalize workbooks efficiently.

Format

  • Instructor-led
  • 1 days with lectures and hands-on labs.

Audience

  • Intermediate Excel Users
  • Data Analysts
  • Accountants
  • Project Managers

Description

Course Description This course will teach you how to use formulas and advanced functions, create and format tables, sort and filter, add and format graphics, and protect and finalize a workbook. Items marked with an asterisk* are taught for 2010 only.

Calendar icon

Upcoming Course Dates

No upcoming dates. Please check back later.

Course Outline

Download PDF

Explore the User Interface

  1. Office Button (2007)

  2. Backstage View*

  3. Ribbon Overview

  4. Mini Toolbar

  5. Status Bar

  6. Shortcut Key Tips

  7. Contextual Tabs

Views

  1. Create Custom Views

  2. Hide Workbooks, Sheets and Cells

  3. Set File Properties

Formulas and Functions

  1. Understand Mathematical Operators

  2. Use AutoFunctions

  3. Use Relative and Absolute References

  4. Explore the Function Ribbon and Overview of Categories

  5. Use the Insert Function Wizard and Dialog Box

  6. Use Basic Text, Financial, Date, and Logical Functions

  7. Name and Use Ranges of Cells in Formulas

  8. Use Array Formulas

  9. Audit Formulas

  10. Trace and Remove Trace Arrows

  11. Use a Watch Window

Use Tables

  1. Create a Table From Data

  2. Modify Table Format and Structure

  3. Use Structured References in a Table

Sort and Filter

  1. Use Basic Sort Options

  2. Advanced Sort Options

  3. Use Autofilters

  4. Create Custom Autofilters

  5. Use Advanced Filters

  6. Use Data Validation

  7. Use Database Functions

Enhance A Workbook

  1. Insert Symbols and Characters

  2. Add and Format Shapes

  3. Manipulate Shapes

  4. Use and Modify SmartArt

  5. Add a Signature Line

  6. Add and Format Text Boxes and WordArt

  7. Add and Format Pictures and Clipart

  8. Use Screenshot*

  9. Link and Embed Objects

Protect and Finalize

  1. Add Protection

  2. Allow Edit Options within Protection

  3. Info Panel Options*

  4. Share Panel Options*

  5. Use the Document Inspector

  6. Check Compatibility and Mark as Final

  7. Customize Excel Options

Your Team has Unique Training Needs.

Your team deserves training as unique as they are.

Let us tailor the course to your needs at no extra cost.