10994 Data Analysis Fundamentals Using Excel
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3 students enrolled

10994 Data Analysis Fundamentals Using Excel

Analysis Fundamentals Using Excel
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
3 students enrolled
Created by Wasim Airod
Last updated 4/2019
English
English [Auto-generated]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create an Excel report
  • Create an Excel table
  • Create a pivot table and pivot chart
  • Create a dashboard and analyze data
  • Create Hierarchies
  • Create an Excel data model and connect to external data
Requirements
  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Excel spreadsheets
Description

•The audience for this course is anyone who has responsibility for creating reports using Excel


After completing this course, students will be able to:

•Create an Excel report

•Create an Excel table

•Create a pivot table and pivot chart

•Create a dashboard and analyze data

•Create Hierarchies

•Create an Excel data model and connect to external data


Course outline

Module 1 Reporting in Excel

Module 2 Excel Tables

Module 3 Pivot Tables and Pivot Charts

Module 4 Dashboards

Module 5 Hierarchies

Module 6 The Excel Data Model

Who this course is for:
  • The audience for this course is anyone who has responsibility for creating reports using Excel
Course content
Expand all 31 lectures 02:20:38
+ Reporting in Excel
6 lectures 26:12
Reporting in Excel Part-3
02:57
Reporting in Excel Part-4
04:46
Reporting in Excel Part-5
03:49
Reporting in Excel Part-6
02:43
+ Excel Tables
4 lectures 20:55
Excel Tables Part-1
04:18
Excel Tables Part-2
07:31
Excel Tables Part-3
02:48
Excel Tables Part-4
06:18
+ PivotTables and PivotCharts
6 lectures 30:14
PivotTables and PivotCharts Part-1
07:32
PivotTables and PivotCharts Part-2
04:55
PivotTables and PivotCharts Part-3
02:17
PivotTables and PivotCharts Part-4
07:21
PivotTables and PivotCharts Part-5
05:05
PivotTables and PivotCharts Part-6
03:04
+ Dashboards
6 lectures 21:24
Dashboards Part-1
05:04
Dashboards Part-2
02:11
Dashboards Part-3
03:26
Dashboards Part-4
04:31
Dashboards Part-5
04:02
Dashboards Part-6
02:10
+ Hierarchies
4 lectures 20:33
Hierarchies Part-1
03:24
Hierarchies Part-2
02:35
Hierarchies Part-3
04:33
Hierarchies Part-4
10:01
+ The Excel Data Model
5 lectures 21:20
The Excel Data Model Part-1
05:57
The Excel Data Model Part-2
02:16
The Excel Data Model Part-3
02:05
The Excel Data Model Part-4
07:38
The Excel Data Model Part-5
03:24