book

Teach Yourself VISUALLY™: Excel® 2007

Name: Teach Yourself VISUALLY™: Excel® 2007
Author: Nancy C. Muir
ISBN: 9780470045954

by Nancy C. Muir

December 2006

Beginner

304 pages

7h 44m

English

Visual

Read now

Unlock full access

Copyright
Praise for Visual Books
Credits
About the Author
Author's Acknowledgments
1. Excel Basics
1.1. An Introduction to Excel1.2. Start and Close Excel1.3. Navigate the Excel Program Window1.4. Understanding the Ribbon, Galleries, and Contextual Tools1.5. Change Views1.6. Customize the Quick Access Toolbar1.7. Display Task Panes1.8. Find Help
2. Workbook Fundamentals
2.1. Start a New Workbook File2.2. Save a Workbook2.3. Publish a Workbook as an Excel Binary Workbook File2.4. Open an Existing Workbook2.5. Close a Workbook2.6. Delete a Workbook2.7. Arrange Workbook Windows2.8. Protect a Workbook2.9. Hide or Show a Worksheet
3. Entering Data
3.1. Enter Data3.2. Turn On Text Wrapping3.3. Resize Columns and Rows3.4. Select Cells3.5. Enter Data with AutoFill3.6. Work with AutoCorrect3.7. Edit Data3.8. Work with Smart Tags3.9. Check Spelling in a Worksheet
4. Working with Worksheets
4.1. Understanding Worksheet Structure4.2. Navigate Worksheets4.3. Name a Worksheet4.4. Add a Worksheet4.5. Delete a Worksheet4.6. Move a Worksheet4.7. Copy a Worksheet4.8. Format Worksheet Tab Color4.9. Protect Worksheet Data
5. Calculating Data with Formulas and Functions
5.1. Understanding Formulas5.2. Create Formulas5.3. Reference Absolute and Relative Cells5.4. Copy Formulas5.5. Name Cells and Ranges5.6. Reference Ranges in Formulas5.7. Reference Cells from Other Worksheets5.8. Understanding Functions5.9. Apply a Function5.10. Total Cells with AutoSum5.11. Check for Formula Errors5.12. Audit a Worksheet for Errors

6. Rearranging Worksheet Data
6.1. Move and Copy Data6.2. Delete Data or Cells6.3. Add Columns and Rows6.4. Delete Columns and Rows6.5. Center Data across Columns6.6. Transpose Columns and Rows6.7. Set Column Width and Row Height6.8. Hide Columns and Rows6.9. Freeze a Column or Row6.10. Split a Worksheet into Panes6.11. Find and Replace Data
7. Formatting Worksheets
7.1. Apply Bold, Italics, and Underlining7.2. Change the Font and Size7.3. Change Number Formats7.4. Increase or Decrease Decimals7.5. Change Data Color7.6. Apply Workbook Themes7.7. Align Cell Data7.8. Rotate Cell Data7.9. Control Text Wrap7.10. Add Borders7.11. Add Background Color to Cells7.12. Assign a Background to a Worksheet7.13. Copy Cell Formatting7.14. Apply a Style7.15. Assign Conditional Formatting
8. Enhancing Worksheets with Graphics
8.1. Insert Image Files8.2. Insert Clip Art8.3. View Clip Art with the Clip Organizer8.4. Download Clip Art from the Web8.5. Draw Shapes8.6. Add a WordArt Object8.7. Move and Resize Objects8.8. Rotate and Flip Objects8.9. Crop a Picture8.10. Add Shadow and 3-D Effects8.11. Format an Object8.12. Group and Ungroup Objects
9. Previewing and Printing
9.1. Add Headers and Footers9.2. Insert Page Breaks9.3. Preview a Worksheet9.4. Set Up Printing Options9.5. Print a Worksheet9.6. Define a Print Area
10. Communicating Information with Charts
10.1. Understanding Excel Charts10.2. Create a Chart with Galleries10.3. Move and Resize Charts10.4. Change the Chart Type10.5. Change the Axes Titles10.6. Manipulate 3-D Charts10.7. Format Chart Objects10.8. Add Chart Objects10.9. Change the Chart Data10.10. Format Charts with Layouts and Styles10.11. Insert SmartArt Charts
11. Analyzing Worksheet Data
11.1. Understanding Database Lists11.2. Create a Database Table11.3. Add Records Using a Data Form11.4. Edit Records11.5. Search for Records11.6. Identify Duplicate Values in a Table11.7. Set Data Validation Rules11.8. Sort Records11.9. Filter Data with AutoFilter11.10. Analyze Data with a PivotTable
12. Using Excel Tools
12.1. Add a Watch Window12.2. Load Add-Ins12.3. Analyze Data with Add-In Tools12.4. Examine Alternatives with Goal Seek12.5. Create Scenarios12.6. Optimize Formulas with Solver
13. Sharing Excel Data
13.1. Link Data13.2. Edit Linked Data13.3. Link Between Worksheets13.4. Embed Objects13.5. Enable Workbook Sharing13.6. Add a Comment13.7. Track and Review Workbook Changes13.8. Merge Workbooks13.9. E-mail a Workbook13.10. Import Data13.11. Export Data
14. Using Excel on the Web
14.1. Add Web Tools to the Quick Access Toolbar14.2. Publish a Workbook as a Web Page14.3. Insert a Hyperlink14.4. Download a Stock Quote14.5. Copy Web Data to a Worksheet14.6. Run a Web Query
15. Improving Excel Efficiency
15.1. Personalize the Excel Program Window15.2. Change the Default Font15.3. Change the Default File Location15.4. Open Files in a Specified Folder Automatically15.5. Set Macro Security15.6. Record a Macro15.7. Create an Excel Template15.8. Apply an Excel Template

Overview

Are you a visual learner? Do you prefer instructions that show you how to do something - and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including:

* Using the Ribbon and galleries

* Entering data and resizing columns

* Applying formulas and functions

* Formatting worksheets

* Adding clip art and 3D effects

* Interpreting data with charts

* Helpful sidebars offer practical tips and tricks

* Succinct explanations walk you through step by step

* Full-color screen shots demonstrate each task

* Two-page lessons break big topics into bite-sized modules

Note: The ebook version does not provide access to the companion files.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Microsoft® Office Excel® 2007 Plain & Simple

Publisher Resources

ISBN: 9780470045954Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills