Oct 05, 2022  
Course/Program Inventory 
Course/Program Inventory

AOT 2025 - Spreadsheet Applications

Clock Hours: 114

Delivery Mode

Industry Certifications Microsoft Office Specialist in one or more Microsoft Office Programs; or Microsoft Office Specialist Expert in Word Expert or Excel Expert level.

Course Description:
To ensure the student develops skills in creation and management of spreadsheets and skill development in presentations for a career in today’s workplace.

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

  1. Working with worksheets and workbooks in Excel
  2. Excel templates
  3. Creating workbooks
  4. Entering and editing data in worksheets
  5. Inserting and deleting cells
  6. Formatting cell contents
  7. Applying conditional formatting
  8. Clearing cell content
  9. Working with rows and columns
  10. Document themes
  11. How to use freeze, hide, unhide, zoom, ascending order, auto filter, comparison operator, and filter features
  12. Working with formulas
  13. Working with lookup functions, conditions and searching tools
  14. Charts
  15. Creating presentations
  16. Printing presentations and handouts
  17. Presentation themes
  18. Art / graphics / videos
  19. Organizing the slide layout
  20. Managing slide master
  21. Creating charts and tables
  22. Delivering presentations