Articoli correlati a Excel Data Analysis: Your Visual Blueprint For Creating...

Excel Data Analysis: Your Visual Blueprint For Creating and Analyzing Data, Charts, And Pivottables: Your Visual Blueprint for Analyzing Data, Charts, and PivotTables - Brossura

Simon, Jinjer

 
9780764597800: Excel Data Analysis: Your Visual Blueprint For Creating and Analyzing Data, Charts, And Pivottables: Your Visual Blueprint for Analyzing Data, Charts, and PivotTables
Brossura
ISBN 10: 0764597809 ISBN 13: 9780764597800
Casa editrice: Visual, 2005

Sinossi

Excel is a spreadsheet / data analysis tool attached to the Microsoft Office suite and is available in all Office offerings. Office holds 80-90% of the market share for productivity suites. Though many consumers know the basics of using Excel, they may not know the full power of the program. With Excel, you can harness the power of your data, manipulate it to suit your needs, and achieve more by doing less work. Charts are interactive, allowing the consumer to tweak results with the click of a mouse. Pivot tables allow you to fuse data from several sources into one document. Excel has an enhanced Find function, allowing users to easily search entire workbooks, and search worksheets by cell format. Excel supports XML as a file format for easy importing or exporting of XML data. Excel also includes enhancements for saving files as Web pages, and enhancements to Pivot Tables.

Le informazioni nella sezione "Riassunto" possono far riferimento a edizioni diverse di questo titolo.

Informazioni sull'autore

Jinjer Simon has been actively involved in the computer industry for the past 18 years. Her involvement includes programming, providing software technical support, training end-users, developing written and online user documentation, creating software tutorials, and developing Web sites. She is the author of several computer books, including Excel Programming: Your visual blueprint for creating interactive spreadsheets, and Windows CE 2 For Dummies.

Dalla quarta di copertina

Excel Data Analysis 2nd Edition

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

  • Creating PivotTables and PivotCharts
  • Importing and linking data
  • Compiling data from various sources
  • Filtering a list
  • Creating an amortization table
  • Manipulating data within a chart
  • Editing external database tables
  • Using an Excel function in a macro
  • Building PivotTable formulas
  • Using Analysis Toolpak add-ins
  • 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

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Editore
Visual
Data di pubblicazione
2005
Lingua
Inglese
ISBN 10 
0764597809
ISBN 13 
9780764597800
Rilegatura
Copertina flessibile
Numero edizione
2
Numero di pagine
291
Contatto del produttore
non disponibile
Persona responsabile
non disponibile