Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 0 Minute(s)
Language
English
Taught by
John Wiley & Sons
Rating
1 views
Course Overview
Harness the Power of Excel to Discover What Your Numbers are Hiding
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
Course Content
- 8 section(s)
- 28 lecture(s)
- Section 1 Arranging and Querting Data
- Section 2 Validating and Qualifying Data
- Section 3 Working with PivotTables and PivotCharts
- Section 4 Using Criteria-Based Functions
- Section 5 Calculating and Displaying Statistics
- Section 6 Creating Data Models
- Section 7 Ten Jobs For Excel Gurus
- Section 8 eBook Excel Data Analysis For Dummies, 2nd edition
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
Skills covered in this course
Reviews
-
JJack Johnston
This course was able to refresh some Excel skills I haven't used in a while and will expedite the process in creating products going forward. Thank you!
-
CCarolinamun
I liked the course and content. Something to improve is adding the Vlookup function. I think this is very important and it´s a basic feature to know in Excel.
-
VVarsha Shashidhar
I wish we had access to the data sheets that were shown at the beginning of each lesson so we could follow along. Also some lessons started with certain formula's already placed, I was very confused and had a hard time with those lessons.
-
BBruce DeMello
Good overview of the key data analysis and introductory statistical analysis functions of MS Excel, covering the basic "built-in" functions. Re-enforced some of the MS Excel functions learned in a basic MS Excel training, focused on how to use/manipulate/analyze your data.
