Excel 2003: The Missing Manual

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