Microsoft Office Tutorials and References
In Depth Information
Tutorial 2 Formatting a Workbook Designing a Financial Report
2
TUTORIAL
Formatting a
Workbook
Designing a Financial Report
OBJECTIVES
Session 2.1
• Format text, numbers, and dates
• Change fonts and font colors
• Add fi ll colors and background
images
• Create formulas to add,
subtract, and divide values
• Apply number formats
• Align, indent, and rotate cell
contents
• Merge a range into a single cell
• Copy and paste formats
Case | ExerComp Exercise Equipment
ExerComp, based in Mason, Ohio, manufactures electronic and
computer components for fi tness machines and sporting goods. At
the upcoming annual sales meeting, sales managers will present
reports that detail the sales history of different ExerComp products.
Sales manager Tom Uhen will report on the recent sales history of
the X310 heart rate monitor.
Session 2.2
• Apply built-in cell styles
• Change the theme of a
workbook
• Create formulas to add and
subtract values
• Apply a built-in table style and
select table style options
• Highlight cells with
conditional formats
• Hide worksheet rows
• Defi ne the print area, insert
page breaks, and add print titles
• Create headers and footers
• Select page margins
Tom has already created a workbook and entered the sales fi gures
for the past two years. He wants you to enter formulas to calculate
total sales and increases in sales. He also wants you to make the
data more readable and informative. To do this, you will work with
formatting tools to modify the appearance of the data in each cell,
the cell itself, and the entire worksheet. Because much of Tom’s
data has been stored in tables, you will also use some special
formatting tools designed for tables.
STARTING DATA FILES
Excel2
Tutorial
Review
Case1
Case2
Case3
Case4
Background.jpg
ExerComp.xlsx
Paper.jpg
X410.xlsx
Frosti.xlsx
GrillRite.xlsx
Wind.xlsx
Life.xlsx
EX 57
 
Search JabSto ::




Custom Search