Apr 26, 2024  
Course/Program Inventory 
    
Course/Program Inventory

DPS 1060 - Microsoft Excel



Clock Hours: 66

Prerequisites: DPS 1050 - Advanced Computer Concepts and Literacy   

Course Description:
Students learn how to create formatted worksheets with charts to include formulas and functions.

Student Learning Outcomes:
Students will be able to demonstrate knowledge of:

  • Describe the Excel worksheet
  • Enter text and numbers 
  • Use the Sum button to sum a range of cells 
  • Use the Sum button to sum a range of cells
  • Enter a simple function 
  • Copy the contents of a cell to a range of cells using the fill handle
  • Supply cell styles  
  • Format cells in a worksheet 
  • Create a 3-D pie chart 
  • Change a worksheet name and worksheet tab color 
  • Change document properties 
  • Preview and print a worksheet 
  • Use the Auto Calculate area to display statistics 
  • Correct errors on a worksheet