Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Excel Data Analysis For Dummies

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

Created byJohn Wiley & Sons

Last updated 6/2014

English

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

Course content

8 sections • 28 lectures • 2h 0m total length

Understanding Excel Tables4: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.
Advanced Filtering3: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.

Tricks For Importing Data2: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.

Using Microsoft Query6:25

In this video, you discover how to wrangle data from external databases with the powerful and intuitive Microsoft Query tool.
Running Web Queries2: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.

Text Cleaning Functions3: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 Strings4:04
Using Data Validation4: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.

Understanding Pivot Tables7: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.
Adding Calculations in Pivot Tables4:20

Go beyond basic PivotTables by adding your own business your own layer of analysis with calculated fields.
Creating Pivot Charts2: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.
Customizing Your Pivot Charts2:46

Gain insight into the various ways you can customize the layout and appearance of your PivotCharts.

Using DMAX and DIMN3: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.

Using DGET to Find Specific Values3: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.

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

Counting Values5: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.

Percentiles and Quartile4: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.

Understanding Standard Deviation3:24

Gain an understanding of Standard Deviation and how it can help you better understand the makeup of the data you're working with.
Calculating Rank and Percent Rank4:07

This video shows you how to use Excel's RANK and PERCENTRANK functions to learn, rank, and compare a list of values.

Functions That Create Descriptive Statistics5: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.

Creating a Histogram4: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.

Calculating Moving Averages3:36

Take a look at the various methods you can use to smooth volatile data with moving averages.

Using a Scatter Plot to Show Relationships3:53

Discover how Scatter Plot charts allow you to explore the relationship and association between two sets of values.
Understanding Linear Regression8:13

Gain an understanding of linear regression with this in-depth look at the statistical calculations Excel runs to give you regression analysis.
Using Solver to Model Data8: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.

eBook Excel Data Analysis For Dummies, 2nd edition PART 12:45:00
Harness the power of Excel to discover what your numbers are hiding

Excel Data Analysis For Dummies, 2^nd 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, 2^nd 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 2^nd 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, 2^nd Edition is the key to discovering what your numbers are hiding.
eBook Excel Data Analysis For Dummies, 2nd edition PART 23:18:00
Harness the power of Excel to discover what your numbers are hiding

Excel Data Analysis For Dummies, 2^nd 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, 2^nd 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 2^nd 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, 2^nd Edition is the key to discovering what your numbers are hiding.

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

Excel Data Analysis For Dummies

What you'll learn

Explore related topics

Course content

Arranging and Querting Data5 lectures • 20min

Validating and Qualifying Data3 lectures • 12min

Working with PivotTables and PivotCharts4 lectures • 16min

Using Criteria-Based Functions4 lectures • 15min

Calculating and Displaying Statistics6 lectures • 25min

Creating Data Models3 lectures • 20min

Ten Jobs For Excel Gurus1 lecture • 11min

eBook Excel Data Analysis For Dummies, 2nd edition2 lectures • 6hr 3min

Requirements

Description

Who this course is for: