Home
Library
Full list of all Missing Manuals
Missing CD-ROMs
Free/Shareware Programs
Send us your Feedback
Write reviews, submit errata, ask questions
Sign up for our Newsletter
Screencasts
For Starters Series
Write for Us
About Missing Manuals
News Archive
Blogs
Press Releases
David Pogue's NYTimes Column
David Pogue's NYTimes Blog
David Pogue's Home Page
O'Reilly Website
Download Our 2008 Catalog (1.4MB PDF)
Search
Search Tips
Excel 2003: The Missing Manual
By Matthew MacDonald
Missing CD-ROM
Download example files for all chapters
here
.
Chapter 2
Bad Columns
Good Columns
Simple Expenses
Chapter 4
Formatting Cell Values
Horizontal Alignment Options
Simple Expenses Auto Format
Simple Expenses Formatted
Vertical Alignment Options
Chapter 6
Custom Views
Frozen
Hidden Columns
Split
Chapter 7
Simple Expenses Formatted
Student Grades
Student Grades Absolute
Chapter 8
Average and Median
Forecast
Frequency
Percentile
Quotient and Mod
Random Ordering
Rounding
Trend
Trigonometry
Chapter 9
Depreciation
FV
NPV
NPV2
PPMT
PV
Chapter 10
Capitalization
Date Difference
Extract Words
Time Difference
Chapter 11
Double Lookup
HLookup
INDIRECT example
Indirect
Invoicer Example
IS Functions
Left Lookup
Transpose
VLookup
VLookup Text
Chapter 12
Conditional Arithmetic
Count If
FV Named Range
Named Range
Non Zero Average
Pet Names
Pet Wish List
Student Scores
Sum Product
Variable Data Table
Chapter 13
Product List
Product List Calculated Field
Product List Database
Product List Subtotal
Chapter 14
Automatic Grouping
Automatic Subtotals
Consolidation
Grouping
Multiple Grouping
Chapter 15
Data Validation
Invoice Template
Sum Validation
Chapter 16
Area Chart
Bubble
Column Charts
Cone Cylinder
Donut
Line Charts
Multiple Series
Pie Chart
Radar
Scatter
Simple Chart
Stock
Surface
Time Scale
Two Ways
Chapter 17
Backgrounds
Combination Chart
Data Point Format
Data Series Format
Data Table
Different Shapes
Exploded Pie
Graphical Charts
Overlay
Scale
Simple Chart
Simple Chart Labels
Trend Line
Chapter 18
Clip Art
Pictures
Text Pictures
Transparent
Chapter 19
Quadratic
Sales Scenarios
Student Marks
Student Marks Solver
Chapter 20
Different Summaries
Pivot Test
Pivot Test Calculated
Pivot Test Chart
Pivot Test Filter
Pivot Test One Dimensional
Pivot Test Sub Formatted
Pivot Test Sub Group
Query from SQL Server
Chapter 21
Change Tracking Copy
Change Tracking
Comment
Fancy Comment
Chapter 22
log.txt
Northwind.MDB
Visio Embedded
Word.doc
Chapter 23
Person Mapped
Student.xml
Student List
Students Mapped
Students Mapped with Extras
Chapter 24
Book2.htm
CombinationChart.htm
Hyperlink
InteractivePage.mht
Web Query
Chapter 25
Analyze Group
Format Row
Insert Header
Chapter 26
Custom Function
Custom Macros
Format Row
© 2008, O'Reilly Media, Inc. | (707) 827-7000 / (800) 998-9938