Excel Data Analysis For Dummies

​Harness the Power of Excel to Discover What Your Numbers are Hiding
4.3 (38 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
1,637 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 28
  • Length 8 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 4/2014 English

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

What are the requirements?

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

What am I going to get from this course?

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

What is the target audience?

  • Intermediate to Advanced Excel users

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Arranging and Querting Data
04:59
Previously known as Lists, Excel Tables offer several advantages over simple data ranges. Here's a review of some of the handy things you can do with this powerful functionality.
03:35
Discover how to go beyond simple Autofilters with this look at a some advanced filtering techniques you can use to manage your data more effectively.
02:54
Whether you need to consolidate information from text files, Microsoft Access databases, or even other Excel workbooks, these simple tricks make importing data from other sources a breeze.
06:25
In this video, you discover how to wrangle data from external databases with the powerful and intuitive Microsoft Query tool.
02:28
Need to import information from the Internet? Excel has you covered with the capability to enhance your data models with information posted on the web.
Section 2: Validating and Qualifying Data
03:20
Here's a quick look at a few Excel Functions that come in handy when you need to clean and transform the text in your data.
Functions that manipulate Text Strings
04:04
04:48
Watch this video to examine the many ways you can leverage Excel data validation to protect cells, restrict data entry, and customize your own drop-down menus.
Section 3: Working with PivotTables and PivotCharts
07:02
PivotTables allow you to analyze large amounts of data with just a few clicks of the mouse. In this video, you'll get an introduction to one of Excel's premier analytical tools.
04:20
Go beyond basic PivotTables by adding your own business your own layer of analysis with calculated fields.
02:02
In this video, you'll delve into pivot charts. Pivot charts allow you to synthesize your data into visualizations that can be used in dashboards.
02:46
Gain insight into the various ways you can customize the layout and appearance of your PivotCharts.
Section 4: Using Criteria-Based Functions
03:28
Excel has a number of database functions that you can use to find specific information based on set criteria. In this video, you familiarize yourself with database functions by finding the largest and smallest values in a set of data.
03:15
Continue your exploration of database function with this look at the DGET function. The DGET function retrieves, from a dataset, a single value that matches a given criterion.
03:20
When analyzing data, you may find the need to sum values from records that match a specific criterion. In those scenario, you can use the DSUM function. The DSUM function adds values from a set of data based on selection criteria you specify.
05:02
Excel provides four useful statistical functions for counting cells within a set of data. : COUNT, COUNTA, COUNTBLANK and COUNTIF. Watch this video to understand the differences between these functions and how best to use each one.
Section 5: Calculating and Displaying Statistics
04:14
Percentiles and Quartiles are statistical functions that help you understand how a certain value in a set of data relates to the other values in the same set. This video examines how each of these functions work, and how you can leverage them to evaluate the performance and position of certain data points.
03:24
Gain an understanding of Standard Deviation and how it can help you better understand the makeup of the data you're working with.
04:07
This video shows you how to use Excel's RANK and PERCENTRANK functions to learn, rank, and compare a list of values.
05:06
Descriptive statistics allow you profile a dataset and enable comparisons that can be used in other analyses. Here you examine how to create your own descriptive statistics by using Excel's Analysis ToolPak Add-in.
04:53
A histogram is a useful visualization that shows how values in a dataset are distributed across categories. Find out how to leverage the Excel Analysis ToolPak Add-in to build your own histograms.
03:36
Take a look at the various methods you can use to smooth volatile data with moving averages.
Section 6: Creating Data Models
03:53
Discover how Scatter Plot charts allow you to explore the relationship and association between two sets of values.
08:13
Gain an understanding of linear regression with this in-depth look at the statistical calculations Excel runs to give you regression analysis.
08:22
In this video, you explore the Excel Solver tool. Here you gain an understanding of how to use Solver to find optimal solutions for all kinds of problems that require decisions.
Section 7: Ten Jobs For Excel Gurus
11 pages

Excel is everywhere. Companies in all types of industries hire Excel analysts to help provide insights and manage data. Knowing how wrangle data and create presentations in Excel will give you an advantage in the marketplace. These ten jobs are just some of hundreds of jobs available in the marketplace that require Excel skills.

Section 8: eBook Excel Data Analysis For Dummies, 2nd edition
165 pages

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

Excel Data Analysis For Dummies, 2nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson 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 book 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, 2nd Edition 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 2nd Edition is fully updated to include information about Excel's latest features, making it a your go-to Excel guide 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 book 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, 2nd Edition is the key to discovering what your numbers are hiding.

198 pages

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

Excel Data Analysis For Dummies, 2nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson 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 book 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, 2nd Edition 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 2nd Edition is fully updated to include information about Excel's latest features, making it a your go-to Excel guide 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 book 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, 2nd Edition is the key to discovering what your numbers are hiding.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Founded in 1807, John Wiley & Sons, Inc. has 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.

Ready to start learning?
Take This Course