Book description
Reinforce your understanding of Excel with these Workbook exercises
Boost your knowledge of important Excel tasks by putting your skills to work in real-world situations. The For Dummies Workbook format provides more than 100 exercises that help you create actual results with Excel so you can gain proficiency.
Perfect for students, people learning Excel on their own, and financial professionals who must plan and execute complex projects in Excel, Excel 2010 Workbook For Dummies helps you discover all the ways this program can work for you.
Excel is the world's most popular number-crunching program, and For Dummies books are the most popular guides to Excel
The Workbook approach offers practical application, with more than 100 exercises to work through and plenty of step-by-step guidance
This guide covers the new features of Excel 2010, includes a section on creating graphic displays of information, and offers ideas for financial planners
Also provides exercises on using formulas and functions, managing and securing data, and performing data analysis
A companion CD-ROM includes screen shots and practice materials
Excel 2010 Workbook For Dummies helps you get comfortable with Excel so you can take advantage of all it has to offer.
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Table of contents
- Copyright
- About the Author
- Author's Acknowledgments
- Publisher's Acknowledgments
- Introduction
-
I. Creating Spreadsheets
- 1. Getting Familiar with the Excel 2010 Interface
- 2. Entering the Spreadsheet Data
- 3. Formatting the Spreadsheet
- 4. Printing Spreadsheet Reports
-
5. Modifying the Spreadsheet
- 5.1. Finding and Identifying the Region That Needs Editing
- 5.2. Selecting the Ranges to Edit
- 5.3. Editing Data Entries
- 5.4. Catching Errors with Text to Speech
- 5.5. Deleting and Inserting Data and Cells
- 5.6. Moving and Copying Data and Cells
- 5.7. Using Notes in the Spreadsheet
- 5.8. Using Find and Replace and Spell Checking
- 5.9. Group Editing
- II. Using Formulas and Functions
- III. Working with Graphics
- IV. Managing and Securing Data
- V. Doing Data Analysis
- VI. Macros and Visual Basic for Applications
-
VII. The Part of Tens
-
23. Top Ten Features in Excel 2010
- 23.1. The Excel Ribbon and Backstage View
- 23.2. Conditional Formatting
- 23.3. Pivot Table Filtering with Slicers
- 23.4. Formatting and Editing from the Home Tab
- 23.5. Charts Directly from the Insert Tab
- 23.6. Format As Table
- 23.7. The Zoom Slider on the Status Bar
- 23.8. Page Layout View
- 23.9. Style Galleries
- 23.10. Live Preview
-
24. Top Ten Tips for Using Excel Like a Pro
- 24.1. Generating New Workbooks from Templates
- 24.2. Organizing Spreadsheet Data on Different Worksheets
- 24.3. Creating Data Series with AutoFill
- 24.4. Using Range Names
- 24.5. Freezing Column and Row Headings
- 24.6. Preventing Data Entry Errors with Data Validation
- 24.7. Trapping Error Values in Their Original Formulas
- 24.8. Saving Memory by Using Array Formulas
- 24.9. Controlling the Display of Data in Tables through Outlines
- 24.10. Using View Side by Side to Work with Two Workbooks
- A. Comparing Worksheets Side by Side
- B. About the CD
- C. Table of Exercises
-
23. Top Ten Features in Excel 2010
Product information
- Title: Excel® 2010 Workbook for Dummies®
- Author(s):
- Release date: September 2010
- Publisher(s): For Dummies
- ISBN: 9780470489604
You might also like
book
Special Edition Using Microsoft® Office Excel® 2007
Special Edition Using Microsoft Office Excel 2007 will ease the upgrade path to the lastest version …
book
Special Edition Using® Microsoft® Office Outlook® 2003
This is the ONLY book you need to achieve maximum productivity when using this messaging and …
book
Special Edition Using® Microsoft® Office Excel 2003
Does your life play out in a spreadsheet? Are numbers in columns and rows what make …
book
Microsoft® Office Outlook® 2003 Inside Out
Take your Microsoft Outlook experience to the next level! This supremely organized reference packs hundreds of …