Excel data analysis : your visual blueprint for analyzing data, charts, and PivotTables
by
McFedries, Paul.
Title
:
Excel data analysis : your visual blueprint for analyzing data, charts, and PivotTables
Author
:
McFedries, Paul.
ISBN
:
9781118517147
Personal Author
:
McFedries, Paul.
Edition
:
4th edition.
Publication Information
:
Indianapolis, IN : Wiley, [2013]
Physical Description
:
323 pages : illustrations ; 24 cm
Series
:
Visual blueprint
Visual blueprint.
General Note
:
Rev. ed. of: Excel data analysis : your visual blueprint for creating and analyzing data, charts and PivotTables / by Denise Etheridge. 3rd ed. c2010.
"Visual, a Wiley brand."
Includes index.
Contents
:
Building formulas for data analysis -- Troubleshooting formulas -- Enhancing formulas with functions -- Analyzing financial data -- Analyzing statistical data -- Building tables for data analysis -- Sorting and filtering data -- Learning data analysis techniques -- Working with data analysis tools -- Tracking trends and making forecasts -- Working with the analysis ToolPak -- Analyzing data with PivotTables -- Visualizing data with charts -- Importing data into Excel -- Querying data sources -- Learning VBA for data analysis -- Appendix: Using Excel keyboard shortcuts.
Abstract
:
Provides instructions on using Excel to analyze data, covering such topics as creating formulas, using financial functions, organizing worksheet data, working with PivotTables, and automating with macros.
Title Subject
:
Microsoft Excel (Computer file)
Subject Term
:
Business -- Computer programs.
Electronic spreadsheet.
Added Author
:
Etheridge, Denise. Excel data analysis.
| Library | Material Type | Item Barcode | Shelf Number | Copy |
|---|
| IIEMSA | General Books | 33168025768280 | 005.54 M144E 2013 | 1 |