|
Intermediate Excel
Lesson Objectives:
Learn how to create a time sheet that uses client names
in
a drop down list. This lesson shows how to create and modify formulas,
format content, ensure data integrity and restrict data using data
validation. This lesson also demonstrates how to use Conditional
Formatting to highlight specific information. In this lesson
you will:
Practice how to
enter data and fill a series
page 2
Review the steps
needed to calculate the Total page 4
Practice how to
enter data in a reference list
page 15
Identify the
steps needed to make a drop-down list page 18
Learn how to use
Conditional Formatting page 20
Identify options
for Data Integrity and Validation page 21
Investigate
Conditional Formatting Rules page 29 |
|||
|
| |||
