Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 More

Open for Business

A Question of Balance

 

Click Here to Get Started

Sample Files

 

Beginning Excel

Lesson Objectives: Learn how to create a checkbook,

calculate revenue and compare salaries. This demonstration shows how to create and modify formulas, use cell references, format cells, and manage worksheets. In this lesson you will:

Review how to enter labels and data page3

Review how to calculate the balance page 5

Identify methods to audit your equations page 6

Use currency formatting on the Home Ribbon page 7

Identify the options that format the decimals page 8

Use formulas for SUM, AVERAGE, COUNT page 10

Learn the COUNTA Function page 14

Practice the Max and Min Functions page 16

Use the IF Logical Function page 18