Excel Data Analysis For Dummies (Udemy.com)

Harness the Power of Excel to Discover What Your Numbers are Hiding

Created by: John Wiley & Sons

Produced in 2014

icon
What you will learn

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

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 90 / 100

icon
Course 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

icon
Instructor Details

John Wiley & Sons

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.

icon
More courses by John Wiley & Sons

Windows 8 For Dummies Video Training

$11.99

icon
More data analysis courses

Microsoft Power BI - Up & Running With Power BI Desktop

$11.99

Python Data Analysis & Visualization Bootcamp

$11.99

Complete Introduction to Microsoft Power BI [2021 Edition]

$11.99

Data Analysis with Pandas and Python

$11.99

Python for Time Series Data Analysis

$11.99

[Intermediate] Spatial Data Analysis with R, QGIS & More

$11.99

icon
Reviews

4.5

141 total reviews

5 star 4 star 3 star 2 star 1 star
% Complete
% Complete
% Complete
% Complete
% Complete

By Vikram A on 12/20/2020

Excellent explanations crisp and to the point

By Mariela Nonisa on 10/13/2020

It's good.

By Mukuka Mubanga on 9/20/2020

Perfect match

By Carolinamun on 9/3/2020

I liked the course and content. Something to improve is adding the Vlookup function. I think this is very important and its a basic feature to know in Excel.

By Kabo Moatshe on 8/9/2020

Insightful

By Kgotso Mashinini on 8/4/2020

I want to up-skill my self in reporting, since i use excel to send out my reports. The skills i have learned will help me improve.

By Dianna Marie B Villarta on 7/27/2020

This is good but hope that it could include some files that can be followed from your screen so I can do hand on it

By Varsha Shashidhar on 7/22/2020

I wish we had access to the data sheets that were shown at the beginning of each lesson so we could follow along. Also some lessons started with certain formula's already placed, I was very confused and had a hard time with those lessons.

By NG SHEI YONG DANIEL on 7/18/2020

still trying figuring out the new knowledge and new term

By Mekwunye Jessica on 7/7/2020

You did not state how you got the data analysis tool box box. Try to teach like you are teaching beginners or intermediates

By Vladislav Goryachikhin on 7/6/2020

very good

By ntombozuko Dyantyi on 7/5/2020

It was a good match for me