Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables - Tapa blanda

Etheridge, Denise

 
9780470591604: Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables
Tapa blanda
ISBN 10: 0470591609 ISBN 13: 9780470591604
Editorial: Visual, 2010

Sinopsis

Advanced techniques for Excel power users

Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, 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.

  • Provides a clear look at power-using Excel, the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
  • Expands your Excel knowledge and helps you use Excel data more efficiently
  • Demonstrates 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 friendly, 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 Excel at the highest levels with this practical guide.

"Sinopsis" puede pertenecer a otra edición de este libro.

Acerca del autor

Denise Etheridge (Burlington, NJ) is a certified public accountant as well as the president and founder of BayCon Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, teaches college-level computer and accounting courses, and has authored or coauthored two computer related books: Flash ActionScript: Your visual blueprint for creating Flash-enhanced Web sites. In addition, she authored Excel 2007 Visual Quick Tips and Excel 2007 Top 100 Simplified Tips and Tricks. Denise has trained and assisted clients with the implementation of accounting-related software since 1985. Stanford University and the United States House of Representatives are among her former clients. Prior to founding BayCon Group, she spent two years working for Oracle Corporation as an Oracle Financials software consultant.

De la contraportada

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 190 key Excel data analysis techniques, including:

  • Using Web-based applications in Excel

  • Creating formulas and using functions

  • Calculating interest rates and depreciation

  • Working with statistical functions

  • Using database functions

  • Creating PivotTables and using Slicer

  • Performing "what-if" analysis

  • Automating Excel with macros

  • Adding illustrations to worksheets

  • Customizing the Ribbon

  • 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

"Sobre este título" puede pertenecer a otra edición de este libro.

Editorial
Visual
Año de publicación
2010
Idioma
Inglés
ISBN 10 
0470591609
ISBN 13 
9780470591604
Encuadernación
Tapa blanda
Número de edición
3
Número de páginas
368
Contacto del fabricante
no disponible
Persona responsable
no disponible

Otras ediciones populares con el mismo título

9788126542697: Microsoft Excel Data Analysis, 3Ed

Edición Destacada

ISBN 10:  8126542691 ISBN 13:  9788126542697
Tapa blanda