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

Overview

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 ...

See more details below
Paperback
$21.71
BN.com price
(Save 27%)$29.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (19) from $5.75   
  • New (13) from $5.74   
  • Used (6) from $6.00   
Excel Data Analysis: Your visual blueprint for creating and analyzing data, charts and PivotTables

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$16.49
BN.com price
(Save 45%)$29.99 List Price

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9780470591604
  • Publisher: Wiley
  • Publication date: 7/6/2010
  • Series: Visual Blueprint Series , #29
  • Edition number: 3
  • Pages: 368
  • Sales rank: 605,397
  • Product dimensions: 7.30 (w) x 9.10 (h) x 1.00 (d)

Read an Excerpt

http://catalogimages.wiley.com/images/db/pdf/9780470591604.excerpt.pdf

Read More Show Less

Table of Contents

HOW TO USE THIS BOOK.

1 GETTING STARTED.

Introducing Data Analysis with Excel.

Tour the Excel Window.

Explore the Ribbon.

Using the Mini Toolbar and Context Menu.

Select Options on the Status Bar.

Take a Look at Backstage View.

Upload a File to Excel's Web-based Application.

Create a File Using Excel's Web-based Application.

Enter Data.

Select Cells.

2 FORMATTING A WORKSHEET.

Using the Ribbon to Format Numbers.

Using the Format Cells Dialog Box.

Understanding Dates and Times.

Format Percentages.

Format Fractions.

Format in Scientific Notation.

Format as Text.

Add a Border.

Change the Font or Font Size.

Add a Background Color.

Change the Font Color.

Bold, Underline, or Italicize.

Align Data.

Rotate Data.

Wrap Text.

Merge and Center.

Apply a Style.

Using Format Painter.

Clear Formats.

3 STRUCTURING YOUR WORKBOOK.

Cut, Copy, and Paste Cells.

Using Live Preview with Paste.

Paste from the Office Clipboard.

Insert or Delete.

Find and Replace Information.

Change the Name of a Worksheet.

Change Column Widths or Row Heights.

Hide Columns or Rows.

Hide a Worksheet.

Move or Copy a Worksheet.

Freeze Worksheet Titles.

Hide Gridlines, Headings, or the Formula Bar.

4 CREATING FORMULAS.

Understanding Formulas.

Calculate with an Operator.

Calculate Using a Function and Cell Addresses.

Create an Array Formula.

Using the Sum, Average, Count, Min, and Max Functions.

Create a Formula that Refers to Another Worksheet.

Understanding Relative and Absolute Cell Addresses.

Edit Formulas.

Name Cells and Ranges.

Define and Display Constants.

Create Formulas That Include Names.

Check Formulas for Errors.

Trace Precedents and Dependents.

5 USING FUNCTIONS.

Understanding the Function Wizard.

Round a Number.

Create a Conditional Formula.

Calculate a Conditional Sum.

Calculate a Conditional Count.

Find the Square Root.

Retrieve Column or Row Numbers.

Using VLOOKUP.

Determine the Location of a Value.

Using INDEX.

Perform Date and Time Calculations.

6 USING FINANCIAL FUNCTIONS.

Calculate Future Value.

Calculate Present Value.

Calculate Loan Payments.

Calculate Principal or Interest.

Calculate the Interest Rate.

Calculate the Internal Rate of Return.

Calculate Straight-Line Depreciation.

Calculate Declining Balance Depreciation.

Calculate Double-Declining Balance Depreciation.

Calculate Sum-of-the-Years-Digits Depreciation.

7 USING STATISTICAL FUNCTIONS AND TOOLS.

Calculate an Average.

Calculate a Conditional Average.

Calculate the Median or the Mode.

Calculate Rank.

Determine the Nth Largest Value.

Calculate Frequency.

Calculate Variance and Standard Deviation.

Find the Correlation.

Install Excel Add-Ins.

Calculate a Moving Average.

Compare Variances.

Using the Data Analysis Toolpak to Determine Rank and Percentile.

Calculate Descriptive Statistics.

