introduction
what you’ll create
how this book works
the web site
the next step
1. meet microsoft excel
learn the lingo
mouse around
start excel
look at excel
change the view
scroll a window
use the Ribbon
choose from a menu
have a dialog
exit excel
extra bits
2. create the workbook file
create the workbook
set display options
save the workbook
3. build the budget worksheet
name the sheet
understand references
enter information
activate a cell
enter row headings
enter column headings
make a column wider
enter values
calculate a difference
calculate a percent diff
sum some values
calculate net income
copy formulas
copy and paste
use the fill handle
change a value
4. duplicate the worksheet
copy the sheet
clear the values
insert a row
delete a row
enter new values
5. consolidate the results
prepare the sheet
consolidate
check the consolidation
calculate percent diff
6. format worksheets
set font formatting
format values
format percentages
set column widths
set alignment
indent text
add borders
apply shading
change text color
format all worksheets
7. add a chart
hide a row
insert a chart
create a chart sheet
add a chart title
move the legend
explode a pie
add data labels
format chart text
8. share your work
switch to page layout
select the sheets
open page setup
set page options
adjust margins
add a standard footer
add a custom header
save settings
preview the sheets
print your work
send via e-mail
index
