Course

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)
  1. Demonstrate effective file management
    Assessment Strategies
    through actual performance of the skill
    in submitted documents as specified on the unit learning plan
    in an assessment with the use of reference materials
    Criteria
    Create and manage electronic files
    Edit and delete files
    Use print screen features
    Save files to designated folders
    Use file compression

  2. Create, navigate, and print worksheets
    Assessment Strategies
    through actual performance of the skills
    using a computer, printer, and Microsoft Excel 365
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Use spreadsheet terminology and components
    Navigate Worksheets and Workbooks
    Document your work
    Enter and edit data
    Work with Cells and Cell Ranges
    Adjust Columns and Rows
    Manipulate Worksheets and Workbooks
    Preview, Print, and Export Workbooks

  3. Apply formats, functions, and formulas
    Assessment Strategies
    through actual performance of the skills
    using a computer, printer, and Microsoft Excel 365
    in submitted files as specified on the assignment sheet by by specified assignment deadlines
    Criteria
    Format Cells, Cell Ranges, and Worksheets
    Create information with formulas
    Create information with functions
    Use conditional formatting to assist in decision making
    Hide information in a Worksheet
    Document functions and formulas

  4. Use cell references, named ranges, and functions
    Assessment Strategies
    through actual performance of the skills
    using a computer, printer, and Microsoft Excel 365
    in submitted files as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Describe the types of cell references
    Create named ranges
    Create and structure functions
    Use math and statistical functions
    Use data and time functions
    Use text functions
    Use lookup and financial functions
    Use logical functions and troubleshoot functions
    Use conditional aggregate functions
    Use conditional math functions

  5. Develop effective charts
    Assessment Strategies
    through actual performance of the skill
    using a computer, printer, and Microsoft Excel 365
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Explore the position of charts
    Describe different chart types, layouts, and styles
    Change chart data and styles for presentations
    Edit and format charts to add emphasis
    Use sparklines and data bars to emphasize data
    Recognize and correct confusing charts

  6. Apply complex logical retrieval functions
    Assessment Strategies
    through actual performance of the skills
    using a computer, printer, and Microsoft Excel 365
    in submitted files as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Preview the Workbook
    Use IF Functions
    Integrate Basic Conjunction Functions into IF Functions
    Integrate Complex Conjunction Functions into IF Functions
    Increase efficiency and clarity using the LET function
    Build IFS and Nested IF Functions
    Explore VLOOKUP, HLOOKUP, and XLOOKUP Functions
    Retrieve Data Using MATCH, INDEX, and INDIRECT Functions
    Handle Errors with the IFERROR Function

  7. Integrate complex functions into business analysis
    Assessment Strategies
    through actual performance of the skill
    using a computer, printer, and Microsoft Excel 365
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Manipulate data and information in tables
    Use Filters and the SUBTOTAL Function in Tables
    Construct Database Functions
    Develop and Customize PivotTables
    Develop and Customize PivotCharts

  8. Manage multiple worksheets, workbooks, and templates
    Assessment Strategies
    through actual performance of the skill
    using a computer, printer, and Microsoft Excel 365
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Group Worksheets
    Create Summary Worksheets
    Work with Multiple Workbooks
    Collaborate Using Multiple Workbooks
    Use Existing Templates
    Create Templates from an Existing Workbook

  9. Build an application with multiple worksheets and workbooks
    Assessment Strategies
    through actual performance of the skill
    using a computer, printer, and Microsoft Excel 365
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    View Formula Precedents and Dependents
    Evaluate Formulas
    Correct Circular References
    Use the Watch Window
    Control Data Entry with Data Validation
    Create and Use Macros
    Change How to Navigate a Workbook
    Protect Workbooks and Worksheets

  10. Organize, import, export, and cleanse data sets
    Assessment Strategies
    through actual performance of the skill
    using a computer, printer, and Microsoft Excel 365
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Describe the importance of external data sets
    Import XML and text data
    Connect to an Access database
    Use Flash Fill and Text Functions to Cleanse Imported Data
    Manipulate Data Using Text Functions
    Separate Data Using Wizards
    Cleanse date-related data

  11. Use data tables, scenario manager, and solver
    Assessment Strategies
    through actual performance of the skill
    using a computer, printer, and Microsoft Excel 365
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Perform Break-Even Analysis
    Analyze Variables in Formulas Through the Use of Data Tables
    Use Goal Seek to Determine Values Needed to Achieve an Objective
    Use the Scenario Manager to Create Scenarios
    Create Scenario Reports
    Explain the use of the Solver Add-In
    Solve Complex Problems Using Solver
    Generate and Interpret Solver Answer Reports

  12. Perform financial analyses
    Assessment Strategies
    through actual performance of the skill
    in submitted documents as specified on the unit learning plan
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Construct a loan analysis with PMT, RATE, and NPER functions
    Calculate cumulative interest and principal using CUMIPMT and CUMPRINC functions
    Create an amortization schedule using PPMT and IPMT functions
    Analyze bonds using PV and FV functions
    Analyze investments using NPV, XNPV, IRR, and XIRR functions
    Calculate the depreciation of assets using SLN, DB, and DDB functions