Excel for Data Analysis

Course Overview

This course will introduce students to Microsoft Excel 2016 data analysis, including functions and formulas, lookups and data tables, PivotTables, and analytical tools.

Courses Outline

  • Chapter 1 – Functions and Formulas
  • Chapter 2 – Lookups and Data Tables
  • Chapter 3 – PivotTables
  • Chapter 4 – Analytical Tools

Chapter 01 – Getting Started with Microsoft Office Excel 2016

Chapter 02 – Performing Calculations

Chapter 03 – Modifying a Worksheet

Chapter 04 – Formatting a Worksheet

Chapter 05 – Printing Workbooks

Chapter 06 – Managing Workbooks

Chapter 01 – Working with Functions

Chapter 02 – Working with Lists

Chapter 03 – Analyzing Data

Chapter 04 – Visualizing Data with Charts

Chapter 05 – Using PivotTables and PivotCharts

Chapter 06 – Working with Graphical Objects

Chapter 07 – Using Array Formulas

Chapter 01 – Working with Multiple Worksheets and Workbooks

Chapter 02 – Using Lookup Functions and Formula Auditing

Chapter 03 – Sharing and Protecting Workbooks

Chapter 04 – Automating Workbook Functionality

Chapter 05 – Creating Sparklines and Mapping Data

Chapter 06 – Forecasting Data

  • Chapter 1 – Functions and Formulas
  • Chapter 2 – Lookups and Data Tables
  • Chapter 3 – PivotTables
  • Chapter 4 – Analytical Tools

₦ 15,000

  • Learn at your own pace with 24/7 access
  • Duration: 1 year
× How can we help you?