10106109Business Spreadsheet Applications
Course Information
Description
Create professional data-driven workbooks utilizing Microsoft Excel spreadsheet software. Using Microsoft Excel, work with formulas and a variety of time-saving functions; professionally format worksheets; create charts and tables; utilize advanced functions and apply conditional formatting; work with multiple worksheets, workbooks, and templates; incorporate data validation; utilize worksheet protection; create macros; export and cleanse data sets; and perform what-if analysis with Scenario Manager, Data Tables, and Solver; perform loan amortization, investment analysis, and asset depreciation. Sufficient test scores for placement into Math with Business Applications 10804123, or C or better in Math of Finance 10804144, or instructor consent. Recommended prerequisite: Windows competency, including solid file management skills. This course will use Microsoft Excel 365.
Total Credits
3
Prior Learning Assessment
  • Exam-College Developed Challenge Exam
  • Transfer Credit (includes Certifications)
Course Competencies
  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 for Windows
    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 for Windows
    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 for Windows
    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 for Windows
    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 Sparkliness 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 for Windows
    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 for Windows
    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 for Windows
    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 for Windows
    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 for Windows
    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 for Windows
    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
    Understand the Use of the Solver Add-In
    Solve Complex Problems Using Solver
    Generate and Interpret Solver Answer Reports