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+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching 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 Data Science
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

This course includes:

  • 12 hours on-demand video
  • 8 articles
  • 172 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Business Business Analytics & Intelligence Data Analysis

Data Analysis Essentials Using Excel

Learn to apply the important concepts and techniques of data analysis using Excel.
Rating: 4.5 out of 54.5 (6,253 ratings)
45,018 students
Created by Symon He, Travis Chow
Last updated 12/2020
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Confidently use the most crucial Excel functions and techniques for analysis
  • Correctly use the appropriate charts in Excel
  • Apply analysis techniques to datasets in Excel
  • Manipulate and prep datasets in Excel
  • Build presentation ready dashboards in Excel
  • Create your own formulas in Excel
  • Turn real world data into business insights in Excel
Curated for the Udemy for Business collection

Requirements

  • You should be able to use a PC or Mac at the beginner level
  • Microsoft Excel 2013+

Description

Ibadullah Khalil - 5 Stars

“A great instructor and guide for the course. All topics were well driven and to the point with no gibberish language used to make it difficult for the learners just like other instructors. A highly recommended course for every beginner who aims to become a data analyst”

 

Jianyong Chen - 5 Stars

“This is one of the best course I took on Udemy so far. The instructors explained everything in detail and there are practices after each section. Make sure you download all the files, practice on your own, and you will learn a lot. Highly recommend!”

 

 

Every business generates data.  But whether you're able to turn that into useful insights depends on your ability to process, manipulate, and ultimately translate that data.

Whether you're working for a company or running your own, being able to make better decisions requires you to be able to analyze and interpret data.  

What data do you need? How do you prep that data? How do you analyze it to answer specific questions?

In this course, we're going to show you step-by-step, exactly how to do that, by starting with the very basics.  

 

Why Microsoft Excel?

 

This course is as much about Excel, if not more, than data analysis concepts and techniques. Why?

 

Excel is still the most popular tool used by analysts in all industries, across all roles.  It's used by financial analysts, marketing analysts, sales analysts, and of course, data analysts.  

Yes, there are many tools out there but if you learn and master the core concepts and techniques of data analysis in Excel, you'll be able to apply your knowledge to a broad range of applications.

 

Don’t underestimate Excel--a single worksheet can technically hold more than 17 BILLION data points (granted, it will make your computer REALLY slow). Fortunately, most of us running analysis will need to process far fewer data points than that. Still, it speaks to the power of the program.

 

Maurizio Zippo - 5 Stars

“This is one of the best course I have ever taken and thoroughly enjoyed. Highly recommended if you want to brush up your existing Excel Skills and to learn how to build some complicated formulae. The Pivot Table and Charts were something I always struggled with but thanks to Symon and Travis' explanations they are now so easy to use every day at work, saving me tonnes of time! Many Thanks Symon and Travis for putting together this great course you are my Excel heroes! The case studies on Cryptocurrency and The Start Up Market are absolute gems! I can't wait to get started with your next course.”

 

Why learn from us?

 

By signing up with us, you will be learning from two instructors with a combined 35 years of relevant experience across a wide range of analyst roles.  

 

Travis has been a digital marketer, investor, and entrepreneur for 20 years. He’s led growth in Asia for Groupon and even helped build Excel when he was as an engineer at Microsoft.  He is a data analysis and data visualization expert who pulls from his industry experience to teach some of the advanced data analysis topics you’ll find in this course. 

 

Symon has been interpreting and analyzing data for 15 years.  He has served as a financial analyst, marketing analyst, and even head of marketing analytics across half a dozen industries.  If you look at his other courses on Udemy, you'll see that he is an Excel and analysis ninja, having taught nearly 180,000 students with over 18,000 reviews.  

 

Together, we’ve pulled directly from our personal experience and put everything we could into this course. In fact, all of the case studies you’ll find inside are inspired by real-world projects we’ve worked on.

 

What if I don't have any data analysis or Excel background?

 

No worries! This is why we start with the very basics in our foundational sections, which is designed to get you familiar with Excel before we move on to more advanced topics.  You can be a complete beginner and take this course.  It might sometimes feel like you're drinking out of a fire hose, but if you put in the time and effort we promise you’ll see results by following our course and doing the exercises. 

 

We then progressively increase the difficulty as you move along in the course, culminating in advanced techniques taught through our case studies.  

If you do have an Excel background, you can skip or skim through the foundational sections and move directly into the more advanced topics.  

 

Stephen Dias - 5 Stars

“If you're trying to learn the foundations of excel this course is all you need.”

 

Brandon Parker - 5 Stars

“I have a lot of experience building excel models and purchased the course for the case studies. I didn't expect to learn much from the introductory parts but was surprised to find additional keyboard shortcuts I had never learned as well as powerful new functions that will make my life a lot easier. This course helped me brush up on functionality that I often neglected while using excel and was super comprehensive. I look forward to continuing using this course as additional case studies are added and highly recommend it for even excel experts.”

 

