Excel 2013 simplified / by Paul McFedries.

Format:

Book

Author/Creator:

McFedries, Paul.

Series:

Simplify it Excel 2013 simplified

Language:

English

Subjects (All):

Business--Computer programs.

Business.

Electronic spreadsheets.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (289 p.)

Edition:

1st edition

Other Title:

Microsoft Excel 2013 simplified

Place of Publication:

Indianapolis, Ind. : Wiley, 2013.

Language Note:

English

System Details:

text file

Summary:

A friendly, visual approach to learning the basics of Excel 2013 As the world's leading spreadsheet program, Excel is a spreadsheet and data analysis tool that is part of the Microsoft Office suite. The new Excel 2013 includes new features and functionalities that require users of older versions to re-learn the application. However, whether you're switching from an earlier version or learning Excel for the first time, this easy-to-follow visual guide gets you going with Excel 2013 quickly and easily. Numbered steps as well as full-color screen shots, concise information, and helpful tips, all contribute to a clear, comfortable learning experience. Covers Excel basics, workbook fundamentals, formatting worksheets and enhancing them with graphics, analyzing data, communicating results with charts and PivotTables, and much more Walks you through using Flash Fill, representing your data in a variety of ways, and maximizing a more interactive interface Demonstrates how to share workbooks, collaborate with others, and embed portions of your spreadsheets on social network pages Excel 2013 Simplified is a quick and easy way to get up to speed on Excel 2013 for both novice users and those upgrading from an earlier version.

Contents:

Microsoft® Excel® 2013 Simplified®

Credits

About the Author

Author's Acknowledgments

How to Use This Book

Table of Contents

CHAPTER 1: Working with Excel

Getting to Know Excel

Start Excel

Tour the Excel Window

Work with the Excel Ribbon

Work with the Excel Galleries

Customize the Quick Access Toolbar

Customize the Ribbon

Change the View

Configure Excel Options

Add Excel to the Windows Taskbar

Quit Excel

CHAPTER 2: Entering Data

Learning the Layout of a Worksheet

Understanding the Types of Data You Can Use

Enter Text into a Cell

Enter a Number into a Cell

Enter a Date or Time into a Cell

Insert a Symbol

Edit Cell Data

Delete Data from a Cell

CHAPTER 3: Working with Ranges

Select a Range

Fill a Range with the Same Data

Fill a Range with a Series of Values

Flash Fill a Range

Move or Copy a Range

Insert a Row or Column

Insert a Cell or Range

Delete Data from a Range

Delete a Range

Hide a Row or Column

Freeze Rows or Columns

Merge Two or More Cells

Transpose Rows and Columns

CHAPTER 4: Working with Range Names

Understanding the Benefits of Using Range Names

Define a Range Name

Use Worksheet Text to Define a Range Name

Navigate a Workbook Using Range Names

Change a Range Name

Delete a Range Name

CHAPTER 5: Formatting Excel Ranges

Change the Font and Font Size

Apply Font Effects

Change the Font Color

Align Text Within a Cell

Center Text Across Multiple Columns

Rotate Text Within a Cell

Add a Background Color to a Range

Apply a Number Format

Change the Number of Decimal Places Displayed

Apply an Auto Format to a Range

Apply a Conditional Format to a Range

Apply a Style to a Range

Change the Column Width

Change the Row Height

Wrap Text Within a Cell.

Add Borders to a Range

CHAPTER 6: Building Formulas

Understanding Excel Formulas

Build a Formula

Understanding Excel Functions

Add a Function to a Formula

Add a Row or Column of Numbers

Build an AutoSum Formula

Add a Range Name to a Formula

Reference Another Worksheet Range in a Formula

Move or Copy a Formula

CHAPTER 7: Manipulating Worksheets

Navigate a Worksheet

Rename a Worksheet

Create a New Worksheet

Move a Worksheet

Copy a Worksheet

Delete a Worksheet

Change the Gridline Color

Toggle Worksheet Gridlines On and Off

Toggle Worksheet Headings On and Off

CHAPTER 8: Dealing with Workbooks

Create a New Blank Workbook

Create a New Workbook from a Template

Save a Workbook

Open a Workbook

Arrange Workbook Windows

Find Text in a Workbook

Replace Text in a Workbook

CHAPTER 9: Formatting Workbooks

Modify the Workbook Colors

Set the Workbook Fonts

Choose Workbook Effects

Apply a Workbook Theme

Add a Workbook Header

Add a Workbook Footer

CHAPTER 10: Working with Tables

Understanding Tables

Get to Know Table Features

Convert a Range to a Table

Select Table Data

Insert a Table Row

Insert a Table Column

Delete a Table Row

Delete a Table Column

Add a Column Subtotal

Convert a Table to a Range

Apply a Table Style

Build a Custom Table Style

CHAPTER 11: Analyzing Data

Sort a Range or Table

Filter a Range or Table

Set Data Validation Rules

Create a Data Table

Summarize Data with Subtotals

Group Related Data

Analyze Data with Goal Seek

Analyze Data with Scenarios

Remove Duplicate Values from a Range or Table

CHAPTER 12: Visualizing Data with Charts

Examine Chart Elements

Understanding Chart Types

Create a Chart

Create a Recommended Chart

Add Chart Titles

Add Data Labels.

Position the Chart Legend

Display Chart Gridlines

Display a Data Table

Change the Chart Layout and Style

Select a Different Chart Type

Change the Chart Source Data

Move or Resize a Chart

CHAPTER 13: Collaborating with Others

Add a Comment to a Cell

Protect a Worksheet's Data

Protect a Workbook's Structure

Share a Workbook with Other Users

Track Workbook Changes

Accept or Reject Workbook Changes

Save a Workbook to Your SkyDrive

Send a Workbook as an E-Mail Attachment

Save Excel Data as a Web Page

Make a Workbook Compatible with Earlier Versions of Excel

Mark Up a Worksheet with a Digital Pen

Collaborate on a Workbook Online

Index.

Notes:

"Step-by-step instructions for easy learning"--Cover.

Includes index.

ISBN:

9781299242449

1299242448

9781118647554

1118647556

OCLC:

834567143