|
Beginning Excel
Lesson Objectives:
Learn how to create a price sheet for your business.
This demonstration shows how to format the data: font, alignment and
number formatting. This lesson also shows how to create and modify
themes. In this lesson you will:
Practice entering the
labels and data
page 4
Use the Home Ribbon to
apply number formats page 6
Create a formula to
calculate the retail price
page 7
Use the AutoSum to
calculate costs page
8
Use the AutoSum to SUM the
profit page
9
Use the Home Ribbon to
format cell borders
page 10
Investigate options to
hide and unhide data page 11
Learn how
to create, format and modify a pie chart page 13
Identify
and use the Page Layout Themes
page 18
Practice
Page Layout options page 24 |
||
|
| ||
