book

Excel 2007 for Starters: The Missing Manual

Name: Excel 2007 for Starters: The Missing Manual
Author: Matthew MacDonald
ISBN: 9781491909423

by Matthew MacDonald

January 2007

Beginner

352 pages

8h 26m

English

O'Reilly Media, Inc.

Read now

Unlock full access

Excel 2007 for Starters: The Missing Manual
The Missing Credits
About the AuthorAbout the Creative TeamAcknowledgementsThe Missing Manual Series
Introduction
What You Can Do with ExcelExcel’s New FaceThe RibbonUsing the Ribbon with the KeyboardThe Office MenuThe Quick Access ToolbarExcel’s New FeaturesAbout This BookAbout the OutlineAbout → These → ArrowsContextual tabsDrop-down buttonsDialog box launchersAbout Shortcut KeysAbout ClickingExamplesAbout MissingManuals.comSafari® Enabled
I. WORKSHEET BASICS
1. Creating and Navigating Worksheets
1.1. Creating a Basic Worksheet1.1.1. Starting a New Workbook1.1.2. Adding the Column Titles1.1.3. Adding Data1.2. Editing Data1.3. Navigating in Excel1.3.1. The Tabs of the Ribbon1.3.2. The Formula Bar1.3.3. The Status Bar1.3.4. Excel Options1.4. Saving Files1.4.1. The Excel 2007 File Format1.4.2. Saving Your Spreadsheet in Older Formats1.4.3. Saving Your Spreadsheet As a PDF1.4.4. Disaster Recovery1.5. Opening Files1.5.1. Opening Multiple Spreadsheets at Once
2. Adding Information to Worksheets
2.1. Adding Different Types of Data2.1.1. Controlling Your Data Types2.1.1.1. How Excel decides your data is text2.1.1.2. How Excel decides your data is numeric2.1.1.3. How Excel decides your data is a date or time2.2. Quick Ways to Add Data2.2.1. AutoComplete2.2.2. AutoCorrect2.2.3. AutoFill2.2.3.1. Custom AutoFill lists2.2.4. AutoFit2.2.5. Undo and Redo
3. Moving Data Around a Worksheet
3.1. Selecting Cells3.1.1. Making Continuous Range Selections3.1.2. Making Non-Contiguous Selections3.1.3. Automatically Selecting Your Data3.1.4. Making Selections with the Keyboard3.2. Moving Cells Around3.2.1. A Simple Cut-and-Paste or Copy-and-Paste3.2.2. A Fancy Cut-and-Paste or Copy-and-Paste3.2.3. The Clipboard3.2.4. Special Pasting3.3. Adding and Moving Columns or Rows3.3.1. Inserting Columns3.3.2. Inserting Rows3.3.3. Inserting Copied or Cut Cells3.3.4. Deleting Columns and Rows
4. Managing Worksheets and Workbooks
4.1. Worksheets and Workbooks4.1.1. Adding, Removing, and Hiding Worksheets4.1.2. Naming and Rearranging Worksheets4.2. Find and Replace4.2.1. The Basic Find4.2.2. Find All4.2.3. More Advanced Searches4.2.4. Finding Formatted Cells4.2.5. Finding and Replacing Values4.3. Spell Check4.3.1. Spell Checking Options
5. Formatting Cells
5.1. Formatting Cell Values5.1.1. Formatting Numbers5.1.1.1. General5.1.1.2. Number5.1.1.3. Currency5.1.1.4. Accounting5.1.1.5. Percentage5.1.1.6. Fraction5.1.1.7. Scientific5.1.1.8. Text5.1.2. Formatting Dates and Times5.1.3. Special Formats for Special Numbers5.2. Formatting Cell Appearance5.2.1. Alignment and Orientation5.2.2. Fonts and Color5.2.2.1. Special characters5.2.3. Borders and Fills5.2.4. Drawing Borders by Hand5.3. Smart Ways to Apply Formatting5.3.1. The Format Painter5.3.2. Styles and Themes5.3.2.1. Themes: A package of styles
6. Viewing and Printing Worksheets
6.1. Controlling Your View6.1.1. Zooming6.1.2. Viewing Distant Parts of a Spreadsheet at Once6.1.3. Freezing Columns or Rows6.1.4. Hiding Data6.1.5. Saving View Settings6.2. Printing6.2.1. How to Print an Excel File6.2.2. Quick Printing6.2.3. Previewing Your Printout6.2.4. Creating Headers and Footers6.2.5. Customizing Print Settings6.2.5.1. Margins6.2.5.2. Paper size and orientation6.2.5.3. Sheet settings6.3. Controlling Pagination6.3.1. Page Breaks6.3.2. Scaling6.3.3. Page Break Preview: A Bird’s-Eye View of Your Worksheet

