Errata

View Errata for this book

Submit your own Errata
Excel 2007: The Missing Manual

Excel 2007: The Missing Manual

By Matthew MacDonald

Missing CD-ROM

Download example files for all chapters here.

Chapter 1

Learn about new .xlsx file format

Free Add-in for Older Versions of Excel

Excel Viewer

Save as PDF Add-in

Adobe Reader

Saving Excel Document as XPS File

Bad Columns

Good Columns

Simple Expenses

Chapter 2

Data Type Alignment

Different Dates

Chapter 4

Tables on Separate Worksheets

Two Tables

Chapter 5

Floating Point Explanation

Alignment Options

Formatting Cell Values

Gradient Fill

One Number Three Ways

Rotated and Merged

Chapter 6

Conditional Formatting

Fine Tuned Data Bars

Fine Tuned Icon Sets

Oreo Data Bars

Oreo Icon Sets

Chapter 7

Custom Views

Custom Workspace

Frozen Columns or Rows

Hidden Columns

Horizontal Split

Page Break

Chapter 8

Simple Expenses

Student Grades

Student Grades Absolute

Summary

Chapter 9

Microsoft and Rounding

Average and Median

Counting

Forecast

Frequency

Percentile

Quotient and Mod

Random Ordering

Rounding

Trend

Trigonometry

Chapter 10

Tips on Non-Excel-Specific Investing, Depreciation and Financial Concepts

Depreciation

FV

NPV

NPV2

PPMT

PV

Chapter 11

DATEDIF() Information

Capitalization

Date Difference

Extract Words

Time Difference

Chapter 12

Microsoft Office Discussion Groups

Double Lookup

H Lookup

Indirect

Indirect 2

Invoicer Example

IS Functions

Left Lookup

Transpose

V Lookup

V Lookup Text

Chapter 13

Screencast: Tracing Formulas

Applied Names

Conditional Totals

Count If

Named Range

Non Zero Average

One Variable Data Table

Pet Names

Pet Wish List

Student Scores

Sum Ifs

Two Variable Data Table

Chapter 14

Product Table

Product Table Calculated Column

Product Table Database

Product Table Subtotal

Chapter 15

Automatic Subtotals

Consolidation

Grouping Columns

Grouping Columns and Rows

Multiple Groups

Nested Groups

Chapter 16

Downloading a Template from the Office Online Web site

Chapter 17

Area Chart

Bubble

Column Chart

Cone Cylinder

Donut

Line Charts

Multiple Series

Pie Chart

Radar

Scatter

Simple Chart

Stock

Surface

Time Scale

Two Ways Columns

Two Ways Lines

Chapter 18

Advanced Pies

Backgrounds

Combination Chart

Screencast: Creating a Combination Chart

Data Point Format

Data Series Format

Data Table

Different Shapes

Line Chart Labels

Overlay

Pie Chart

Scale

Shadowed Line

Simple Chart Labels

Trend Line and Error Bars

Two Layouts

Chapter 19

Arrow

Clip Art

Graphical Charts

Overlap

Pictures

Smart Art

Text Pictures

Transparent

Word Art

Chapter 20

Solver Web site

MATLAB

Quadratic

Sales Scenarios

Student Marks

Student Marks Solver

Chapter 21

Different Summaries

Pivot Summary

Pivot Test

Screencast: Building a Pivot Table

Chapter 22

Requirements for Running IRM

Data Validation

Invoice

Sum Validation

Chapter 23

Certificate Authorities

Sharepoint Server

Change Tracking

Comment

Fancy Comment

Chapter 24

W3 Schools XML Tutorial

Category Sales

Customer List

Mortgage

Mortgage

Northwind

Person Mapped

Sales Disaster

Student

Student List

Students Mapped

Students Mapped with Extras

Visio Embedded

Sales

Chapter 26

Combination Chart

Combination Chart

File List

Hyperlink

Web Query

Chapter 27

Authenticode Macro Signing

Catalog of Excel Viruses

Digital Certificate

Analyze Group

Format Row

Insert Header

Chapter 28

Pacman Game in Excel

.NET Programming Platform and Visual Studio

Custom Function

Custom Macros

Format Row