Canada's Leader in Professional Development

855-581-7246 Call us: 1-855-581-7246

Microsoft Excel 2013 Expert

This instructor-led class is held at Training Centres of Canada
330 Bay Street, suite 610. All classes start at 9am.

Class Registration

This Microsoft Excel 2013 Expert 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 12 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.

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

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

Using Power View, Part One
Power View has many applications for upper-level users of Excel 2013. Students will learn in this module how to: enable Power View, create a Power View, add and remove fields, arrange fields, filter and sort 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 a visualization, change tile display, and set 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 students the tools for 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.

Working with Tables
Tables are efficient for dealing with ranges of data. Students will get the most from the module as they learn what tables are and how to: create, resize and clear tables, and how to choose a table style.

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.

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.

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.

Using Comments
Comments allow users to engage with the material and each other through making messages added to Excel files. This module gives students the knowledge how to: insert, edit, navigate, and delete comments.

Tracking Changes
When changes are made to a file it’s very handy to know what has been changed and when and by who. This module touches upon how to: track and review changes, set options for tracking changes, and 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 is covered how to: link and consolidate workbooks, consolidate worksheets, and pivot consolidated data.

 


Click here to reach us by Email Contact Us
About | Terms of Use | Privacy Visit our Facebook page   Visit ot Linkedin page   View our Tweets