10106109
Business Spreadsheet Applications
Course Information
Description
Create professional, data-driven workbooks using Microsoft Excel. Develop skills with formulas, functions, worksheet formatting, charts, tables, conditional formatting, multiple worksheets and workbooks, templates, data validation, worksheet protection, and macros. Import and cleanse data, perform what-if analysis using Scenario Manager, Data Tables, and Solver, and complete loan amortization, investment analysis, and asset depreciation calculations.
Total Credits
3
Prior Learning Assessment
- Transfer Credit (includes Certifications)
- Exam-College Developed Challenge Exam
Course Competencies (Course Outcomes)
-
Demonstrate effective file managementAssessment Strategiesthrough actual performance of the skillin submitted documents as specified on the unit learning planin an assessment with the use of reference materialsCriteriaCreate and manage electronic filesEdit and delete filesUse print screen featuresSave files to designated foldersUse file compression
-
Create, navigate, and print worksheetsAssessment Strategiesthrough actual performance of the skillsusing a computer, printer, and Microsoft Excel 365in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlinesCriteriaUse spreadsheet terminology and componentsNavigate Worksheets and WorkbooksDocument your workEnter and edit dataWork with Cells and Cell RangesAdjust Columns and RowsManipulate Worksheets and WorkbooksPreview, Print, and Export Workbooks
-
Apply formats, functions, and formulasAssessment Strategiesthrough actual performance of the skillsusing a computer, printer, and Microsoft Excel 365in submitted files as specified on the assignment sheet by by specified assignment deadlinesCriteriaFormat Cells, Cell Ranges, and WorksheetsCreate information with formulasCreate information with functionsUse conditional formatting to assist in decision makingHide information in a WorksheetDocument functions and formulas
-
Use cell references, named ranges, and functionsAssessment Strategiesthrough actual performance of the skillsusing a computer, printer, and Microsoft Excel 365in submitted files as specified on the assignment sheet by specified assignment deadlinesCriteriaDescribe the types of cell referencesCreate named rangesCreate and structure functionsUse math and statistical functionsUse data and time functionsUse text functionsUse lookup and financial functionsUse logical functions and troubleshoot functionsUse conditional aggregate functionsUse conditional math functions
-
Develop effective chartsAssessment Strategiesthrough actual performance of the skillusing a computer, printer, and Microsoft Excel 365in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlinesCriteriaExplore the position of chartsDescribe different chart types, layouts, and stylesChange chart data and styles for presentationsEdit and format charts to add emphasisUse sparklines and data bars to emphasize dataRecognize and correct confusing charts
-
Apply complex logical retrieval functionsAssessment Strategiesthrough actual performance of the skillsusing a computer, printer, and Microsoft Excel 365in submitted files as specified on the assignment sheet by specified assignment deadlinesCriteriaPreview the WorkbookUse IF FunctionsIntegrate Basic Conjunction Functions into IF FunctionsIntegrate Complex Conjunction Functions into IF FunctionsIncrease efficiency and clarity using the LET functionBuild IFS and Nested IF FunctionsExplore VLOOKUP, HLOOKUP, and XLOOKUP FunctionsRetrieve Data Using MATCH, INDEX, and INDIRECT FunctionsHandle Errors with the IFERROR Function
-
Integrate complex functions into business analysisAssessment Strategiesthrough actual performance of the skillusing a computer, printer, and Microsoft Excel 365in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlinesCriteriaManipulate data and information in tablesUse Filters and the SUBTOTAL Function in TablesConstruct Database FunctionsDevelop and Customize PivotTablesDevelop and Customize PivotCharts
-
Manage multiple worksheets, workbooks, and templatesAssessment Strategiesthrough actual performance of the skillusing a computer, printer, and Microsoft Excel 365in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlinesCriteriaGroup WorksheetsCreate Summary WorksheetsWork with Multiple WorkbooksCollaborate Using Multiple WorkbooksUse Existing TemplatesCreate Templates from an Existing Workbook
-
Build an application with multiple worksheets and workbooksAssessment Strategiesthrough actual performance of the skillusing a computer, printer, and Microsoft Excel 365in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlinesCriteriaView Formula Precedents and DependentsEvaluate FormulasCorrect Circular ReferencesUse the Watch WindowControl Data Entry with Data ValidationCreate and Use MacrosChange How to Navigate a WorkbookProtect Workbooks and Worksheets
-
Organize, import, export, and cleanse data setsAssessment Strategiesthrough actual performance of the skillusing a computer, printer, and Microsoft Excel 365in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlinesCriteriaDescribe the importance of external data setsImport XML and text dataConnect to an Access databaseUse Flash Fill and Text Functions to Cleanse Imported DataManipulate Data Using Text FunctionsSeparate Data Using WizardsCleanse date-related data
-
Use data tables, scenario manager, and solverAssessment Strategiesthrough actual performance of the skillusing a computer, printer, and Microsoft Excel 365in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlinesCriteriaPerform Break-Even AnalysisAnalyze Variables in Formulas Through the Use of Data TablesUse Goal Seek to Determine Values Needed to Achieve an ObjectiveUse the Scenario Manager to Create ScenariosCreate Scenario ReportsExplain the use of the Solver Add-InSolve Complex Problems Using SolverGenerate and Interpret Solver Answer Reports
-
Perform financial analysesAssessment Strategiesthrough actual performance of the skillin submitted documents as specified on the unit learning planin submitted spreadsheets as specified on the assignment sheet by specified assignment deadlinesCriteriaConstruct a loan analysis with PMT, RATE, and NPER functionsCalculate cumulative interest and principal using CUMIPMT and CUMPRINC functionsCreate an amortization schedule using PPMT and IPMT functionsAnalyze bonds using PV and FV functionsAnalyze investments using NPV, XNPV, IRR, and XIRR functionsCalculate the depreciation of assets using SLN, DB, and DDB functions