Track and analyze your business data using Excel
Class length: 1/2 day
Prerequisite: The following course (or equivalent knowledge): Excel Worksheets
Objectives
Upon successful completion of this lab, students will be able to:
* create simple formulas with cell references and functions
* use absolute and mixed cell references in formulas and use the Round function
* build formulas using the If and Vlookup functions
* create formulas with the PMT function to calculate loan payments
Lab content
Lab Activity 1: Excel formulas “101”
• Create basic formulas with cell references
• Create formulas for a profit statement
• Use functions and labels in formulas
• Create a formula for income projection
Lab Activity 2: Build formulas to project sales
• Create formulas with mixed and absolute cell references
• Use the Round function
• Add Clip Art
• Prepare the report for printing
Lab Activity 3: Use lookup tables to find delivery charges
• Experiment with the If function
• Use the Vlookup function
• Use the If and Vlookup functions in a formula
Lab Activity 4: Calculate loan payments
• Create formulas with the PMT function
