Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

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

Name: Excel for Data Analysis. Learn the Art of Excel Analytics.
Rating: 3.8 (50 reviews)

Learn the art of data science using Excel. Do the data analytics and Visualizations. Best Data Literacy Course in Excel.

Created byPiyush S | insightEdge100.com

Last updated 10/2024

English

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

Course content

10 sections • 60 lectures • 4h 26m total length

Course Outline1:40
Understanding Excel Interface - 14:20
Understanding Excel Interface - 24:39
Basic Excel formatting : IMDB Movies -110:34
Basic Excel formatting : IMDB Movies - 210:06
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.

Data Understanding, Sorting & Filtering13:19
Key Items in Report Making1:46
Report Making :Conditional Formatting7:11
Report Making : Borders5:45
Report Making : Printing Techniques4:49
Report Making : Protecting Files3:58
Shortcut Keys Tricks for Excel Data Analysis2:54
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

Introduction to Acquisition Analytics2:00
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.
Data Understanding of Telemarketing Datasets2:20
Data Understanding of Telemarketing Datasets - 23:36
Segmentation Techniques and Excel Formulae8:27
Response Rate Calculation and Replace Techniques5:15
Univariate Analysis -15:34
Univariate Analysis -25:00
Multivariate Analysis - 13:51
Multivariate Analysis - 25:13
Logical Operators4:01

Requirements

Students must be passionate about data

Description

**** Testimonials ****

This is a great course for those who want to start data science --Sangwe Bertrand Ngwa

Basics are well explained laying the foundation for excel analytics . Looking forward to it--Himanshu Negi

**** Lifetime access to course materials . 100% money back guarantee. Best course for data literacy for absolute beginners ****

1. Learn basic and advanced functionalities in 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.

6. Increase data literacy.

7. Learn to make various charts for effective data visualizations.

8. Learn how to infer hidden insights from data using plots.

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

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

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 31min

Advance Excel2 lectures • 15min

Report Making with Loan Data Sets7 lectures • 40min

Case Study -Acquisition Analytics10 lectures • 45min

Data Visualisations7 lectures • 26min

Data Analytics with Pivot Tables5 lectures • 19min

Data Analytics with Vlookup4 lectures • 12min

Common Errors in Excel and Ways to Mitigate2 lectures • 11min

Investment Case Study for an Asset Management Firm11 lectures • 55min

Understanding Basics of SQL , R , Python7 lectures • 13min

Requirements

Description

Who this course is for: