Excel 2010 Just the Steps For Dummies

by Koers, Diane

• ISBN13: 9780470501641
• ISBN10: 0470501642
• Edition: 1st
• Format: Paperback
• Copyright: 2010-06-01
• Publisher: For Dummies

Summary

Pick your Excel task, find it fast, and get it done with Just the Steps!If you want to see how to do a particular Excel task, this is the perfect book. Each page includes step-by-step instruction in one column and illustrations and screenshots in the other column, so you have all the information you need in one placeno flipping pages!Improve your Excel skills with just the steps for entering spreadsheet data, building formulas, protecting excel data, formatting cells, designing spreadsheets with graphics, managing workbooks, changing worksheet values, sorting and filtering data, creating charts, creating PivotTables, building macros, integrating Excel into other Office programs, andwhew!still more. Explains essentials tasks for Excel 2010, the spreadsheet application that is part of the Microsoft Office 2010 suite Shows you just the steps for numerous Excel tasks using an easy-to-follow, two-column page layout, with step-by-step instruction on one side and illustrations and screenshots on the other Covers entering spreadsheet data, building formulas, protecting excel data, formatting cells, designing spreadsheets with graphics, managing workbooks, changing worksheet values, sorting and filtering data, creating charts, creating PivotTables, and building macros Walks you step by step through collaborating in Excel and integrating or using Excel with Word, PowerPoint, and AccessMake your tasks easier, improve your Excel skills, and get better results with this step-by-step guide.

Author Biography

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

Table of Contents

Introduction

Putting Excel to Work

Working with Excel Files

Entering Spreadsheet Data

Building Formulas

Using Excel Functions

Protecting Excel Data

Sprucing Up Your Spreadsheets

Formatting Cells

Applying Additional Formatting Options

Designing with Graphics

Managing Workbooks

Viewing Data in Different Ways

Changing Worksheet Views

Sorting Data

Creating Charts

Printing Workbooks

Saving Time with Excel Tools

Analyzing Data with Excel

Working with Outlines

Filtering Data

Creating PivotTables

Building Simple Macros

Utilizing Excel with Other People and Applications

Collaborating in Excel

Integrating Excel into Word

Blending Excel and PowerPoint

Using Excel with Access

Practical Applications for Excel

Creating a Commission Calculator

Tracking Medical Expenses

Index

Table of Contents provided by Publisher. All Rights Reserved.