Excel 2007 Book Excerpts Are Available
I just found out that Wiley has made available quite a few excerpts from some of my Excel 2007 Books.
These excerpts are all at Microsoft's site. They are in *.MHT format, so you'll need Internet Explorer to read them. Or, you can download the files and open them with Microsoft Word.
Excerpts
from
Excel 2007 Charts:
- A chart maker's check list
- Adding lines and backgrounds to a chart
- Chart accuracy
- Charting a noncontiguous range
- Creating a box plot
- Creating a comparative histogram
- Creating a multiline category axis
- Creating a thermometer chart
- Creating a timeline
- Displaying multiple charts on a chart sheet
- Don't be tempted by 3-D charts
- Introducing Excel charts
- Problems with pie charts
- Understanding series names
- Using time-scale axes
Excerpts
from
John Walkenbach's Favorite Excel 2007 Tips & Tricks:
- Annotating a chart
- Creating worksheet-level names
- Dealing with missing data in a line chart
- Knowing when to use absolute references
- Knowing when to use mixed references
- Making a worksheet "very hidden"
- Returning the last nonblank cell in a column or row
- Summing across sheets
- Understanding workbooks versus windows
- Updating old fonts
- Using AutoSum tricks
- Using the status bar selection statistics feature
- Various methods for rounding numbers
Excerpts
from
Excel 2007 Bible:
- Applying number formatting
- Creating your first worksheet
- Getting to know the formatting tools
- How Excel handles dates and times
- Understanding array formulas
- Understanding custom Excel templates
- Understanding formula basics
- Understanding workbooks and worksheets
- Using different fonts
Excerpts
from
Excel 2007 Formulas:
- Reader Comments -
(No comments have been posted for this item.)
Commenting is not available in this weblog entry.
Spreadsheet Page Blog
Welcome to the Spreadsheet Page Blog. This is where you find the latest news on my books, add-ins, and other Excel-related topics. Comments are welcome.