by Integrity Training | Publisher: Stone River eLearning | Release Date: February 2019 | ISBN: 300000006CA305

The Microsoft Excel 2016 Data Analysis course focuses on the features and functions that are available in Microsoft Office Excel 2016 which can be used to analyze and present a large amount of data in a more understandable way. The purpose of this course is to introduce the students to functions, formulas, lookups, data tables, PivotTables and other analytical tools of Microsoft Office Excel 2016.

1. Section 01 - Functions and Formulas
   • Topic A: Logical and Conditional Functions - Part 1 00:26:51
   • Logical and Conditional Functions - Part 2 00:00:19
   • Logical and Conditional Functions - Part 3 00:00:21
   • Topic B: Financial and Statistical Functions - Part 1 00:18:45
   • Financial and Statistical Functions - Part 2 00:00:18
   • Financial and Statistical Functions - Part 3 00:00:16
   • Topic C: Date/Time and Arrays - Part 1 00:12:21
   • Date/Time and Arrays - Part 2 00:00:24
   • Date/Time and Arrays - Part 3 00:00:21
2. Section 02 - Lookups and Data Tables
   • Topic A: Lookup Functions - Part 1 00:08:02
   • Lookup Functions - Part 2 00:00:24
   • Lookup Functions - Part 3 00:00:16
   • Topic B: Data Tables - Part 1 00:11:43
   • Data Tables - Part 2 00:00:18
   • Data Tables - Part 3 00:00:14
   • Topic C: Validating Cells - Part 1 00:14:33
   • Validating Cells - Part 2 00:00:24
   • Validating Cells - Part 3 00:00:14
   • Topic D: Filtering - Part 1 00:09:35
   • Filtering - Part 2 00:00:21
   • Filtering - Part 3 00:00:15
   • Topic E: Charting and Graphics - Part 1 00:16:49
   • Charting and Graphics - Part 2 00:00:22
   • Charting and Graphics - Part 3 00:00:21
3. Section 03 - PivotTables
   • Topic A: Working with PivotTables - Part 1 00:12:53
   • Working with PivotTables - Part 2 00:00:18
   • Working with PivotTables - Part 3 00:00:12
   • Topic B: Modifying PivotTable Data - Part 1 00:09:10
   • Modifying PivotTable Data - Part 2 00:00:21
   • Modifying PivotTable Data - Part 3 00:00:16
   • Topic C: Formatting PivotTables - Part 1 00:16:21
   • Formatting PivotTables - Part 2 00:00:23
   • Formatting PivotTables - Part 3 00:00:13
   • Topic D: Using PivotCharts - Part 1 00:03:44
   • Using PivotCharts - Part 2 00:00:22
   • Using PivotCharts - Part 3 00:00:14
   • Topic E: PowerPivot - Part 1 00:11:57
   • PowerPivot - Part 2 00:00:11
   • PowerPivot - Part 3 00:00:15
   • Topic F: Exporting and Importing Data - Part 1 00:07:49
   • Exporting and Importing Data - Part 2 00:00:24
   • Exporting and Importing Data - Part 3 00:00:15
4. Section 4:Chapter 04 - Analytical Tools
   • Topic A: Goal Seek - Part 1 00:06:44
   • Goal Seek - Part 2 00:00:23
   • Goal Seek - Part 3 00:00:16
   • Topic B: Scenarios - Part 1 00:17:06
   • Scenarios - Part 2 00:00:21
   • Scenarios - Part 3 00:00:20
   • Topic C: Solver - Part 1 00:11:48
   • Solver - Part 2 00:00:15
   • Solver - Part 3 00:00:17
   • Topic D: Instant Data Analysis - Part 1 00:11:06
   • Instant Data Analysis - Part 2 00:00:17
   • Instant Data Analysis - Part 3 00:00:14