Skip to product information
1 of 1

Excel 2013 All-In-One for Dummies

Excel 2013 All-In-One for Dummies

Marc Notes: 8 books in 1: Excel basics, Worksheet design, Formulas and functions, Worksheet collaboration and review, Charts and graphics, Data management, Data analysis, Macros and VBA--Cover.;Includes index.;Due to publisher...

Regular price $44.99
Sale price $44.99 Regular price
Sale Sold out
Shipping calculated at checkout.

Vendor

For Dummies

Type

Print Books

Binding

Spiral Binding

People are viewing this right now

View full details

Marc Notes:
8 books in 1: Excel basics, Worksheet design, Formulas and functions, Worksheet collaboration and review, Charts and graphics, Data management, Data analysis, Macros and VBA--Cover.;Includes index.;Due to publisher license, access is restricted to authorised GRAIL clients only. Please contact GRAIL staff.;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 mouseDetails new ways to explore your data more intuitively and then analyze and display your results with a single clickWhether 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.;EBSCO complete collection.

Biographical Note:

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



Jacket Description/Back:

8 books in 1

  • Excel Basics
  • Worksheet Design
  • Formulas and Functions
  • Worksheet Collaboration and Review
  • Charts and Graphics
  • Data Management
  • Data Analysis
  • Macros and VBA

Excel newbie or expert in older versions -- here's the reference you need for Excel 2013!

Understanding how to use the many features of Excel 2013 is only half the battle. The other half is understanding what these features can do for you. So whether you're starting out or upgrading, using Excel on your desktop or tablet, this all-in-one guide covers what you need to know to master worksheets, formulas, functions, charts, even data analysis.

  • For beginners -- start out right with an entire minibook devoted to mastering Excel basics
  • Working with worksheets -- learn to set up, edit, manage, and dress up worksheets and print reports
  • Get functional -- explore formulas and functions from basic to complex and put them to work
  • Team effort -- share and collaborate on worksheets while keeping your data secure
  • Make it look great -- present your data with impressive charts and graphs that help interpret the information
  • Manage your data -- take advantage of Excel's tools for managing large amounts of data and filtering out the information you need
  • Look ahead -- use Excel's computational abilities to forecast and predict possible future outcomes
  • Extend Excel -- install Apps for Office, use COM add-ins, and write macros and custom functions with the Visual Basic Editor

Open the book and find:

  • How to build your own workbook templates
  • Instructions for using Excel on a touchscreen
  • All the ways to enter data
  • Tips for preventing formula errors
  • Hints for sharing data with other Office 2013 programs
  • Graphics you can include in your charts
  • How to query external data sources
  • A guide to PowerPivot and Power View add-ins


Publisher Marketing:

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.





Author: Harvey, Greg
Publisher: For Dummies
Binding: Paperback
Pub Date: 2013-03-04
BISAC: Computers|Business & Productivity Software|Spreadsheets
Subjects: Electronic spreadsheets
Weight: 2.15 lbs
ISBN: 9781118510100
ASIN: -
SKU: SP-9781118510100

Shipping Information: Free delivery on all orders over $45, arrives within 3–5 days, you can also choose expedited shipping

Returns Information: 90-day return policy begins once the item ships, we cover the round-trip shipping costs for returns caused by quality issues (Return Address: 8039 S 192nd ST, STE 120, Kent, WA, 98032)

Exchanges Information: The new order will be processed once the old order is in transit back to the warehouse. Customers will only be charged for the old order if it has not been returned to the warehouse within 14 days

After-Sales Service: Simply email your requirements to support@westbindery.com, and we will process them as soon as possible upon receipt

Customer Service: Online 24/7, we recommend contacting us via email as a first choice, though you can also chat with us online

Value-added service: If you are giving the books as a gift, we also offer gift-wrapping services

Lifetime Warranty: At West Bindery, we are committed to providing you with nothing but the best. We want you to be completely satisfied with your purchase. That's why all West Bindery books come standard with a lifetime warranty

Customer Reviews

Be the first to write a review
0%
(0)
0%
(0)
0%
(0)
0%
(0)
0%
(0)

Q: How do I track my order?

A: Order Tracking InformationOnce your order has been placed and processed, you will receive a confirmation email containing your order details. This email will include:

  • A tracking number
  • A link to our tracking page

How to Track Your OrderClick on the tracking number link in your confirmation email.
Important Notes: Tracking information may not be immediately available after you place your order. It can take up to 36 hours for the tracking number to activate in our system. If no updates are visible right away, please check back later.


Q: What if my package gets lost or arrives damaged?

A: Lost packages: At West Bindery, we strive to ensure every order reaches you in perfect condition. In the event that your order is lost during transit, please reach out to our customer support team here with your order number and any relevant details.
Damaged packages: Please report to our customer support team here within 24 hours of receiving the order and include photos of the damaged items or package. We will review the provided documentation and, if necessary, arrange for a replacement or issue a refund.


Q: Can I change my shipping address after my order is submitted?

A: Unfortunately, we’re unable to change the shipping address once your order has been submitted. If you’ve entered the wrong address, please contact us at support@westbindery.com as soon as possible—we’ll do our best to help before your order ships.


Q: What happens if I accidentally ordered multiple copies of the same book?

A: If you have accidentally ordered multiple copies of the same book, you can return the excess copies by following our return process. Please ensure the items are in their original condition and returned within the 90-day window from the shipping date. Upon receipt and inspection of the items, if the refund is approved, it will be processed on your original payment method. Visit our return center and follow the provided instructions to ensure a smooth and timely return.

Q: I received an incomplete order, what should I do?

A: How to Report an Incomplete Order: To help us address your concern, please follow these steps:

  1. Email our support team at support@westbindery.com with:Your order numberThe email address associated with your order
  2. Let us know which item(s) is/are missing from your order.

What Happens Next: Our team will verify your order and investigate the issue. We will contact you within 1 business day with an update or resolution, including sending the missing item(s) or other suitable options.

Recently Viewed