|
Advanced Excel
Lesson Objectives: Learn how to
create formulas that calculate, compare and format text. This lesson
will demonstrate how to use formulas to conditionally format and
summarize data. In this lesson
you will:
Practice modifying
cell contents and formats page 2
Use the Paste
Special options on the Home Ribbon page 5
Use the Home Ribbon
to Sort and Filter Data page 8
Practice how to
edit data by using Find and Replace page 9
Learn how to Filter
the data
page 12
Learn how to modify
text with formulas
page 14
Use
formulas to summarize data page 21 |
||
|
| ||
