AOT 2025 - Spreadsheet Applications

Clock Hours: 114

Delivery Mode
on-ground

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:

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
Creating presentations
Printing presentations and handouts
Presentation themes
Art / graphics / videos
Organizing the slide layout
Managing slide master
Creating charts and tables
Delivering presentations