Covering everything from Alignment to Zoom, this easy-to-navigate reference provides the answers to all of your Excel questions. You'll find full-color screen shots and illustrations, hundreds of listings, and in-depth explanations of how to use the data analysis tool, create an Excel database, export data, work with formulas and PivotTables, and much more. The book is divided into two parts: the first provides an A-Z reference of each Excel tool and command, the second shows various step-by-step techniques you can use in the real-world.
If you prefer to see what things look like and how to perform a task, instead of just being told, this is your ideal A to Z reference. Part I shows every Excel® 2003 tool and how to use it. Part II provides step-by-step instructions for more than 350 key tasks and techniques. Both are arranged alphabetically and illustrated in full color. It's the ultimate Visual resource?you'll see!
- Each tool and technique illustrated in full color
- Alphabetical listings for easy reference
- Step-by-step instructions for performing dozens of tasks
- A comprehensive guide for visual learners
A Visual guide to
- Identifying and using Excel tools and commands
- Working with chart elements, axes, and types
- Entering and editing data
- Building formulas and functions
- Creating and managing PivotTables and PivotCharts
- Using templates and creating custom worksheets