Home > Store

Excel 2013 Absolute Beginner's Guide

Register your product to gain access to bonus material or receive a coupon.

Excel 2013 Absolute Beginner's Guide

eBook (Watermarked)

  • Your Price: $15.99
  • List Price: $19.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.


  • Copyright 2013
  • Dimensions: 7" x 9-1/8"
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-13-335395-8
  • ISBN-13: 978-0-13-335395-2

Make the most of Excel 2013–without becoming a technical expert! This book is the fastest way to master Excel…use it to build powerful, trustworthy, easy-to-understand workbooks…discover hidden patterns and make better decisions…visualize data so everyone understands it…share and present workbooks on the web, tablets, anywhere! Even if you’ve never used Excel before, you’ll learn how to do what you want, one incredibly clear and easy step at a time. Excel has never, ever been this simple!

Who knew how simple Excel 2013 could be?

This is the easiest, most practical beginner’s guide to using Microsoft’s incredibly powerful new Excel 2013 spreadsheet program…simple, reliable instructions for doing everything you really want to do! Here’s a small sample of what you’ll learn:

  • Quickly create, edit, and format workbooks
  • Enter formulas and use functions effectively
  • Enter data more rapidly, easily, consistently, and accurately
  • Master powerful ways to sort, filter, consolidate, or group data
  • Visualize information through great charts, PivotTables, and Sparklines
  • Illustrate workbooks with images, shapes, and SmartArt
  • Explore and analyze data more easily with Excel 2013’s amazing new Power View
  • Share, print, present, and secure your workbooks
  • Store your workbooks online with SkyDrive
  • Work with macros
  • Build immense power into worksheet cells with UDFs

Sample Content

Table of Contents


Who Should Read This Book    3

How This Book Is Organized    3

Downloading the Example Files    3

Conventions Used In This Book    4

Special Elements    4

1  Understanding the Microsoft Excel Interface    5

Taking a Closer Look at the Excel Window    6

Customizing the Excel Window    12

Moving Around and Making Selections on a Sheet    19

Installing Optional Components    21

2  Working with Workbooks, Sheets, Rows, Columns, and Cells    27

Managing Workbooks    28

Using Templates to Quickly Create New Workbooks    33

Working with Sheets and Tabs    36

Working with Rows and Columns    40

Working with Cells    43

3  Getting Data onto a Sheet    47

Types of Data You Enter into Excel    48

Entering Different Types of Data into a Cell    48

Controlling the Next Cell Selection    50

Using Copy, Cut, Paste, Paste Special to Enter Data    52

Using Text to Columns to Separate Data in a Single Column    54

Inserting Symbols and Equations into a Cell    58

Using Web Queries to Get Data onto a Sheet    59

Using Series to Quickly Fill a Range    60

Editing Data    62

Working with Tables    64

Fixing Numbers Stored as Text    67

Spellchecking Your Sheet    69

Finding Data on Your Sheet    69

Using Data Validation to Limit Data Entry in a Cell    71

4  Formatting Sheets and Cells    75

Adjusting Row Heights and Column Widths    76

Changing the Font Settings of a Cell    77

Aligning Text in a Cell    79

Reflowing Text in a Paragraph    83

Applying Number Formats with Format Cells    85

Creating a Custom Format    88

When Cell Formatting Doesn’t Seem to Be Working Right    95

The Number Group on the Ribbon    95

Adding a Border Around a Range    96

Coloring the Inside of a Cell    98

Creating Hyperlinks    99

Quick Formatting with the Format Painter    101

Dynamic Cell Formatting with Conditional Formatting    101

Using Cell Styles to Quickly Apply Formatting    109

Using Themes to Ensure Uniformity in Design    109

5  Using Formulas    113

The Importance of Laying Out Data Properly    114

Adjusting Calculation Settings    114

Viewing Formulas Versus Values    115

Entering a Formula into a Cell    116

Three Ways of Entering a Formula’s Cell References    118

Relative Versus Absolute Formulas    118

Using a Cell on Another Sheet in a Formula    119

Using R1C1 Notation to Reference Cells    119

Using F4 to Change the Cell Referencing    121

Mathematical Operators    122

Copying a Formula to Another Cell    123

Using Names to Simplify References    125

Inserting Formulas into Tables    128

Using Table Names in Table Formulas    129

Writing Table Formulas Outside the Table    130

Using Array Formulas    132

Converting Formulas to Values    136

Troubleshooting Formulas    137

6  Using Functions    143

Breaking Down a Function    144

Finding Functions    144

Entering Functions Using the Function Arguments Dialog Box    146

Entering Functions Using In-Cell Tips    147

Using the AutoSum Button    148

Using Lookup Functions to Match a Value and Return Another    152

SUMIFS    159


Logical Functions    162

Nested IF Statements    164

IFERROR    165

Date and Time Functions    166

Troubleshooting Dates and Times Stored as Strings    172

Goal Seek    173

