ADMINISTRATIVE ASSISTANT CERTIFICATE PROGRAM

Administrative Assistants can work for corporate businesses, law firms, banks, hospitals, and doctors' offices. In 3 months, you will learn the essential computer skills needed to be successful in an office environment. You’ll receive training on the most popular Microsoft Office 2016 programs, including Word, Excel, Access, PowerPoint,  MS Outlook and computer foundations including file management.

*A four-gigabyte flash drive is required for this course. A computer at home or some other location that has Microsoft Office 2016 installed is necessary for assignments and reinforcing the lessons covered in class.

By completing all four course modules and the capstone project, you will earn an Administrative Assistant with Microsoft Office 2016 Certificate.

Introduction to Microsoft Office – MS WORD 2016

  • Create, format, edit, and proof documents, tables, lists, forms, graphics, images
  • Create templates: Résumé writing and memos
  • Mail merge documents
  • Desktop publishing
  • Create and use macros

Microsoft Office – Excel 2016

  • Create, format, share and manipulate spreadsheets, workbooks, tables, charts, graphs
  • Create templates
  • Create calculations, formulas and functions
  • Import and export data
  • Analyze data using: filter and sort/ conditional formatting/look up functions/pivot tables
  • Work within multiple spreadsheets and workbooks and link documents
  • Create and use macros
  • Security

Microsoft Office – PowerPoint 2016

  • Build and format a presentation using text boxes, charts, clip art, audio, etc.
  • Create dynamic presentations using transitions and animations
  • Deliver presentations in different settings

Microsoft Access

  • Create and design database
  • Tables
  • Queries
  • Forms
  • Reports

Section A: Tuesday and Thursday | 6:00 PM - 9:00 PM | October 9 - January 31
ADMIN: Tuition: $1,120 | 30 Sessions | 90 hours | No Class: November 22, December 25, December 27, January 1