Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables
Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables
Editorial Reviews
Book Description
* Essential for those who know basic Excel and want to explore the full potential of the program
* Teaches how to manipulate data to suit specific needs and achieve more by doing less work
* Self-contained two-page lessons, featuring high-resolution screen shots and minimal text, show how to create custom functions, retrieve data from databases, use value chains, and slice and pivot information from the Web with Excel's PivotTable utility
* Covers data analyzing techniques for statistical functions, financial functions, data sharing, PivotTables and PivotCharts, Solver, and BackSolver
From the Back Cover
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
Data analysis tools on CD-ROM!
- Trial versions of FinOptions XL, Analyse-It, Sigma XL, 4TOPS Data Analysis, and XLSTAT Pro
- UNISTAT demo version
- Macro codes
- A searchable e-version of the book
Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables
Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables,Jinjer Simon,Jinjer Simon,Visual,0764537547,Business,Computer Bks - Spreadsheets,Computer Books: General,Computer programs,Computers,Database Management - General,Electronic spreadsheets,Microcomputer Spreadsheet Software,Microsoft Excel (Computer file,Spreadsheets - Excel,Spreadsheets - General,Statistical Methods In The Social Sciences,Statistics,Computers / Spreadsheets / General,Excel
Mathematics Book
Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables
Books:
- F. W. Woolworth and the American Five and Dime: A Social History
- Fast Food : Roadside Restaurants in the Automobile Age (The Road and American Culture)
- Fatal Attractions: The Troubles With Science
- Food in Colonial and Federal America (Food in American History)
- Geography of Identity (Ratio : Institute for the Humanities)
- Global Entertainment Media: Content, Audiences, Issues (Lea's Communication Series) (Lea's Communication Series)
- Halo 2 Hacks : Tips & Tools for Finishing the Fight
- In the Shadow of the Vampire: Reflections from the World of Anne Rice
- J-rock Groupies: 200 Photographs of Unique Japanese Girls
- Kontakt 2 Power!: The Comprehensive Guide
Books
books
Books
- Print Index: A Guide to Reproductions (Art Reference Collection)
- Investment Pricing Methods : A Guide for Accounting and Financial Professionals
- Gran Turismo : Prima's Official Strategy Guide
- Elementary Statistics : A Step by Step Approach w/MathZone
- Versatile Tractors: A Farm Boy's Dream
- Web of Life (Perspectives in Science and Engineering)
- Wavelet Transforms & Time-Frequency Signal Analysis
- Books Info books-info-097
- Against All Enemies
- 101 Things to do with Salad
- 52 Ways to Wing It
- American Bamboos
- A Daddy's World
- A Nation-State by Construction: Dynamics of Modern Chinese Nationalism
- Animals in Early Medieval Art
- German Books: Deutsche Bücher ~ 32
- Der Goldstaub-Taggecko
- Württemberg-Baden-Hohenzollern
- C++ Programming: Program Design Including Data Structures, Third Edition