10103139Excel Intermediate
Course Information
Description
Continuation of the Microsoft Excel Beginning course. Using the Microsoft Office Suite, focus on the higher-level concepts of Microsoft Excel spreadsheet software. Use Excel tables to analyze and manipulate data; create data validations. Work with multiple worksheets; protect worksheets and workbooks; create and save custom views. Work with images and integrating Excel with other program data. Summarize and analyze data using subtotals, PivotTables, PivotCharts and PivotReports. Work with functions such as VLOOKUP, DSUM, GETPIVOTDATA. This course will use Microsoft Excel 365/2021. Pre-requisite: Excel Beginning or consent of instructor, and competency in Windows including file management skills.
Total Credits
1
Prior Learning Assessment
  • Exam-College Developed Challenge Exam
Course Competencies
  1. Working with Tables
    Assessment Strategies
    through actual performance of the skill
    using a computer, printer, and Microsoft Excel 365/2021 for Windows
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Create and Format an Excel Table
    Add and Delete Table Data
    Sort Table Data
    Use Structured Formulas In a Table
    Filter a Table
    Look up values in a Table
    Summarize Table Data
    Validate Table Data

  2. Managing Workbook Data
    Assessment Strategies
    through actual performance of the skill
    using a computer, printer, and Microsoft Excel 365/2021 for Windows
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    View and Arrange Worksheets
    Protect Worksheets and Workbooks
    Save Custom Views of a Worksheet
    Prepare a Worksheet for Distribution
    Insert Hyperlinks
    Save a Workbook for Distribution
    Work with Grouped Data and Worksheets

  3. Working with Images and Integrating with Other Programs
    Assessment Strategies
    through actual performance of the skill
    using a computer, printer, and Microsoft Excel 365/2021 for Windows
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Plan a Data Exchange
    Import from Text, Databases and other Workbooks
    Link Worksheet data
    Export to a Database
    Insert a Graphic File

  4. Analyzing Data with PivotTables
    Assessment Strategies
    through actual performance of the skill
    using a computer, printer, and Microsoft Excel 365/2021 for Windows
    in submitted spreadsheets as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Plan and Design a PivotTable Report
    Create a PivotTable Report
    Change a PivotTable Function
    Filter PivotTable Data
    Explore PivotTable Data Relationships
    Create a PivotChart
    Update a PivotTable
    Use the GETPIVOTDATA Function