Using the Function Arguments Dialog Box to Troubleshoot Formulas    174

7  Sorting Data    177

Preparing Data    178

Opening the Sort Dialog Box    178

Sorting by Values    178

Sorting by Color or Icon    180

Using the Quick Sort Buttons    182

Quick Sorting Multiple Columns    182

Randomly Sorting Data    183

Sorting with a Custom Sequence    184

Rearranging Columns Using the Sort Dialog Box    186

Rearranging Columns Using the Mouse    186

Fixing Sort Problems    187

8  Filtering and Consolidating Data    189

Preparing Data    190

Applying a Filter to a Data Set    190

Clearing a Filter    191

Reapplying a Filter    192

Turning Filtering On for One Column    192

Filtering for Listed Items    192

Filtering the Grouped Dates Listing    193

Using the Search Function to Filter for or Exclude Items    195

Using the Search Function on Grouped Dates    196

Using Text, Number, and Date Special Filters    198

Filtering by Color or Icon    200

Filtering by Selection    200

Allowing Filtering on a Protected Sheet    201

Using the Advanced Filter Option    202

Removing Duplicates from a Data Set    207

Consolidating Data    208

9  Distributing and Printing a Workbook     213

Using Cell Comments to Add Notes to Cells    214

Allowing Multiple Users to Edit a Workbook at the Same Time    216

Hiding and Unhiding Sheets    217

Locking Rows or Columns in Place    218

Creating Custom Views of Your Data    219

Configuring the Page Setup    .220

Creating a Custom Header or Footer    222

Using Page Break Preview to Set Page Breaks    225

Printing Sheets    226

Protecting Your Workbook from Unwanted Changes    227

Protecting the Data on a Sheet    228

Preventing Changes by Marking a File as Final    230

Restricting Access Using IRM    230

Certifying a Workbook with a Digital Signature    230

Sharing Files Between Excel Versions    231

Removing Hidden or Confidential Information    231

Recovering Lost Changes    232

Sending an Excel File as an Attachment    233

Sharing a File Online    234

10  Subtotals and Grouping    235

Using the SUBTOTAL Function    236

Summarizing Data Using the Subtotal Tool    237

Copying the Subtotals to a New Location    240

Formatting the Subtotals    241

Applying Different Subtotal Function Types    241

Combining Multiple Subtotal Results to One Row    243

Subtotaling by Multiple Columns    245

Sorting Subtotals    246

Adding Space Between Subtotaled Groups    246

Grouping and Outlining Rows and Columns    249

11  Creating Charts and Sparklines    253

Preparing Data    254

Elements of a Chart    254

Types of Charts    256

Adding a Chart to a Sheet    258

Adding, Removing, and Formatting Chart Elements    262

Editing and Formatting a Chart Title    262

Changing the Display Units in an Axis    263

Applying Chart Styles and Colors    264

Applying Chart Layouts    265

Moving or Resizing a Chart    265

Switching Rows and Columns    266

Changing an Existing Chart’s Type    266

Creating a Chart with Multiple Chart Types    266

Updating Chart Data    268

Creating Stock Charts    269

Creating Bubble Charts    269

Pie Chart Issue: Small Slices    270

Adding Sparklines to Data    272

Creating a Chart Using a User-Created Template    275

12  PivotTables and Slicers    277

Preparing Data for Use in a PivotTable    278

PivotTable Limitations    279

PivotTable Compatibility    279

PivotTable Field List    280

Creating a PivotTable    281

Changing How a PivotTable Appears on a Sheet    286

PivotTable Sorting    287

Expanding and Collapsing Fields    289

Viewing the Records Used to Calculate a Value    290

Grouping Dates    290

Filtering Data in a PivotTable    292

Creating a Calculated Field    296

Hiding Totals    298

Formatting Values    298

Slicers    299

13  Using Power View to Create Reports    301

Power View Requirements    302

Creating Reports    302

Inserting and Formatting a Report Title    305

Changing Data Visualizations    305

Combining Multiple Visualizations    309

Changing Colors    310

Sorting    311

Filtering    312

Sharing Power View Reports    315

14  Inserting SmartArt, WordArt, and Pictures    317

Working with SmartArt    318

Inserting WordArt    325

Inserting Pictures    326

15  An Introduction to Using Macros and UDFs    333

Enabling VBA Security    334

Developer Tab    335

Introduction to the Visual Basic Editor    336

Understanding How the Macro Recorder Works    338

Recording a Macro    342

Running a Macro    343

User-Defined Functions    347

16  Introducing the Excel Web App    355

Requirements    356

Acquiring a Microsoft Account    356

Uploading and Downloading Workbooks    358

Opening a Workbook    360

Creating a New Workbook Online    361

Saving a File to Your Local Drive    362

Sharing a Folder or Workbook    362

Interacting with a Sheet Online    366

Configuring Browser View Options    367

Setting Up a Survey    369

Index    373


Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020