Learn How To Excel in Excel

Using Conditional Formatting
This course 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 course 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 course how to enable Power View, create a Power View, add and remove fields, arrange fields, and 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 course 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 course shows students 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 course as they learn what tables are and how to create, resize, and clear tables, as well as how to choose a table style.

Working with Records and Fields
Records and fields are the building blocks of data. Covered in this course 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 course 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 course 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 course 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 course 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. This course covers how to link and consolidate workbooks, consolidate worksheets, and pivot consolidated data.

Course Fast Facts:

1. Easy to follow and understand
2. Only 6 to 8 hours of study is required
3. Unlimited, lifetime access to online course
4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
5. You can study from home or at work, at your own pace, in your own time
6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.