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