Stephen L. Nelson
Excel Data Analysis For Dummies
Ebook (EPUB Format)
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…
Mehr
Beschreibung
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
CHF 23.00
Preise inkl. MwSt. und Versandkosten (Portofrei ab CHF 40.00)
Versandkostenfrei
Produktdetails
Weitere Autoren: Nelson, E. C.
- ISBN: 978-1-119-07716-9
- EAN: 9781119077169
- Produktnummer: 19381812
- Verlag: John Wiley & Sons
- Sprache: Englisch
- Erscheinungsjahr: 2015
- Seitenangabe: 384 S.
- Plattform: EPUB
- Masse: 18'571 KB
- Auflage: 3. Auflage
Über den 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.
89 weitere Werke von Stephen L. Nelson:
Bewertungen
0 von 0 Bewertungen
Anmelden
Keine Bewertungen gefunden. Seien Sie der Erste und teilen Sie Ihre Erkenntnisse mit anderen.