Teach Yourself VISUALLY Excel 2016

Paul McFedries

• Publisher: Visual
• Year: 2015
• Print ISBN: 9781119074731
• eBook ISBN: 9781119074717
• Edition: 1
• Topic: Computer Science
• Subtopic: Desktop Applications
• Index: Computer Science

See your way to Excel spreadsheet stardom with this visual guide

If you're always hearing about the cool things Excel can do, here's your chance to see how to do them! Teach Yourself Visually Excel offers you a straightforward visual approach to working with the newest version of the world's leading spreadsheet program. Packed with visually rich tutorials and step-by-step instructions that will help you take your Excel skills to new heights, this friendly and approachable guide will have you creating, editing, and manipulating Excel spreadsheets in no time!

Excel can seem daunting, but with Teach Yourself Visually Excel, you'll quickly and painlessly learn how to perform dozens of tasks, including creating spreadsheets and charts, filtering and sorting data, working with PivotTables, and so much more. Covering the latest additions and changes to the newest version of Excel, a series of easy-to-follow, full-color tutorials helps you to excel at working with Excel!

• Tutorials and step-by-step screenshots make lessons easy to follow and understand
• Helps you grasp the basic functions of Excel—and beyond
• Walks you through Excel s new features
• Clearly demonstrates how to organize, present, analyze, and chart data with Excel

Whether you've never used Excel or just need to brush up on its new features, Teach Yourself Visually Excel will be the dog-eared resource you'll turn to again and again.

CHAPTER 1

Working with Ranges

In Excel, a range is a collection of two or more cells that you work with as a group rather than separately. This enables you to fill the range with values, move or copy the range, sort the range data, and insert and delete ranges. You learn these and other range techniques in this chapter.

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

Select and Enter Data Using Touch Gestures

Select a Range

To work with a range in Excel, you must first select the cells that you want to include in the range. After you select the range, you can fill it with data, move it to another part of the worksheet, format the cells, and perform the other range-related tasks that you learn about in this chapter.

You can select a range as a rectangular group of cells, as a collection of individual cells, or as an entire row or column.

Select a Range

Select a Rectangular Range

Position the mouse (

) over the first cell you want to include in the range.

Click and drag the

over the cells that you want to include in the range.

Excel selects the cells.

Release the mouse button.

Select a Range of Indi...

Table of contents

• Cover
• Title Page
• Table of Contents
• Chapter 1: Working with Ranges
• Chapter 2: Working with Range Names
• Chapter 3: Formatting Excel Ranges
• Chapter 4: Building Formulas
• Chapter 5: Manipulating Worksheets
• Chapter 6: Dealing with Workbooks
• Chapter 7: Formatting Workbooks
• Chapter 8: Importing Data into Excel
• Chapter 9: Printing Workbooks
• Chapter 10: Working with Tables
• Chapter 11: Analyzing Data
• Chapter 12: Visualizing Data with Charts
• Chapter 13: Adding Worksheet Graphics
• Chapter 14: Collaborating with Others
• End User License Agreement