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

Excel Data Analysis For Dummies

​Harness the Power of Excel to Discover What Your Numbers are Hiding
Rating: 4.4 out of 54.4 (760 ratings)
4,843 students
Created by John Wiley & Sons
Last updated 6/2014
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Working with external databases
  • Using PivotTables and PivotCharts
  • Using Excel for statistical and financial functions
  • Learn Solver, Small Business Finance Manager, and more
Curated for the Udemy for Business collection

Requirements

  • All Internet browsers, including Internet Explorer, Safari, Chrome, and Firefox

Description

Harness the power of Excel to discover what your numbers are hiding

Excel Data Analysis For Dummies video training is the ultimate course to help you get the most out of your data. The course, comprised of video training and an eBook, guides you through the basic and not-so-basic features of Excel to help you discover the gems hidden in your rough data. From input, to analysis, to visualization, the course walks you through the steps that lead to superior data analysis.

Excel is the number-one spreadsheet application, with ever-expanding capabilities. If you're only using it to balance the books, you're missing out on a host of functions that can benefit your business or personal finances by uncovering trends and other important information hidden within the numbers. Excel Data Analysis For Dummies eliminates the need for advanced statistics or analysis courses by allowing you to harness the full power of Excel to do the heavy lifting for you. This video course and eBook are fully updated to include information about Excel's latest features, making this your go-to Excel course for data analysis. Topics include:

  • Working with external databases
  • PivotTables and PivotCharts
  • Using Excel for statistical and financial functions
  • Solver, Small Business Finance Manager, and more

The eBook also includes a guide to chart types and formatting, and advice on effective visual data presentation. You already have the data, so you might as well get something great out of it. Excel Data Analysis For Dummies is the key to discovering what your numbers are hiding.

Visit our websites For Dummies and Wiley

Who this course is for:

  • Intermediate to Advanced Excel users

Course content

8 sections • 28 lectures • 8h 3m total length

  • Preview04:59
  • Preview03:35
  • Preview02:54
  • Using Microsoft Query
    06:25
  • Running Web Queries
    02:28

  • Text Cleaning Functions
    03:20
  • Functions that manipulate Text Strings
    04:04
  • Using Data Validation
    04:48

  • Understanding Pivot Tables
    07:02
  • Adding Calculations in Pivot Tables
    04:20
  • Creating Pivot Charts
    02:02
  • Customizing Your Pivot Charts
    02:46

  • Using DMAX and DIMN
    03:28
  • Using DGET to Find Specific Values
    03:15
  • Using DSUM to Add Values Based on Selection Criteria
    03:20
  • Counting Values
    05:02

  • Percentiles and Quartile
    04:14
  • Understanding Standard Deviation
    03:24
  • Calculating Rank and Percent Rank
    04:07
  • Functions That Create Descriptive Statistics
    05:06
  • Creating a Histogram
    04:53
  • Calculating Moving Averages
    03:36

  • Using a Scatter Plot to Show Relationships
    03:53
  • Understanding Linear Regression
    08:13
  • Using Solver to Model Data
    08:22

  • Ten Jobs For Excel Gurus
    11 pages

  • eBook Excel Data Analysis For Dummies, 2nd edition PART 1
    165 pages
  • eBook Excel Data Analysis For Dummies, 2nd edition PART 2
    198 pages

Instructor

John Wiley & Sons
Video Training
John Wiley & Sons
  • 4.3 Instructor Rating
  • 3,669 Reviews
  • 43,738 Students
  • 31 Courses

     Founded in 1807,  Wiley, In has long been a valued source of information and understanding for more than 200 years, helping people around the world meet their needs and fulfill their aspirations. Wiley and its acquired companies have published the works of more than 450 Nobel laureates in all categories: Literature, Economics, Physiology or Medicine, Physics, Chemistry, and Peace. 

     Wiley is a global provider of content and content-enabled workflow solutions in areas of scientific, technical, medical, and scholarly research; professional development; and education. Our core businesses produce scientific, technical, medical, and scholarly journals, reference works, books, database services, and advertising; professional books, subscription products, certification and training services and online applications; and education content and services including integrated online teaching and learning resources for undergraduate and graduate students and lifelong learners. Wiley's global headquarters are located in Hoboken, New Jersey, with operations in the U.S., Europe, Asia, Canada, and Australia. The Company is listed on the New York Stock Exchange under the symbols JWa and JWb. 

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