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.

How taking a course works

Discover

Learn

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.

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.

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.

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

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.

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.

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.

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

SHARE

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.