UpcomingExcel 2013 Level 3

Jennifer Shearer

Price Qty*
August 28, 2017 show details + $267.75 (CAD)  
September 27, 2017 show details + $267.75 (CAD)  
October 27, 2017 show details + $267.75 (CAD)  
November 28, 2017 show details + $267.75 (CAD)  

  • August 28, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • September 27, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • October 27, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)
  • November 28, 2017
    8:30 am - 4:00 pm
    - Datetime Description (optional)

Microsoft Excel 2013 Level 3

Course Length: 1 day (8:30 a.m. – 4:00 p.m.)    Instructor Led Training

Course Objective: This Microsoft Excel course takes students on a journey that highlights the upper-level skills which will allow them to get the most bang for their buck from this powerful software. Over the course of modules, students will get a look at conditional formatting, slicers, Power View, the Inquire Add-In, tables, records and fields, using Excel as a database, custom AutoFill lists, comments, tracking changes, and linking, consolidating, and combining data.

Prerequisites: This course presumes that the user has a basic knowledge of Windows, including concepts such as using the mouse and keyboard. With respect to Excel, we also presume that the user has completed the Intermediate level of this course (or has equivalent knowledge) and is familiar with concepts such as copying, pasting, organizing worksheets, basic cell formatting, understands & can select ranges, can create and manipulate Excel data tables, use Excel functions, work with external data sources and can create Excel Charts.

Course Content:

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

Review Questions

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

 

 

Jennifer ShearerUpcomingExcel 2013 Level 3