Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Life Purpose Personal Transformation Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Office Productivity Microsoft Data Science

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.
Rating: 3.6 out of 53.6 (25 ratings)
2,147 students
Created by Piyush S | insightEdge100.com
Last updated 2/2021
English
30-Day Money-Back Guarantee

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

**** 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 ****

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

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

  • Preview01:40
  • Understanding Excel Interface - 1
    04:20
  • Understanding Excel Interface - 2
    04:39
  • Preview10:34
  • Basic Excel formatting : IMDB Movies - 2
    10:06

  • Sorting and Filtering
    08:13
  • Excel Pivot
    06:26

  • 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
  • Preview02:54

  • Preview02: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

  • Preview01:56
  • 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

  • Preview01:07
  • Pivot Tables-1
    03:15
  • Pivot Tables-2
    05:26
  • Pivot Tables-3
    02:06
  • Filter in Pivot
    06:41

  • Preview02:23
  • Vlookup from within the Sheets - 1
    04:22
  • Vlookup from within the Sheets - 2
    01:21
  • Vlookup from Different Excel
    03:37

  • Common Errors - 1
    04:04
  • Common Errors -2
    07:11

  • Preview02:27
  • 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

  • Preview01:06
  • Database Concept
    01:15
  • SQL Concept
    02:35
  • Write your 1st SQL
    01:15
  • Preview02:08
  • Preview02:04
  • Introduction to Linear Regression
    02:53

Instructor

Piyush S | insightEdge100.com
Data Scientist | Data Engineer | Project Manager
Piyush S | insightEdge100.com
  • 4.1 Instructor Rating
  • 149 Reviews
  • 9,243 Students
  • 6 Courses

"PG in Data Science ( IIIT Bangalore) , PMP  ( Project Management Institute,USA), CAPM , B.Tech ( Electronics)"

I have over 12+ years of industry experience in Python , R and SQL .

Have worked across various international finance companies including Insurance & Banking. I been instrumental in implementing the various software products .

I am passionate about data and the insights which it gives. I am looking forward to share my experiences with you .  I will guide you step by step so that you can make a leap in your career . The Data Engineers and Data Science experts have the highest demand in the world.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.