10994 Data Analysis Fundamentals using Excel

sql_server_logo

10994 Data Analysis Fundamentals using Excel

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
Share on facebook
Share on twitter
Share on linkedin

Overview

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.

Prerequisites

Those who wish to take up this course should meet the following prerequisites:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Advanced working knowledge of Excel spreadsheets including formulas.

Who Should Attend?

This course is recommended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.

Course Outline

  • Filtering and Formatting Data
  • Charts
Lab: Create an Excel report
  • Excel Data Tables
  • Summarizing Data
Lab: Create an Excel Table
  • Pivot Tables
  • Pivot Charts
  • Editing Pivot Tables and Pivot Charts
Lab: Importing Data from a CSV File
  • Creating a Dashboard
  • Data Analysis in Excel Pivot Tables
Lab: Create a Dashboard
  • Hierarchies
  • Time Data
Lab: Creating Hierarchies
  1. Using an Excel Data Model
  2. External Data
Lab: Explore an Excel Data Model

Get Brochure and Pricing

More Like This

Get the course Brochure & Pricing

Our course consultant will contact you within 1 working day

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Stay-Home-Series-main-header-v2

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

Get in touch with our consultant