+612 9045 4394
Excel 2013 All-in-one For Dummies : For Dummies - Greg Harvey

Excel 2013 All-in-one For Dummies

For Dummies


Published: 22nd February 2013
Ships: 15 business days
15 business days
RRP $49.95

eBook View Product

Published: 15th February 2013
Format: ePUB

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.

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.



by PowerReviews

(based on 1 review)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 1 customer

Displaying review 1

Back to top




from 39995

About Me Casual Reader

Verified Buyer


  • Easy To Read
  • Informative


    Best Uses

    • Reference


    Displaying review 1

    Back to top

    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

    ISBN: 9781118510100
    ISBN-10: 1118510100
    Series: For Dummies
    Audience: General
    Format: Paperback
    Language: English
    Number Of Pages: 792
    Published: 22nd February 2013
    Publisher: John Wiley & Sons Inc
    Country of Publication: US
    Dimensions (cm): 23.8 x 19.1  x 3.9
    Weight (kg): 1.06
    Edition Number: 1