Learn through practice.

Like most things in life, becoming proficient at data analysis in Excel takes practice.  A lot of practice.

 

Sure, you'll pick up plenty just from watching, but you'll be doing yourself a disservice if you don't download our more than 100 custom-built Excel practice files specifically designed to help you master the program.

 

We're not done adding all our content yet, either.  This class was initially created an "intro" course, but it will soon become a complete coverage of all things data analysis in Excel.  

 

In conclusion, does any of the following apply to you?

 

    1.     Do you want to really know your way around Excel?

    2.     You have data for your work or business but you're not sure what to make of it?

    3.     You might know your way around Excel but you're not confident about turning data into business insights

    4.     You frequently receive Excel spreadsheets from others but want to better understand how they arrived at their conclusions?

    5.     You want to learn the best practices when it comes to using Excel for data analysis.

    6.     You are intimidated by spreadsheets and terms like Pivot Tables and VLookups

    7.     You want to learn a skill set that is useful for any role in any industry you get into later.

 


If so, then take charge and take our course.

You have absolutely ZERO risk. Udemy gives you a solid-as-an-oak-tree 30-day money back guarantee.  You have nothing to lose and everything to gain.


So if you're ready to go from data deficient to data proficient, enroll now!

 

 

Who this course is for:

  • Anyone who wants to learn the core concepts of data analysis in the Excel environment
  • Anyone who wants to learn to apply data analysis techniques using Excel
  • Anyone who wants to become proficient at using Excel for data/business analysis
  • Anyone who wants to be able to turn data into business insights in Excel
  • Anyone who wants to be able to run simple to sophisticated analysis on data using Excel
  • Anyone who wants to learn the most frequently used Excel functions and techniques used by analysts

Featured review

Marianna Milkis
Marianna Milkis
12 courses
1 review
Rating: 5.0 out of 510 months ago
This course has been super helpful, well-paced, and easy to follow. I know it will be coming back to it as I encounter more cases. Even after the first pass, it has expanded my understanding and knowledge of Excel. I feel much better prepared to handle data in Excel now.

Course content

15 sections • 130 lectures • 11h 58m total length

  • Preview01:14
  • A few reminders before we begin
    01:05
  • COURSE FILES
    00:11

  • Preview04:55
  • JUMPSTART NOTE
    00:40
  • Preview08:49
  • Jumpstart Part 2
    06:22
  • Jumpstart Part 2 Filtering Unique Values
    03:11
  • Jumpstart Part 3
    06:48
  • Quick Reminder
    00:26

  • Getting Acclimated Section Overview
    00:27
  • Preview05:21
  • Adding, Deleting, and Editing Data in a Cell
    03:01
  • Introduction to Keyboard Shortcuts
    01:51
  • 50 Time Saving Excel Shortcuts
    00:09
  • Navigation Keyboard Shortcuts
    02:34
  • Data Selection Keyboard Shortcuts
    02:20
  • Inserting and Deleting Rows and Columns
    04:21
  • Auto Fit Row and Column Size
    01:31
  • Freeze Panes and Split Boxes
    04:32
  • Formatting Numbers
    07:24
  • Formatting Cells
    04:03
  • Grouping and Hiding Rows or Columns
    01:57
  • Installing EXCEL Add-Ins
    00:49
  • Quiz #1
    6 questions

  • Basic Excel Formulas & Functions Section Overview
    00:32
  • Basic Math Functions in Excel
    04:48
  • Conditional Math Functions
    06:13
  • MIN, MAX, and AVERAGE Functions
    05:51
  • Logical Operators and Functions
    08:55
  • Preview09:14
  • Array Functions
    05:03
  • Quick note about next three lectures
    00:16
  • Preview09:17
  • Net Present Value (NPV) and Cash Multiple
    13:09
  • Loan Amortization Table
    03:28
  • Compound Annual Growth Rate (CAGR)
    03:26
  • Formula Auditing
    04:47
  • Fill Commands
    04:10
  • IS Functions
    04:17
  • Rounding Numbers
    06:35
  • Quiz #2
    1 question

  • Text, Times, and Date Data Formats Section Overview
    00:26
  • Note to EU Students about Date Format
    00:20
  • How EXCEL Treats Text, Times, and Dates Data
    04:52
  • Changing the Case of Text
    02:32
  • Combining Strings of Text Together
    02:23
  • Cutting Substrings from a Text
    05:10
  • Using the FIND Function
    05:29
  • Searching for Specific Text in Data
    05:37
  • Splitting a Text Field into Multiple Columns
    03:51
  • Converting Dates from Text into Values
    03:05
  • Adding and Subtracting Dates
    05:14
  • Compiling Monthly and Annual Totals
    04:43
  • Conducting Day of the Week Analysis
    04:06
  • Combining Date and Time Data
    03:40
  • Adding and Subtracting Times
    05:39
  • Conducting Hours of the Day Analysis
    05:17

  • Introduction Statistics in EXCEL Section Overview
    00:22
  • Brief Overview of Statistics
    03:35
  • Mean, Median, & Mode
    08:39
  • Percentile and PercentileRank
    06:03
  • Frequency Distributions
    06:40
  • Standard Deviation and Variance
    06:11
  • Trends in Data
    07:18
  • Introduction to Correlation
    06:23

  • Handling Data Overview
    00:37
  • Lookup with VLOOKUP
    04:16
  • Lookup with HLOOKUP
    02:26
  • Name Arrays for Reuse and Readability
    03:22
  • Group Records with Nested IF Statements
    04:20
  • Avoid Errors with IF and ISNUMBER
    05:39
  • Create Dropdown Lists for Filtering
    09:27
  • Create Unique Lists
    04:49
  • Fast Lookup with INDEX and MATCH
    10:00
  • Multi-Condition Lookup with DSUM
    06:23
  • Create Rankings with SMALL and LARGE
    05:26
  • Multi-Condition Lookup with INDEX and MATCH
    05:50

  • Insert a Pivot Table
    06:38
  • Prepare Data for Pivoting
    09:10
  • Learn to Pivot a Table
    09:35
  • Group Rows and Columns
    05:24
  • Format for Readability
    05:28
  • Modify Output Values for Insights
    08:25
  • Insert Calculated Fields
    08:16
  • Sort, Filter and Slicer
    08:54
  • Handle New Data in Pivot Tables
    08:21

  • Intoduction to Charts in Excel Overview
    00:30
  • Why Use Charts Anyway?
    10:11
  • Line Chart
    04:52
  • Pie Charts
    05:35
  • Bar Chart
    03:54
  • Column Chart - Clustered
    06:26
  • Column Chart - Stacked
    05:36
  • Column Chart - 100% Stacked
    05:40
  • Combination Chart
    02:24
  • Scatter Plot
    03:12
  • Area Chart
    04:21
  • Bubble Chart
    05:19
  • Gantt Chart
    04:15
  • Preview09:16
  • Waterfall Chart
    15:19

  • Cryptocurrency Case Study Overview
    03:06
  • Getting and Prepping the Data
    12:53
  • CORRECTION
    00:18
  • Bitcoin vs S&P500
    Preview13:32
  • Ethereum, Litecoin, & Bitcoin
    08:38
  • Introduction to Moving Averages
    11:04

Instructors

Symon He
Author | Investor | Entrepreneur | Stanford MBA
Symon He
  • 4.4 Instructor Rating
  • 24,118 Reviews
  • 223,927 Students
  • 11 Courses

Symon He is the co-author of Airbnb for Dummies and the Real Estate Investing QuickStart Guide, both available now on Amazon and in bookstores throughout North America.

He is also co-founder of LearnBNB, a leading online educational destination for all things Airbnb hosting and short-term rentals. His works have been cited or featured on the Wall Street Journal, Reuters, Forbes, CNBC, Entrepreneur, and SKIFT. Through his training and coaching programs, he has worked directly with thousands of aspiring Airbnb hosts to jumpstart their short term rental journeys. His training programs have been featured by prominent third-party partners, including a joint venture with RichDad.

As a licensed broker, Symon previously helped private real estate investors with their acquisitions and deal structuring. As an angel investor, he also advises and invests in early stage startups.

Previously, Symon worked in several corporate real estate and finance roles at large private and Fortune 80 companies, including at a private equity investment firm covering a wide range of commercial real estate acquisitions in the western USA.

Symon received dual degrees in Computer Engineering and Economics with Honors from UC Irvine and an MBA from Stanford University.

Travis Chow
Tech Veteran Mentoring & Teaching for 20+ Years
Travis Chow
  • 4.5 Instructor Rating
  • 6,319 Reviews
  • 75,271 Students
  • 2 Courses

I have spent over 20 years teaching technology to managers both formally and informally. I love teaching or mentoring people in getting up to speed with digital transformation.

I specialize in teaching "difficult tech stuff" to "business people." Topics include analytics, data programming, product mgmt, agile project mgmt, business intelligence, Excel and other crucial analytics software.

My Background

Most recently, I have been a product management executive and digital transformation consultant to other executives. My first job was building and designing Excel formulas and VBA at Microsoft. I am a seasoned tech veteran who have since held management and executive positions in Silicon Valley, Austin and other international tech hubs. 

I co-founded my first company at age 22 and have since participated in six successful exits as tech entrepreneur, investor and employee. The previous company I sold was for data analytics. I hold a masters degree in Computer Science and studied Financial Mathematics as well as a MBA.

  • 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.