Use basic formulas and functions to calculate data in an Excel workbook

Excel Module 1 SAM Projects 1 & 2

SAM Training and Online Videos

(50 Points)

Create, format and modify Excel charts for effective presentation of data

Excel Module 2 SAM Projects 1 & 2

SAM Training and Online Videos

(50 Points)

Plan, create, and modify Excel tables

Excel Module 3 SAM Projects 1 & 2

SAM Training and Online Videos

(50 Points)

Summarize and analyze large amounts of data using PivotTables and PivotCharts

Excel Module 4 SAM Projects 1 & 2

SAM Training and Online Videos

(50 Points)

Use advanced logical functions, nested IFs, and lookup functions

Excel Module 5 SAM Projects 1 & 2

SAM Training and Online Videos

(50 Points)

Apply conditional formatting to cells

Excel Module 6 SAM Projects 1 & 2

SAM Training and Online Videos

(50 Points)

Use financial functions for analysis of loans, investments, payback, NPV, and IRR

Excel Module 7 & 8 SAM Projects 1 & 2

SAM Training and Online Videos

(100 Points)

Project future income and expenses and calculate amortization and depreciation schedules

Excel Module 9 SAM Projects 1 & 2

SAM Training and Online Videos

(50 Points)

Create and apply different what if analyses to financial data using Scenario Manager and Solver

Excel Module 10 SAM Projects 1 & 2

SAM Training and Online Videos

(50 Points)

Use Excel features to solve complex business problems and facilitate business decision making

Excel Module 11 & 12 SAM Projects 1 & 2

SAM Training and Online Videos

(100 Points)

Excel Final Exam

300 Points