Excel data analysis : your visual blueprint for analyzing data, charts, and PivotTables

Select an Action

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.

Copies:

Available:*

Library	Material Type	Item Barcode	Shelf Number	Copy	Status
Searching... 1:IIEMSA	1:GEN-BOOK	33168025768280	005.54 M144E 2013	1	Searching... Unknown

Bound With These Titles

On Order

Summary

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!