Sep 24, 2024  
Course/Program Inventory 
    
Course/Program Inventory

AAT 1060 - Spreadsheet Applications



Clock Hours: 78

Delivery Mode
on-ground

Industry Certifications Microsoft Office Specialist: Excel.

Course Description:
To ensure the student develops skills in creating and managing spreadsheets and data management.  

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

  • Working with worksheets and workbooks in Excel 

  • Excel templates 

  • Creating workbooks 

  • Entering and editing data in worksheets 

  • Inserting and deleting cells 

  • Formatting cell contents 

  • Applying conditional formatting 

  • Clearing cell content 

  • Working with rows and columns 

  • Document themes 

  • How to use freeze, hide, unhide, zoom, ascending order, auto filter, comparison operator, and filter features  

  • Working with formulas  

  • Working with lookup functions, conditions and searching tools 

  • Charts