Earning Criteria

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