Excel for Data Analysis. Learn the Art of Excel Analytics.
3.9 (14 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.
1,873 students enrolled

Excel for Data Analysis. Learn the Art of Excel Analytics.

Learn the art of data science using Excel. Do the data analytics and Visualizations. Taught by Data Scientist/PM.
New
3.9 (14 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.
1,873 students enrolled
Last updated 7/2020
English
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 4.5 hours on-demand video
  • 2 articles
  • 7 downloadable resources
  • 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
  • Art of Data Analysis on the Real world data sets
  • Data manipulation techniques and reporting to business users
  • Ways and techniques to find the business insights from the raw data
  • Data Visualisazations , Pivot , Vlookup etc
  • Complex formulae , sorting and filtering with short cut keys
  • Acquisition Analytics to find out which customer segment is the profitable
  • Report making techniques for business users.
  • Investment Case Study to identify the top3 countries and investment type to help the Asset Management Company to understand the global trends
Requirements
  • Students must be passionate about data
Description

1. Learn basic and advanced functionalities of Excel.

2. Learn how to do data manipulation and analysis to solve real world business problems using case studies.

3. Start using pivot tables and Vlookup like a pro.

4. Start using built-in formulae in excel for the data analysis.

5. Learn how to find interesting trends in the real world datasets.


Real World Case Studies include :

Acquisition Analytics on the Telemarketing datasets : Find out which customers are most likely to buy future bank products using tele channel.

Investment Case Studies: To identify the top3 countries and investment type to help the Asset Management Company to understand the global trends

Data Analysis on Ireland Loan Datasets : Find out which customers are good or bad and who are likely to repay the loan.


Who this course is for:
  • Beginners who are looking to enhance their data science skills
  • Those who want to switch the career in data science
Course content
Expand all 60 lectures 04:26:59
+ Introduction
5 lectures 31:19
Understanding Excel Interface - 1
04:20
Understanding Excel Interface - 2
04:39

Formulae start with an equal sign '='. Recall that:

Cells are named as a combination of the respective rows and columns i.e. the cell at the intersection of Column A and Row 2 is named as A2.

Formulae can use cell references. Copy and Pasting formulae adjust the input cells references appropriately.

Double Click on the Autofill square at the bottom right of a cell to fill an entire range. Excel is smart enough to change the input references for each cell.


Basic Excel formatting : IMDB Movies - 2
10:06
+ Advance Excel
2 lectures 14:39
Sorting and Filtering
08:13
Excel Pivot
06:26
+ Report Making with Loan Data Sets
7 lectures 39:42



Data Understanding, Sorting & Filtering
13:19
Key Items in Report Making
01:46
Report Making :Conditional Formatting
07:11
Report Making : Borders
05:45
Report Making : Printing Techniques
04:49
Report Making : Protecting Files
03:58

Keyboard Shortcut (Windows) Meaning

Ctrl + C   : Copy

Ctrl + V   :  Paste

Ctrl + X    : Cut

Ctrl + Alt + V   :  Open Paste Special Dialog Box

Ctrl + Z   :  Undo last activity

Ctrl + Y    : Redo Last Activity

Ctrl + ↑   :  Go to the top of a column

Ctrl + ↓   :  Go to the bottom of a column

Ctrl + →    : Go the right(end) of a row

Ctrl + ←    : Go to the left (beginning) of a row

Shift + Arrow Keys (← ↑ → ↓)   :  Select cells in the direction of movement

Shift + Ctrl + Arrow Keys  (← ↑ → ↓) : Select all cells in the direction of the arrow keys

                                    E.g.: Shift + Ctrl + ↓  :   Select all cells from current cell to the bottom of the column

Ctrl + S   :  Save

Ctrl + P    : Print

Ctrl + Shift + L    : Filter

Discover shortcuts by using Alt keys

○ E.g.: Alt + P + V - Show Print Preview

○ E.g.: Alt + H + S + F - Filter


Preview 02:54
+ Case Study -Acquisition Analytics
10 lectures 45:17

Telemarketing Case Study:

The datasets contains information of abount 45000 customers and their historical reponse to products offered by bank.The objective is the find those segments who are likely to purchase bank products in future.

This is the most common analytics across the industries . The usual purpose is the increase the sales of the products and reduce the cost of marketing . Instead of calling everyone and trying to sales , the tele-marketing channels will call only few customers and make as much sale.

Preview 02:00
Data Understanding of Telemarketing Datasets
02:20
Data Understanding of Telemarketing Datasets - 2
03:36
Segmentation Techniques and Excel Formulae
08:27
Response Rate Calculation and Replace Techniques
05:15
Univariate Analysis -1
05:34
Univariate Analysis -2
05:00
Multivariate Analysis - 1
03:51
Multivariate Analysis - 2
05:13
Logical Operators
04:01
+ Data Visualisations
7 lectures 25:53
Bar Plot - 1
06:26
Bar Plot - 2
05:15
Bar Plot - 3
02:55
Different types of Plots
03:50
How and Where to use Plots
03:02
Real Life Project Example
02:29
+ Data Analytics with Pivot Tables
5 lectures 18:35
Pivot Tables-1
03:15
Pivot Tables-2
05:26
Pivot Tables-3
02:06
Filter in Pivot
06:41
+ Data Analytics with Vlookup
4 lectures 11:43
Vlookup from within the Sheets - 1
04:22
Vlookup from within the Sheets - 2
01:21
Vlookup from Different Excel
03:37
+ Common Errors in Excel and Ways to Mitigate
2 lectures 11:15
Common Errors - 1
04:04
Common Errors -2
07:11
+ Investment Case Study for an Asset Management Firm
11 lectures 55:19
Understanding Case Studies and Downloads
01:00
Assignment Solutions:Data Preparation-1
06:49
Data Preparation - 2
07:07
Data Preparation - 3
01:41
Data Preparation - 4
06:40
Data Preparation - 5
05:09
Country Wise Analysis
06:03
Investment Type Analysis
07:56
Company Category Type Analysis
06:02
PPT Presentation to Business Users for Data Insights
04:25