91015: Microsoft Office Excel 2013: Part 2

Microsoft Office Excel 2013: Part 2 is a one-day course that teaches you data analysis skills and abilities through the application of advanced Excel 2013 functionality such as advanced formula creation, tables, charts, PivotTables and PivotCharts.

Exam Number:
77-428
Exam Name:
Excel 2013 Expert Part Two
Certifications:
MOS
Duration:
1 Day

Upcoming Dates

Apply
Class Date Class Hours Location GTR Price  

What's Included

  • Digital Microsoft Official Curriculum (dMOC)

Course Content

Upon completing this course you will be able to:

  • Create Advanced formulas
  • Analyze data with logical and lookup functions
  • Organize worksheet data with tables
  • Visualize data by using charts
  • Analyzing data with PivotTables, slicers, and PivotCharts
  • Insert graphic objects
  • Enhance workbooks

Course Outline

Lesson 1: Create Advanced Formulas

  • Topic A: Apply Range Names
  • Topic B: Use Specialized Functions

Lesson 2: Analyze Data with Logical and Lookup Functions

  • Topic A: Leverage Questions and Testing to Write Formulas
  • Topic B: Use Logical and Lookup Functions to Find Answers to Questions

Lesson 3: Organizing Worksheet Data with Tables

  • Topic A: Create and Modify Tables
  • Topic B: Sort and Filter Data
  • Topic C: Use Summary and Database Functions to Calculate Data

Lesson 4: Visualizing Data with Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Create a Trendline
  • Topic D: Create Advanced Charts

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

  • Topic A: Create a PivotTable
  • Topic B: Filter Data by Using Slicers
  • Topic C: Analyze Data by Using PivotCharts

Lesson 6: Inserting Graphics

  • Topic A: Insert and Modify Graphic Objects
  • Topic B: Layer and Group Graphic Objects
  • Topic C: Incorporate SmartArt

Lesson 7: Enhancing Workbooks

  • Topic A: Customize Workbooks
  • Topic B: Manage Themes
  • Topic C: Create and Use Templates
  • Topic D: Protect Files