Excel Data Analysis For Dummies
4.2 (109 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.
2,241 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Data Analysis For Dummies to your Wishlist.

Add to Wishlist

Excel Data Analysis For Dummies

​Harness the Power of Excel to Discover What Your Numbers are Hiding
4.2 (109 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.
2,241 students enrolled
Last updated 6/2014
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Working with external databases
  • Using PivotTables and PivotCharts
  • Using Excel for statistical and financial functions
  • Learn Solver, Small Business Finance Manager, and more
View Curriculum
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 is the target audience?
  • Intermediate to Advanced Excel users
Students Who Viewed This Course Also Viewed
Curriculum For This Course
28 Lectures
08:03:36
+
Arranging and Querting Data
5 Lectures 20:21
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.
Preview 04:59

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.
Preview 03:35

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.
Preview 02:54

In this video, you discover how to wrangle data from external databases with the powerful and intuitive Microsoft Query tool.
Using Microsoft Query
06:25

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.
Running Web Queries
02:28
+
Validating and Qualifying Data
3 Lectures 12:12
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.
Text Cleaning Functions
03:20

Functions that manipulate Text Strings
04:04

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.
Using Data Validation
04:48
+
Working with PivotTables and PivotCharts
4 Lectures 16:10
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.
Understanding Pivot Tables
07:02

Go beyond basic PivotTables by adding your own business your own layer of analysis with calculated fields.
Adding Calculations in Pivot Tables
04:20

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.
Creating Pivot Charts
02:02

Gain insight into the various ways you can customize the layout and appearance of your PivotCharts.
Customizing Your Pivot Charts
02:46
+
Using Criteria-Based Functions
4 Lectures 15:05
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.
Using DMAX and DIMN
03:28

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.
Using DGET to Find Specific Values
03:15

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.
Using DSUM to Add Values Based on Selection Criteria
03:20

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.
Counting Values
05:02
+
Calculating and Displaying Statistics
6 Lectures 25:20
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.
Percentiles and Quartile
04:14

Gain an understanding of Standard Deviation and how it can help you better understand the makeup of the data you're working with.
Understanding Standard Deviation
03:24

This video shows you how to use Excel's RANK and PERCENTRANK functions to learn, rank, and compare a list of values.
Calculating Rank and Percent Rank
04:07

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.
Functions That Create Descriptive Statistics
05:06

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.
Creating a Histogram
04:53

Take a look at the various methods you can use to smooth volatile data with moving averages.
Calculating Moving Averages
03:36
+
Creating Data Models
3 Lectures 20:28
Discover how Scatter Plot charts allow you to explore the relationship and association between two sets of values.
Using a Scatter Plot to Show Relationships
03:53

Gain an understanding of linear regression with this in-depth look at the statistical calculations Excel runs to give you regression analysis.
Understanding Linear Regression
08:13

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.
Using Solver to Model Data
08:22
+
Ten Jobs For Excel Gurus
1 Lecture 00:00

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.

Ten Jobs For Excel Gurus
11 pages
+
eBook Excel Data Analysis For Dummies, 2nd edition
2 Lectures 00:00

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.

eBook Excel Data Analysis For Dummies, 2nd edition PART 1
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.

eBook Excel Data Analysis For Dummies, 2nd edition PART 2
198 pages
About the Instructor
John Wiley & Sons, Inc.
4.3 Average rating
910 Reviews
17,781 Students
18 Courses
Video Training

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.