Excel 2003: The Missing Manual
By Matthew MacDonaldMissing CD-ROM
Download example files for all chapters here.
Chapter 2
Chapter 4
- Formatting Cell Values
- Horizontal Alignment Options
- Simple Expenses Auto Format
- Simple Expenses Formatted
- Vertical Alignment Options
Chapter 6
Chapter 7
Chapter 8
- Average and Median
- Forecast
- Frequency
- Percentile
- Quotient and Mod
- Random Ordering
- Rounding
- Trend
- Trigonometry
Chapter 9
Chapter 10
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
Chapter 14
Chapter 15
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
Chapter 19
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
