Skip to Main Content

Microsoft Excel 2013 Expert  (MO13EX301)

Time: 9am - 4pm
Duration: 1 day

Compatible with 2013

Description:

In this course you will learn how to: conditionally format data; work with Slicers; work with Power View; work with Inquire Add-In; use Tables; work with Records and Fields; use Excel as a database; create custom AutoFill lists; add comments; track changes; link, consolidate, and combine data.

Prerequisites:

MO13EX201—Microsoft Excel 2013 Advanced Essentials or equivalent is mandatory.

Public Class Schedule

Location Language Date Price Register
Ottawa English April 16 $ 275.00
Web-based(Opens in new window) English April 16 $ 275.00

We're Here to Help

Don't see the dates you need? Call us at 888.484.2933 or Tell Us What You Need.

Course Outline

  • Module 1: Using Conditional Formatting
    • Applying Conditional Formatting
    • Applying Multiple Rule Sets
    • Creating Custom Rule Sets
    • Viewing and Managing Rules
    • Clearing Custom Rules
  • Module 2: Working with Slicers
    • Inserting and Using a Slicer
    • Renaming the Slicer
    • Changing Slicer Settings
    • Formatting a Slicer
    • Clearing the Slicer
  • Module 3: Using Power View, Part One
    • Enabling Power View
    • Creating a Power View
    • Adding and Removing Fields
    • Arranging Fields
    • Filtering Data
    • Sorting Data
  • Module 4: Using Power View, Part Two
    • Refreshing Data
    • Choosing a Visualization
    • Changing Tile Display
    • Setting Display Options
  • Module 5: Using the Inquire Add-In
    • Installing Inquire
    • Generating a Workbook Analysis Report
    • Viewing Workbook and Worksheet Relationships
    • Viewing Cell Relationships
    • Comparing Two Workbooks
  • Module 6: Working with Tables
    • What is a Table?
    • Creating Tables
    • Resizing the Table
    • Choosing a Table Style
    • Clearing the Table
  • Module 7: Working with Records and Fields
    • What are Records and Fields?
    • Adding Fields by Inserting Columns
    • Adding Records by Inserting Rows
    • Deleting Records or Fields
  • Module 8: Using Excel as a Database
    • Filtering with Wildcard Characters
    • Validating Your Data
    • Data Validation Using Lists
    • Data Validation Using Formulas
    • Using Database Functions
  • Module 9: Using Custom AutoFill Lists
    • Creating a Custom AutoFill List
    • Using a Custom AutoFill List
    • Modifying a Custom AutoFill List
    • Deleting a Custom AutoFill List
  • Module 10: Using Comments
    • Inserting Comments
    • Editing Comments
    • Navigating Through Comments
    • Deleting Comments
  • Module 11: Tracking Changes
    • Tracking Changes
    • Reviewing Changes
    • Setting Options for Tracking Changes
    • Stopping Tracking Changes
  • Module 12: Linking, Consolidating, and Combining Data
    • Linking Workbooks
    • Consolidating Workbooks
    • Consolidating Worksheets
    • Pivoting Consolidated Data

Private training is available for this course.

Call us at 1-888-484-2933 to learn more about our flexible scheduling options or complete our Information Request Form.

© 2017 Eliquo, Inc. All rights reserved.

Back to Top