Excel 2013 Bible

Excel^® 2013 Bible

Table of Contents

Introduction

Part I: Getting Started with Excel

Chapter 1: Introducing Excel

Identifying What Excel Is Good For

Seeing What's New in Excel 2013

Understanding Workbooks and Worksheets

Moving Around a Worksheet

Navigating with your keyboard

Navigating with your mouse

Using the Ribbon

Ribbon tabs

Contextual tabs

Types of commands on the Ribbon

Accessing the Ribbon by using your keyboard

Using Shortcut Menus

Customizing Your Quick Access Toolbar

Working with Dialog Boxes

Navigating dialog boxes

Using tabbed dialog boxes

Using Task Panes

Creating Your First Excel Workbook

Getting started on your worksheet

Filling in the month names

Entering the sales data

Formatting the numbers

Making your worksheet look a bit fancier

Summing the values

Creating a chart

Printing your worksheet

Saving your workbook

Chapter 2: Entering and Editing Worksheet Data

Exploring Data Types

Numeric values

Text entries

Formulas

Entering Text and Values into Your Worksheets

Entering Dates and Times into Your Worksheets

Entering date values

Entering time values

Modifying Cell Contents

Deleting the contents of a cell

Replacing the contents of a cell

Editing the contents of a cell

Learning some handy data-entry techniques

Applying Number Formatting

Using automatic number formatting

Formatting numbers by using the Ribbon

Using shortcut keys to format numbers

Formatting numbers using the Format Cells dialog box

Adding your own custom number formats

Chapter 3: Essential Worksheet ...