Excel Data Analysis For Dummies
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
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
Overview
Section 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
Section 2: Validating and Qualifying Data
Lecture 6 Text Cleaning Functions
Lecture 7 Functions that manipulate Text Strings
Lecture 8 Using Data Validation
Section 3: Working with PivotTables and PivotCharts
Lecture 9 Understanding Pivot Tables
Lecture 10 Adding Calculations in Pivot Tables
Lecture 11 Creating Pivot Charts
Lecture 12 Customizing Your Pivot Charts
Section 4: Using Criteria-Based Functions
Lecture 13 Using DMAX and DIMN
Lecture 14 Using DGET to Find Specific Values
Lecture 15 Using DSUM to Add Values Based on Selection Criteria
Lecture 16 Counting Values
Section 5: Calculating and Displaying Statistics
Lecture 17 Percentiles and Quartile
Lecture 18 Understanding Standard Deviation
Lecture 19 Calculating Rank and Percent Rank
Lecture 20 Functions That Create Descriptive Statistics
Lecture 21 Creating a Histogram
Lecture 22 Calculating Moving Averages
Section 6: Creating Data Models
Lecture 23 Using a Scatter Plot to Show Relationships
Lecture 24 Understanding Linear Regression
Lecture 25 Using Solver to Model Data
Section 7: Ten Jobs For Excel Gurus
Lecture 26 Ten Jobs For Excel Gurus
Section 8: eBook Excel Data Analysis For Dummies, 2nd edition
Lecture 27 eBook Excel Data Analysis For Dummies, 2nd edition PART 1
Lecture 28 eBook Excel Data Analysis For Dummies, 2nd edition PART 2
Intermediate to Advanced Excel users
Course Information:
Udemy | English | 8h 3m | 863.41 MB
Created by: John Wiley & Sons
You Can See More Courses in the Office Productivity >> Greetings from CourseDown.com