|
 |
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
