Excel 2016: Part Two

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will: Work with Functions Work with Lists Analyze Data Visualize Data with Charts. Create advanced formulas. Analyze Data with PivotTables and PivotCharts.

Course Outline

1 - Working with Functions

▪ Work with Ranges

▪ Use Specialized Functions

▪ Work with Logical Functions

▪ Work with Date & Time Functions

▪ Work with Text Functions


2 - Working with Lists

▪ Sort Data

▪ Filter Data

▪ Query Data with Database Functions

▪ Outline and Subtotal Data


3 - Analyzing Data

▪ Create and Modify Tables

▪ Apply Intermediate Conditional Formatting

▪ Apply Advanced Conditional Formatting


4 - Visualizing Data with Charts

▪ Create Charts

▪ Modify and Format Charts

▪ Use Advanced Chart Features


5 - Analyzing Data with PivotTables and PivotCharts

▪ Create a PivotTable

▪ Analyze PivotTable Data

▪ Present Data with PivotCharts

▪ Filter Data by Using Timelines and Slicers

If you require interpreting services, please contact cpdcoop@rit.edu as soon as possible.

Facilitator Information: 

New Horizons