Course Name

Microsoft Excel 2016: Data Analysis – Level 2

  • Duration: 2 Day(s)
  • Date: 19 Nov, 2024
  • Price: R3, 170.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016 Essentials course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence.

The ability to analyse data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that can compete at a high level.

Course Objectives

To create and develop Excel worksheets and workbooks to work with and analyse the data that is critical to the success of your organization.

You will:

  • Work with lists.
  • Apply conditional formatting.
  • Use charts and sparklines.
  • Create Pivot Tables and Pivot Charts.
  • Forecast data.
  • Import and export data

Course Content

  • Module 1: Working with Lists
    • Topic A: Sort Data
    • Topic B: Filter Data
    • Topic C: Query Data with Database Functions
    • Topic D: Outline and Subtotal Data
  • Module 2: Automating Workbook Functionality
    • Topic A: Apply Data Validation
    • Topic B: Search for Invalid Data and Formulas with Errors
  • Module 3: Formatting a Worksheet
    • Topic A: Apply Basic Conditional Formatting
  • Module 4: Analysing Data
    • Topic A: Create and Modify Tables
    • Topic B: Apply Intermediate Conditional Formatting
    • Topic C: Apply Advanced Conditional Formatting
  • Module 5: Visualizing Data with Charts
    • Topic A: Create Charts
    • Topic B: Modify and Format Charts
    • Topic C: Use Advanced Chart Features
  • Module 6: Creating Sparklines and Mapping Data
    • Topic A: Create Sparklines
    • Topic B: Map Data
  • Module 7: Using PivotTables and PivotCharts
    • Topic A: Create a PivotTable
    • Topic B: Analyse PivotTable Data
    • Topic C: Present Data with PivotCharts
    • Topic D: Filter Data by Using Timelines and Slicers
  • Module 8: Forecasting Data
    • Topic A: Determine Potential Outcomes Using Scenarios
    • Topic B: Forecast Data Trends
  • Module 9: Importing and Exporting Data
    • Topic A: Import and Export Data

Course Associated Exam and Certification

  • Appendix A: Microsoft Office Excel 2016 Exam 77-727
  • Appendix B: Microsoft Office Excel 2016 Expert Exam 77–728
  • Appendix C: Microsoft Excel 2016 Common Keyboard Shortcuts
  • Appendix D: Working with Power Pivot
  • Appendix E: Advanced Customization Options
  • Appendix F: Working with Forms and Controls
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

This course builds upon the foundational knowledge presented in the Microsoft Office Excel 2016 Essentials course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organisational intelligence.

The ability to analyse data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that can compete at a high level.

Course Objectives

To create and develop Excel worksheets and workbooks to work with and analyse the data that is critical to the success of your organization.

You will:

  • Work with lists.
  • Apply conditional formatting.
  • Use charts and sparklines.
  • Create Pivot Tables and Pivot Charts.
  • Forecast data.
  • Import and export data

Course Content

  • Module 1: Working with Lists
    • Topic A: Sort Data
    • Topic B: Filter Data
    • Topic C: Query Data with Database Functions
    • Topic D: Outline and Subtotal Data
  • Module 2: Automating Workbook Functionality
    • Topic A: Apply Data Validation
    • Topic B: Search for Invalid Data and Formulas with Errors
  • Module 3: Formatting a Worksheet
    • Topic A: Apply Basic Conditional Formatting
  • Module 4: Analysing Data
    • Topic A: Create and Modify Tables
    • Topic B: Apply Intermediate Conditional Formatting
    • Topic C: Apply Advanced Conditional Formatting
  • Module 5: Visualizing Data with Charts
    • Topic A: Create Charts
    • Topic B: Modify and Format Charts
    • Topic C: Use Advanced Chart Features
  • Module 6: Creating Sparklines and Mapping Data
    • Topic A: Create Sparklines
    • Topic B: Map Data
  • Module 7: Using PivotTables and PivotCharts
    • Topic A: Create a PivotTable
    • Topic B: Analyse PivotTable Data
    • Topic C: Present Data with PivotCharts
    • Topic D: Filter Data by Using Timelines and Slicers
  • Module 8: Forecasting Data
    • Topic A: Determine Potential Outcomes Using Scenarios
    • Topic B: Forecast Data Trends
  • Module 9: Importing and Exporting Data
    • Topic A: Import and Export Data

Course Exam And Certification

  • Appendix A: Microsoft Office Excel 2016 Exam 77-727
  • Appendix B: Microsoft Office Excel 2016 Expert Exam 77–728
  • Appendix C: Microsoft Excel 2016 Common Keyboard Shortcuts
  • Appendix D: Working with Power Pivot
  • Appendix E: Advanced Customization Options
  • Appendix F: Working with Forms and Controls

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US