Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables - Softcover

McFedries, Paul

 
9781118517147: Excel Data Analysis: Your visual blueprint for analyzing data, charts, and PivotTables
Softcover
ISBN 10: 1118517148 ISBN 13: 9781118517147
Verlag: John Wiley & Sons, 2013

Inhaltsangabe

Professional-level coverage and techniques for Excel power users
 
Aimed at Excel power users who appreciate logical, clean explanations of techniques, this visual guide features numerous screenshots and easy-to-follow numbered steps in order to show you how to perform professional-level modeling, charting, data sharing, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver, and more.
* Demonstrates how to crunch and analyze Excel data the way the professionals do in an uncluttered, visual style
* Offers a clear look at power-using the new Excel 2013, the latest version of the world's leading spreadsheet application from Microsoft
* Expands your Excel knowledge and helps you use Excel data more efficiently
* Explains how to retrieve data from databases; cut, slice, and pivot data using PivotTables; model data and chart data; and use advanced formulas
* Explores all features and functions in two-color pages packed with screenshots, numbered steps, and other visual graphics that clearly show you how to accomplish tasks
* Includes practical examples, tips, and advice to help you get the most out of Excel's features and functions
 
Learn the full power of Excel 2013 with this helpful guide!

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Über die Autorin bzw. den Autor

Paul Mcfedries (Toronto, Ontario) runs Logophilia Limited, a technical writing company, and has been writing computer books for more than 17 years. He is the author or coauthor of more than 60 books that have sold more than 3 million copies worldwide. Paul is also the proprietor of Wordspy.com, a website that tracks new words and phrases as they enter the language.

Von der hinteren Coverseite

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 150 Excel Data Analysis techniques, including:
* Creating array formulas
* Checking for formula errors
* Determining the location of a value
* Calculating straight-line depreciation
* Creating a grouped frequency distribution
* Converting a range to a table
* Analyzing cell values
* Plotting a logarithmic trendline
* Running a regression analysis
* Building PivotTables and charts
 
Features
* High-resolution screen shots demonstrate each task
* Succinct explanations walk you through step by step
* Two-page lessons break big topics into bite-sized modules
* "Apply It" and "Extra" sidebars highlight useful tips

„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.

Verlag
John Wiley & Sons
Erscheinungsdatum
2013
Sprache
Englisch
ISBN 10 
1118517148
ISBN 13 
9781118517147
Einband
Taschenbuch
Auflage
4
Anzahl der Seiten
336
Kontakt zum Hersteller
Nicht verfügbar
Verantwortliche Person
Nicht verfügbar

Weitere beliebte Ausgaben desselben Titels

9788126544004: Excel Data Analysis: Your Visual Blueprint for Analyzing Data, Charts and Pivot-tables

Vorgestellte Ausgabe

ISBN 10:  8126544007 ISBN 13:  9788126544004
Verlag: Wiley India, 2013
Softcover