Spreadsheet Functions and Formulas

Issued by Husson University

While utilizing Excel for analysis, formulas and functions are essential. In Excel, functions are predefined formulas. Earners of the Spreadsheet Functions and Formulas have shown that they are able to: apply dates and times; develop formulas, functions, and look ups; and, build conditional analysis and formatting.

Type Validation
Level Foundational
Time Weeks

Skills

Excel
Formulas
Functions
Office
Spreadsheets

Earning Criteria

Earners develop a comprehensive mileage workbook that provides a “real world” hands-on demonstration of how functions and formulas can be used together to create a report for a given scenario. Earners apply fundamental formulas and data to a spreadsheet in practice by creating and updating the mileage and expenses in this multi-sheet workbook project.