Excel Data Analysis For Dummies

Excel Data Analysis For Dummies, available at $54.99, has an average rating of 4.6, with 28 lectures, based on 1442 reviews, and has 7721 subscribers.

You will learn about Working with external databases Using PivotTables and PivotCharts Using Excel for statistical and financial functions Learn Solver, Small Business Finance Manager, and more This course is ideal for individuals who are Intermediate to Advanced Excel users It is particularly useful for Intermediate to Advanced Excel users.

Enroll now: Excel Data Analysis For Dummies

Summary

Title: Excel Data Analysis For Dummies

Price: $54.99

Average Rating: 4.6

Number of Lectures: 28

Number of Published Lectures: 28

Number of Curriculum Items: 28

Number of Published Curriculum Objects: 28

Original Price: $39.99

Quality Status: approved

Status: Live

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

Who Should Attend

Intermediate to Advanced Excel users

Target Audiences

Intermediate to Advanced Excel users

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

Excel Data Analysis For Dummiesvideo 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 websitesFor Dummies andWiley

Course Curriculum

Chapter 1: Arranging and Querting Data

Lecture 1: Understanding Excel Tables

Lecture 2: Advanced Filtering

Lecture 3: Tricks For Importing Data

Lecture 4: Using Microsoft Query

Lecture 5: Running Web Queries

Chapter 2: Validating and Qualifying Data

Lecture 1: Text Cleaning Functions

Lecture 2: Functions that manipulate Text Strings

Lecture 3: Using Data Validation

Chapter 3: Working with PivotTables and PivotCharts

Lecture 1: Understanding Pivot Tables

Lecture 2: Adding Calculations in Pivot Tables

Lecture 3: Creating Pivot Charts

Lecture 4: Customizing Your Pivot Charts

Chapter 4: Using Criteria-Based Functions

Lecture 1: Using DMAX and DIMN

Lecture 2: Using DGET to Find Specific Values

Lecture 3: Using DSUM to Add Values Based on Selection Criteria

Lecture 4: Counting Values

Chapter 5: Calculating and Displaying Statistics

Lecture 1: Percentiles and Quartile

Lecture 2: Understanding Standard Deviation

Lecture 3: Calculating Rank and Percent Rank

Lecture 4: Functions That Create Descriptive Statistics

Lecture 5: Creating a Histogram

Lecture 6: Calculating Moving Averages

Chapter 6: Creating Data Models

Lecture 1: Using a Scatter Plot to Show Relationships

Lecture 2: Understanding Linear Regression

Lecture 3: Using Solver to Model Data

Chapter 7: Ten Jobs For Excel Gurus

Lecture 1: Ten Jobs For Excel Gurus

Chapter 8: eBook Excel Data Analysis For Dummies, 2nd edition

Lecture 1: eBook Excel Data Analysis For Dummies, 2nd edition PART 1

Lecture 2: eBook Excel Data Analysis For Dummies, 2nd edition PART 2

Instructors

John Wiley & Sons
Video Training

Rating Distribution

1 stars: 10 votes
2 stars: 29 votes
3 stars: 179 votes
4 stars: 514 votes
5 stars: 710 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu