Master VISUALLY Excel 2010

The complete visual reference on Excel basics

Aimed at visual learners who are seeking an all-in-one reference that provides in-depth coveage of Excel from a visual viewpoint, this resource delves into all the newest features of Excel 2010. You’ll explore Excel with helpful step-by-step instructions that show you, rather than tell you, how to navigate Excel, work with PivotTables and PivotCharts, use macros to streamline work, and collaborate with other users in one document.

• This two-color guide features screen shots with specific, numbered instructions so you can learn the actions you need to perform in order to execute a wide range of Excel 2010 tasks.
• Features beginning, intermediate andadvanced visual coverage of Excel 2010
• Shows you how to enter information into a worksheet, use formulas and functions, find and control formulaic errors, and much more
• Presents more than 1,000 screen shots that demonstrate step-by-step instructions of numerous Excel 2010 tasks

You’re encouraged to move at your own pace as you acquire confidence and proficiency with the newest version of Excel.

Table of Contents

PART I: EXCEL BASICS
Chapter 1: Getting Started with Excel
Chapter 2: Managing Workbooks
Chapter 3: Formatting Cells

PART II: DESIGNING WORKSHEETS
Chapter 4: Editing and Proofreading Worksheets
Chapter 5: Adjusting Worksheets
Chapter 6: Managing the Workbook Structure
Chapter 7: Working with Views
Chapter 8: Printing Worksheet Information

PART III: CALCULATING DATA
Chapter 9: Performing Basic Math
Chapter 10: Working with Common Formulas
Chapter 11: Mastering Date and Time Formulas
Chapter 12: Working with Financial Formulas
Chapter 13: Working with Commonly Used Lookup Formulas
Chapter 14: Applying Reference, Information, and Text Formulas
Chapter 15: Working with Logical and Error Trapping Formulas
Chapter 16: Analyzing Tabular Information with Functions
Chapter 17: Analyzing Formulas and Functions

PART IV: MASTERING EXCEL CHARTS
Chapter 18: Discovering Chart Basics
Chapter 19: Changing Chart Layout Details

PART V: ANALYZING DATA
Chapter 20: Working with Graphic Elements
Chapter 21: Working with Tables
Chapter 22: Summarizing Data with PivotTables and PivotCharts
Chapter 23: Visually Analyzing Data
Chapter 24: Linking and Consolidating Worksheets
Chapter 25: Performing What-If Analysis
Chapter 26: Performing Advanced Statistical Analyses

PART VI: CUSTOMIZING THE EXCEL ENVIRONMENT
Chapter 27: Working with Macros
Chapter 28: Customizing the Excel Environment

PART VII: USING EXCEL IN COLLABORATION WITH OTHERS
Chapter 29: Using Workbooks in a Multiuser Environment
Chapter 30: Sharing Excel Data with Other Programs