10103133Excel Beginning
Course Information
Description
Within the Microsoft Office Suite, Excel Beginning is an introduction to Microsoft Excel spreadsheet software used to effectively manage data to make better business decisions. Create and format worksheets and workbooks; analyze data using formulas and functions; create charts to display data visually. Work with functions such as SUM, IF, AND, OR, AVERAGE, MIN, MAX, COUNT, and Date functions. This course will use Microsoft 365/Excel 2021.
Total Credits
1
Prior Learning Assessment
  • Exam-College Developed Challenge Exam
Course Competencies
  1. Create and format a worksheet
    Assessment Strategies
    through actual performance of the skills
    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
    Explore the Excel Window
    Enter and Edit Cell Data
    Enter Formulas and Use AutoSum
    Copy Formulas with Relative and Absolute Cell References
    Enter Formulas with Multiple Operators
    Switch Worksheet Views
    Choose Print Options

  2. Formatting a Worksheet
    Assessment Strategies
    through actual performance of the skills
    using a computer, printer, and Microsoft Excel Office 365/2021 for Windows
    in submitted files as specified on the assignment sheet by by specified assignment deadlines
    Criteria
    Format Values in Excel
    Change Font and Font Size
    Adjust Column Widths and Row Heights
    Insert and Delete Columns and Rows
    Apply Colors, Borders, and Documentation
    Apply Conditional Formatting
    Rename and Move a Worksheet
    Check Workbook Spelling

  3. Analyzing Data Using Formulas
    Assessment Strategies
    through actual performance of the skills
    using a computer, printer, and Microsoft Excel Office 365/2021 for Windows
    in submitted files as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Enter a Formula Using the Quick Analysis Tool
    Build Logical Functions
    Round a Value with a Function
    Build a Statistical Formula
    Use Date Functions
    Work with Equation Tools
    Control Worksheet Calculations

  4. Working with Charts
    Assessment Strategies
    through actual performance of the skills
    using a computer, printer, and Microsoft Excel Office 365/2021 for Windows
    in submitted files as specified on the assignment sheet by specified assignment deadlines
    Criteria
    Plan a Chart
    Create a Chart
    Move and Resize a Chart
    Change Chart Design
    Change Chart Layout
    Format a Chart
    Summarize Data with Sparklines
    Identify Data Trends