Excel 2013 All-in-One For Dummies

Overview

The comprehensive reference, now completely up-to-date for Excel 2013!

As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and...

See more details below
Paperback
$21.22
BN.com price
(Save 39%)$34.99 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (15) from $15.62   
  • New (12) from $15.62   
  • Used (3) from $20.80   

Overview

The comprehensive reference, now completely up-to-date for Excel 2013!

As the standard for spreadsheet applications, Excel is used worldwide - but it's not always user-friendly. However, in the hands of veteran bestselling author Greg Harvey, Excel gets a whole lot easier to understand! This handy all-in-one guide covers all the essentials, the new features, how to analyze data with Excel, and much more. The featured minibooks address Excel basics, worksheet design, formulas and functions, worksheet collaboration and review, charts and graphics, data management, data analysis, and Excel and VBA.

  • Covers the changes in the newest version as well as familiar tasks, such as creating and editing worksheets, setting up formulas, and performing statistical functions
  • Walks you through the new analysis tools that help make it easier to visualize data with the click of a mouse
  • Details new ways to explore your data more intuitively and then analyze and display your results with a single click

Whether you're an Excel newbie or a veteran user to wants to get familiar with the latest version, Excel 2013 All-in-One For Dummies has everything you need to know.

Read More Show Less

Product Details

  • ISBN-13: 9781118510100
  • Publisher: Wiley
  • Publication date: 3/4/2013
  • Series: For Dummies Series
  • Edition number: 1
  • Pages: 792
  • Sales rank: 109,330
  • Product dimensions: 6.90 (w) x 9.30 (h) x 1.90 (d)

Meet the Author

Greg Harvey, PhD, is President of Mind Over Media and a highly skilled instructor. He has been writing computer books for more than 20 years, and his long list of bestsellers includes all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies.

Read More Show Less

Table of Contents

Introduction 1

About This Book 1

Foolish Assumptions 2

How This Book Is Organized 3

Book I: Excel Basics 3

Book II: Worksheet Design 3

Book III: Formulas and Functions 4

Book IV: Worksheet Collaboration and Review 5

Book V: Charts and Graphics 5

Book VI: Data Management 6

Book VII: Data Analysis 6

Book VIII: Macros and VBA 6

Conventions Used in This Book 7

Icons Used in This Book 8

Where to Go from Here 9

Book I: Excel Basics 11

Chapter 1: The Excel 2013 User Experience 13

Chapter 2: Customizing Excel 2013 41

Book II: Worksheet Design 73

Chapter 1: Building Worksheets 75

Chapter 2: Formatting Worksheets 125

Chapter 3: Editing and Proofing Worksheets 183

Chapter 4: Managing Worksheets 231

Chapter 5: Printing Worksheets 269

Book III: Formulas and Functions 297

Chapter 1: Building Basic Formulas 299

Chapter 2: Logical Functions and Error Trapping 339

Chapter 3: Date and Time Formulas 361

Chapter 4: Financial Formulas 375

Chapter 5: Math and Statistical Formulas 389

Chapter 6: Lookup, Information, and Text Formulas 409

Book IV: Worksheet Collaboration and Review 431

Chapter 1: Protecting Workbooks and Worksheet Data 433

Chapter 2: Using Hyperlinks 455

Chapter 3: Sending Workbooks Out for Review 463

Chapter 4: Sharing Workbooks and Worksheet Data 489

Book V: Charts and Graphics 513

Chapter 1: Charting Worksheet Data 515

Chapter 2: Adding Graphic Objects 545

Book VI: Data Management 575

Chapter 1: Building and Maintaining Data Lists 577

Chapter 2: Filtering and Querying a Data List 601

Book VII: Data Analysis 643

Chapter 1: Performing What-If Scenarios 645

Chapter 2: Generating Pivot Tables 667

Book VIII: Macros and VBA 707

Chapter 1: Building and Running Macros 709

Chapter 2: VBA Programming 721

Index 745

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)