II. WORKSHEET POWER
7. Building Basic Formulas
7.1. Creating a Basic Formula7.1.1. Excel’s Order of Operations7.1.2. Cell References7.1.3. How Excel Formats Cells That Contain Cell References7.1.4. Functions7.1.4.1. Using a function in a formula7.1.4.2. Using cell references with a function7.1.4.3. Using cell ranges with a function7.1.5. Formula Errors7.1.6. Logical Operators7.2. Formula Shortcuts7.2.1. Point-and-Click Formula Creation7.2.2. Point-and-Click Formula Editing7.2.3. The Formulas Tab7.2.4. Using the Insert Function Button to Quickly Find and Insert Functions7.3. Copying Formulas7.3.1. Absolute Cell References7.3.2. Partially Fixed References
8. Tables: List Management Made Easy
8.1. The Basics of Tables8.1.1. Creating a Table8.1.2. Formatting a Table8.1.3. Editing a Table8.1.4. Selecting Parts of a Table8.2. Sorting and Filtering a Table8.2.1. Applying a Simple Sort Order8.2.2. Sorting with Multiple Criteria8.2.3. Filtering with the List of Values8.2.4. Creating Smarter Filters8.2.4.1. Filtering dates8.2.4.2. Filtering numbers8.2.4.3. Filtering text
9. Creating Basic Charts
9.1. Charting 1019.1.1. Embedded and Standalone Charts9.1.2. Creating a Chart with the Ribbon9.1.3. The Chart Tools Ribbon Tabs9.2. Basic Tasks with Charts9.2.1. Moving and Resizing a Chart9.2.2. Creating a Standalone Chart9.2.3. Editing and Adding to Chart Data9.2.4. Changing the Chart Type9.2.5. Printing Charts9.2.5.1. Embedded charts9.2.5.2. Standalone charts9.3. Practical Charting9.3.1. Charts with Multiple Series of Numbers9.3.2. Controlling the Data Excel Plots on the X-Axis9.3.3. Non-Contiguous Chart Ranges9.3.4. Changing the Order of Your Data Series9.3.5. Changing the Way Excel Plots Blank Values9.4. Chart Types9.4.1. Column9.4.2. Bar9.4.3. Line9.4.4. Pie9.4.5. Area
A. Customizing The Quick Access Toolbar
A.1. The Quick Access ToolbarA.1.1. Adding ButtonsA.1.2. Customizing Specific Workbooks
Index
About the Author
Colophon
Copyright

Overview

Fast-paced and easy to use, this new book teaches you the basics of Excel 2007 so you can start using the program right away. This concise guide shows readers how to work with Excel's most useful features and its completely redesigned interface. With clear explanations, step-by-step instructions, lots of illustrations, and plenty of timesaving advice, Excel 2007 for Starters: The Missing Manual will quickly teach you to:

Build spreadsheets
Add and format information
Print reports
Create charts and graphics
Use basic formulas and functions
and more

The new Excel is radically different from previous versions. Over the years, Excel has grown in power, sophistication and capability, but its once-simple toolbar has been packed with so many features that not even the pros could find them all. For Excel 2007, Microsoft redesigned the user interface completely, adding a tabbed toolbar that makes every feature easy to locate.

Unfortunately, Microsoft's documentation is as scant as ever, so even if you find the features you need, you still may not know what to do with them. But with this book, you can breeze through the new user interface and its timesaving features in no time. Excel 2007 for Starters: The Missing Manual is the perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.

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

Publisher Resources

ISBN: 0596528329Errata Page

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills