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
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