Microsoft Excel Level 3

Excel 2016: Large Data 1 – Sorting and Filtering (1.5 hr)

In this workshop, we will work with single and multilevel sorting; learn to use data filters to automatically show only the specified data set; and do math on our filtered data sets. This workshop also contains a very brief introduction to other summary tools such as Subtotal and Pivot Tables. This intermediate workshop assumes prior experience with Microsoft Excel.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)

 

Excel 2016: Large Data 2 – Pivot Tables (1.5 hr)

Pivot tables are very powerful summary reports created from an organized data set. In this workshop we will learn to plan and create pivot tables; work with grouping, filters, and summary options; create a pivot chart; and explore formatting options. This advanced workshop assumes prior experience with Microsoft Excel.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)

 

Excel 2016: Large Data 3 – vLookups (1.5 hr)

In this advanced math workshop, we will work with multipart functions such as IF( ) and VLOOKUP( ) statements.

An IF statement is a three-part function that allows you to change the result based on a logic statement, you can return one value if the answer is TRUE and another if the answer is FALSE.

A VLOOKUP( ) statement is a four-part function that allows you to search for a value in a large data set, and return a different value from that same row. For example, if you a large data set of Employee Numbers, Names, and Titles, you can have Excel search for the Employee Number through the VLOOKUP function and have it return the Employee’s Name and Title.

We will also use Data Validation to create drop-down lists that help with data entry. We’ll use the results of the list in our functions.
This advanced workshop assumes prior experience with Microsoft Excel; experience with building equations in Excel required.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)

 

Excel 2016: Large Data 4 – Final Report (2.0 hr)

In this advanced math workshop, we will create nested If statements and discover how logic functions can simplify our equations; use the Remove duplicates tool and vLookup function to create substitution lists to be used in our pivot tables; created summary pivot tables for text values; and move tables and charts to a summary page (dashboard). This advanced workshop assumes prior experience with Microsoft Excel; experience with building equations in Excel required.

Gainesville Schedule Jacksonville Schedule Handout
Class Files (ZIP)