Yawn-proof software training

Using Conditional Formatting

This module delves into Conditional Formatting in a way that users can grasp and exploit. It covers how to: apply conditional formatting, apply multiple rule sets, create custom rule sets, view and manage rules, and clear custom formatting rules.

  • Applying Conditional Formatting
  • Applying Multiple Rule Sets
  • Creating Custom Rule Sets
  • Viewing And Managing Rules
  • Clearing Custom Rules
Working with Slicers

Slicers allow you to quickly filter any data that is displayed within a PivotTable. In this module participants are shown how to: insert and use a slicer, rename a slicer, change slicer settings, format a slicer, and clear a slicer.

  • Inserting and Using A Slicer
  • Renaming the Slicer
  • Changing Slicer Settings
  • Formatting a Slicer
  • Clearing the Slicer
Using Power View, Part One

Power View has many applications for upper-level users of Excel 2013. Participants will learn in this module how to: enable Power View, create a Power View, add and remove fields, arrange fields, filter and sort data.

  • Enabling Power View
  • Creating a Power View
  • Adding And Removing Fields
  • Arrange Fields
  • Filtering Data
  • Sorting Data
Using Power View, Part Two

Power View is such a useful tool that it deserves an extra-close look which takes place here in Part Two. This module looks at how to: refresh data, choose visualization, change tile display, and set display options.

  • Refreshing Data
  • Choosing a Visualization
  • Changing Tile Display
  • Setting Display Options
Using the Inquire Add-In
The Inquire Add-In is only available in the Office Professional Plus 2013 and Office 365 Professional Plus editions. This module gives participants the tools on how to: install the Inquire add-in, generate a workbook analysis report, view a relationship diagram or report, view cell relationships, and compare two workbooks.

  • Installing Inquire
  • Generating a Workbook Analysis Report
  • Viewing Workbook and Worksheet Relationships
  • Viewing Cell Relationships
  • Comparing Two Workbooks
Working with Tables

Tables are efficient for dealing with ranges of data. Participants will learn what tables are and how to: create, resize and clear tables, and how to choose a table style.

  • What is a Table
  • Creating Tables
  • Resizing Tables
  • Choosing a Table Style
  • Creating the Table
Working with Records and Fields

Records and fields are the building blocks of data. Covered in this module is what they actually are and how to: add fields by inserting columns, add records by inserting rows, and delete records or fields.

  • What are Records and Fields
  • Adding Fields by Inserting Columns
  • Adding Records by Inserting Rows
  • Deleting Records rr Fields
Using Excel as a Database

Databases are an assemblage of data, which can be manipulated in many ways. This module takes a look at how to: filter data with wildcard characters; validate data with lists or formulas, and how to use database functions.

  • Filter with Wildcard Characters
  • Validating Your Data
  • Data Validation Using Lists
  • Data Validation Using Formulas
  • Using Database Functions
Using Custom AutoFill Lists

An AutoFill list is a series or sequence of numbers or text strings that can be filled into cells automatically when you drag your mouse pointer down a column or across a row. This module will show users how to: create and use a custom AutoFill list, and how to modify and delete a custom AutoFill list.

  • Creating a Custom AutoFill List
  • Using a Custom AutoFill List
  • Modifying and Deleting a Custom AutoFill List
Using Comments

Comments allow users to engage with the material and each other through adding messages to Excel files. This module shows participants how to: insert, edit, navigate, and delete comments.

  • Inserting Comments
  • Editing Comments
  • Navigating Through Comments
  • Deleting Comments
Tracking Changes

When changes are made to a file, it’s very handy to know what has been changed, when and by whom. This module touches upon how to: track and review changes, set options for tracking changes, and stop tracking changes.

  • Tracking Changes
  • Review Changes
  • Set Options For Tracking Changes
  • Stop Tracking Changes
Linking, Consolidating, and Combining Data

When working with multiple files with interrelated data it’s handy to make the most of linking. Here we cover how to: link and consolidate workbooks, consolidate worksheets, and pivot consolidated data.

  • Linking Workbooks
  • Consolidating Workbooks
  • Consolidating Worksheets
  • Pivoting Consolidated Data

Download Full Course Details as a PDF

Share this printable PDF with others in the office.

Download Now