8 ORGANIZING WORKSHEET DATA.

Enter Data with a Form.

Perform Simple Sorts and Filters.

Perform Multilevel Sorts.

Perform a Custom Sort.

Sort by Cell Color, Font Color, or Cell Icon.

Perform Complex Filters.

Enter Criteria to Find Records.

Using Advanced Filtering Techniques.

Filter Duplicate Records.

Count Filtered Records.

Subtotal Records.

Using Auto Outline.

Define Data as a Table.

Modify a Table Style.

Using Database Functions with a Table.

9 WORKING WITH PIVOTTABLES.

Create a PivotTable.

Modify a PivotTable Layout.

Summarize PivotTable Values.

Create a PivotTable Calculated Field.

Group the Rows or Columns in a PivotTable.

Apply a Style to a PivotTable.

Filter a PivotTable.

Sort a PivotTable.

Retrieve Values from a PivotTable.

Using Slicer.

10 CHARTING DATA.

Create a Chart.

Add Chart Details.

Create a Combination Chart.

Change the Chart Type.

Add or Remove Chart Data.

Add Sparklines.

Create a Trendline.

Add Error Bars.

Create a Histogram.

Chart Filtered Data.

Create a PivotChart.

Filter a PivotChart.

11 WORKING WITH EXTERNAL DATA.

Paste Link into Word.

Embed a Worksheet.

Hyperlink a Worksheet.

Query a Web Site.

Import a Text File.

Import an Access Database.

Query an Access Database.

12 USING DATA ANALYSIS TOOLS AND TECHNIQUES.

Perform What-If Analysis.

Optimize a Result with Goal Seek.

Using Solver.

Solve a Formula with a Data Table.

Extend a Series with Auto Fill.

Join Text.

Add a Calculator.

Consolidate Worksheets.

Highlight Cells that Meet Your Criteria.

Find the Highest or Lowest Ranked Values.

Add Data Bars to Your Worksheet.

Add Icon Sets to Your Worksheet.

Remove Conditional Formatting.

Change Conditional Formatting Rules.

Paste with Paste Special.

13 SHARING YOUR WORKBOOK WITH OTHERS.

Validate with a Validation List.

Validate with Data Entry Rules.

Add Comments to Your Worksheet.

Track Changes.

Protect Your Worksheet.

Save Your Workbook as a Template.

Choose a Format When Saving a Workbook.

Print Your Workbook.

Print Multiple Areas of Your Worksheet.

14 AUTOMATING WITH MACROS.

Introducing Macros.

Set Macro Security.

Create a Digital Signature.

Record a Macro.

Assign a Digital Signature to a Macro.

Run a Macro.

Create and Launch a Keyboard Shortcut.

Assign a Macro to the Quick Access Toolbar.

Delete a Macro.

15 ILLUSTRATING YOUR WORKSHEETS.

Place a Screenshot in Your Worksheet.

Insert Clip Art into Your Worksheet.

Crop a Clip Art Illustration or a Photograph.

Insert a Picture into Your Worksheet.

Recolor a Picture.

Adjust the Sharpness, Brightness, and Contrast.

Compress a Picture.

Add a Border.

Add a Picture Effect.

Apply a Picture Style.

Add an Artistic Effect.

Remove a Background.

16 ILLUSTRATING YOUR IDEAS.

Insert a Text Box.

Format a Text Box.

Insert a Shape.

Add Text to a Shape.

Change the Size of an Object.

Rotate an Object.

Change the Stacking Order.

Group Objects.

Align Objects.

Insert a Symbol.

Using SmartArt Graphics.

Modify a SmartArt Graphic.

Apply a SmartArt Style.

Apply a SmartArt Layout.

17 CUSTOMIZING EXCEL.

Add a Form Control to a Worksheet.

Assign Values to a Form Control.

Add a Macro to a Form Control.

Customize the Quick Access Toolbar.

Customize the Ribbon.

APPENDIX A: USING EXCEL KEYBOARD SHORTCUTS.

Using Excel Keyboard Shortcuts.

INDEX.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)