Excel 2013 All-in-One For Dummies

Excel 2013 All-in-One For Dummies

by Greg Harvey

Paperback

$31.49 $34.99 Save 10% Current price is $31.49, Original price is $34.99. You Save 10%.
View All Available Formats & Editions
Eligible for FREE SHIPPING
  • Want it by Friday, October 26?   Order by 12:00 PM Eastern and choose Expedited Shipping at checkout.

Overview

Excel 2013 All-in-One For Dummies by Greg Harvey

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

As the standard for spreadsheet applications, Excel is usedworldwide - but it's not always user-friendly. However, in thehands of veteran bestselling author Greg Harvey, Excel gets a wholelot easier to understand! This handy all-in-one guide covers allthe 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 collaborationand review, charts and graphics, data management, data analysis,and Excel and VBA.

  • Covers the changes in the newest version as well as familiartasks, such as creating and editing worksheets, setting upformulas, and performing statistical functions
  • Walks you through the new analysis tools that help make iteasier to visualize data with the click of a mouse
  • Details new ways to explore your data more intuitively and thenanalyze and display your results with a single click

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

Product Details

ISBN-13: 9781118510100
Publisher: Wiley
Publication date: 03/04/2013
Series: For Dummies Series
Pages: 792
Sales rank: 134,291
Product dimensions: 6.90(w) x 9.30(h) x 1.90(d)

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

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

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews