Each student, upon completion of the course, will receive a printable Certificate of Completion from RedWave Technology Group, LLC. This certificate will contain the date of completion, the course title, and the student name.
- 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 Microsoft 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.