Microsoft Office Excel 2007 Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts, and PivotTables [NOOK Book]

Overview

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 110 Excel data analysis techniques, including: Identifying trends in your data, Sorting, filtering, and identifying lists, Creating, editing, and checking formulas, Calculating interest rates and depreciation, Performing simple sorts and filters, Hiding rows or columns in a PivotTable, Adding and removing chart data, Querying an ...
See more details below
Microsoft Office Excel 2007 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)
$14.99
BN.com price
(Save 44%)$26.99 List Price
Note: This NOOK Book can be purchased in bulk. Please email us for more information.

Overview

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 110 Excel data analysis techniques, including: Identifying trends in your data, Sorting, filtering, and identifying lists, Creating, editing, and checking formulas, Calculating interest rates and depreciation, Performing simple sorts and filters, Hiding rows or columns in a PivotTable, Adding and removing chart data, Querying an Access[Trademark] database, Assigning digital signatures, Solving a formula with a data table.
Read More Show Less

Product Details

  • ISBN-13: 9781118079409
  • Publisher: Wiley
  • Publication date: 6/17/2011
  • Series: Visual Blueprint , #54
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 304
  • Sales rank: 1,225,678
  • File size: 69 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Denise Etheridge is a certified public accountant as well as the president and founder of Baycon Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, and authors computer-related books.

Read More Show Less

Table of Contents


Getting Started     2
Introduction to Data Analysis with Excel     2
Understanding the Excel Window     3
Enter Data     4
Format Numbers     6
Format Cells     10
Select Data     14
Copy, Cut, and Paste Cells     16
Copy with the Office Clipboard     18
Insert and Delete Cells     20
Find and Replace     22
Find and Replace Formats     24
Creating Formulas     26
Understanding Formulas     26
Create Formulas     28
Edit Formulas     30
Name Cells and Ranges     32
Define and Display Constants     34
Create Formulas that Include Names     36
Check Formulas for Errors     38
Trace Precedents and Dependents     40
Creating and Using Functions     42
Understanding the Function Wizard     42
Round a Number     44
Determine the Nth Largest Value     46
Create a Conditional Formula     48
Calculate a Conditional Sum     50
Calculate Products and Square Roots     52
Look Up Information     54
Determine the Location of a value     56
Perform Time Calculations     58
Perform Date Calculations     60
Using Financial Functions     62
Calculate Future Value     62
Calculate Present Value     64
Calculate Loan Payments     66
Calculate Principal or Interest     68
Calculate the Interest Rate     70
Calculate the Internal Rate of Return     72
Calculate Straight-Line Depreciation     74
Calculate Declining Balance Depreciation     76
Calculate Double-Declining Balance Depreciation     78
Calculate Sum-of-the-Years-Digits Depreciation     80
Using Statistical Functions and Tools     82
Calculate an Average     82
Calculate the Median or the Mode     84
Calculate Rank     86
Calculate Frequency     88
Calculate Variance and Standard Deviation     90
Find the Correlation     92
Install Excel Add-Ins     94
Calculate a Moving Average     96
Compare Variances     98
Using the Data Analysis Toolpak to Determine Rank and Percentile     100
Calculate Descriptive Statistics      102
Organizing Worksheet Data     104
Enter Data with a Form     104
Filter Duplicate Records     106
Perform Simple Sorts and Filters     108
Perform Complex Sorts     110
Sort by Cell Color, Font Color, or Icon     112
Perform Complex Filters     114
Enter Criteria to Find Records     116
Filter by Multiple Criteria     118
Subtotal Sorted Data     120
Count Filtered Records     122
Define Data as a Table     124
Modify a Table Style     126
Working with Pivottables     128
Create a PivotTable     128
Modify PivotTable Data and Layout     132
Compute Subtotals and Grand Totals     134
Create a PivotTable Calculated Field     136
Hide Rows or Columns in a PivotTable     138
Sort a PivotTable     139
Retrieve Values from a PivotTable     140
Charting Data     142
Create a Chart     142
Add Chart Details     144
Change the Chart Type     148
Add a Trendline     150
Add and Remove Chart Data     152
Add Error Bars     154
Create a Histogram     156
Chart Filtered Data     158
Create a PivotChart     160
Create a Combination Chart     162
Working with External Data     164
Paste Link into Word     164
Embed a Worksheet     166
Hyperlink a Worksheet     168
Query a Web Site     170
Import a Text File     172
Import an Access Database     176
Query an Access Database     178
Useful Data Analysis Tools and Techniques     182
Perform What-If Analysis     182
Optimize a Result with Goal Seek     184
Solve a Formula with a Data Table     186
Extend a Series with AutoFill     188
Work with Multiple Windows     190
Let Excel Read Back Your Data     192
Add a Calculator     193
Change Text to Numbers     194
Convert a Row to a Column     195
Consolidate Worksheets     196
Conditionally Format Your Worksheet     198
Change Conditional Formatting Rules     200
Paste with Paste Special     202
Insert Photographs into Your Worksheet     206
Sharing Your Workbook with Others      208
Validate with a Validation List     208
Validate with Data Entry Rules     210
Add Comments to Your Worksheet     212
Track Changes     214
Protect Your Worksheet     216
Save Your Workbook as a Template     218
Choose a Format When Saving a Workbook     220
Print Your Workbook     222
Print Multiple Areas of Your Worksheet     226
Add a Form Control to a Worksheet     228
Assign Values to a Form Control     230
Add a Macro to a Form Control     232
Automating with Macros     234
Introducing Macros     234
Set Macro Security     236
Create a Digital Signature     237
Record a Macro     238
Assign a Digital Signature to a Macro     240
Run a Macro     242
Create and Launch a Keyboard Shortcut     244
Assign a Macro to the Quick Access Toolbar     246
Delete a Macro     248
Excel Keyboard Shortcuts     250
Excel Function Quick Reference     256
Formula Basics     272
Index     276
Read More Show Less

Customer Reviews

Average Rating 3.5
( 3 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(2)

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
Sort by: Showing all of 3 Customer Reviews
  • Anonymous

    Posted August 7, 2007

    good for the Excel novice

    Unlike some other books on various versions of Excel, Etheridge's presentation accentuates a strong visual pedagogy. She has also hewed to a style where very 2 facing pages discusses some operation you can do. Those of you who read the O'Reilly books will recognise this as analogous to the O'Reilly Hacks series. So what Etheridge offers is really a set of bite-sized tasks. Easy to learn and immediately apply. The tasks are diverse. Like doing date computations. Or using the built in future value function. Or the interest rate, compounded over several payment periods. Some tasks relate to the visual display of the tables. As in changing a table's style. Or making a PivotTable. The tasks are not comprehensive. The book should not be considered as such. This is not an official Excel manual, per se. Instead, enough is shown to be useful, of common activities that you are likely to perform. Well suited for an Excel novice.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted August 6, 2009

    Run of the Mill

    This book was a major disappointment, The author did not show much creativity. I was not inspired by the limited number of examples compared to what I have in other books on earlier versions of Excel. I have learned more from online web tutorials. Save your money.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted February 19, 2010

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews

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