Microsoft Excel – Intermediate

Duration: 2 days (8am to 4pm)
Training dates: TBA
Cost: $375.00 +HST
Cost includes course material, college certificate, breakfast and lunch vouchers
Location: Timmins Campus

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.

Contact Information
training@northern.on.ca