O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Excel 2016 Data Analysis

Video Description

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.

Table of Contents

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