|
Intermediate Excel
Lesson Objectives:
Learn how to create a sales summary that combines
information from several spreadsheets. This lesson will demonstrate how to
create formulas that reference data from other worksheets, use absolute
and relative cell references, and how to troubleshoot your equations. In this lesson
you will:
Practice
formatting data and content page
1
Demonstrate how to
fill a series with AutoFill
page 7
Learn how to
calculate Revenue with a formula
page 10
Practice the
steps needed to summarize the data page 15
Identify Relative
References page 18
Identify errors
and troubleshoot the equation page 21
Learn how to
create and use Absolute References page 22 |
||
|
| ||
