Excel Data Analysis For Dummies 3e - Tapa blanda

Acerca del autor

Stephen L. Nelson provides accounting, business advisory, tax planning, and tax preparation services to small businesses. He belongs to the American Institute of CPAs and teaches graduate tax courses. Among Steve's 100-plus books are all editions of QuickBooks For Dummies and Quicken For Dummies. Elizabeth C. Nelson is a CPA and specializes in multi-state and international taxation of S corporations and partnerships. She holds a Bachelor of Science in Accounting from Western Governors University and is the co-author of the popular monographs Preparing the 3115 Form for the New Tangible Property Regulations and Small Businesses and the Affordable Care Act.

De la contraportada

Learn to:

• Navigate and analyze complex data
• Work with external databases, PivotTables, and PivotCharts
• Use Excel for statistical and financial functions
• Make the most of the latest features of Excel

Put the power of Excel to work and excel at data analysis!

Most businesses are drowning in data, and making sense of it all is critical. Excel is a powerful data analysis tool, and this book shows you how to use it and become a data deciphering expert. You'll learn to organize data in workbooks, create powerful magic with PivotTables and PivotCharts, and explore advanced statistical tools that take you to the next level.

• Table your data — learn to export data from a database, build a table, get data from external sources, and query databases
• Keep it clean — delete unnecessary columns and rows in an imported workbook and clean your data with text functions
• This way and that — see how to view your data from different angles using PivotTables
• Fine-tune with formulas — build PivotTable formulas to create custom calculations and retrieve data from a PivotTable
• Chart your course — create and customize PivotCharts to display data in various ways, even in a 3D chart
• Dive deeper — check out a dozen database functions you can use for more detailed analysis
• Statistically speaking — explore Excel's statistics functions for finding percentiles and standard deviations, doing regression analysis, and more

Open the book and find:

• Ways to use filters with tables
• All about exporting and importing data
• Essential text functions for cleaning data
• How to use the PivotTable and PivotChart wizards
• Tips on customizing a PivotTable
• When to use Chart Commands
• Different types of PivotCharts
• What you can do with descriptive statistics