Administrative Assistant

Word 2016: This course covers the basic functions and features of Word 2016. Students will learn how to enter and edit text and save and browse documents. They will learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert headers and footers, proof, and print documents, and insert graphics.

Excel 2016: This course teaches the basic functions and features of Excel 2016. After an introduction to spreadsheet terminology and Excel’s window components, students will learn how to use the Help system and navigate worksheets and workbooks. They will enter and edit text, values, formulas, functions, and pictures. Additionally, they will learn how to protect workbooks and save workbooks in various formats. Students will also move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, and printing. Finally, students will create and modify charts, and learn how to manage large workbooks.

PowerPoint 2016: This course covers the basic functions and features of PowerPoint 2016. Students will create new presentations that include text, graphics, WordArt, tables, charts, and diagrams. They will also edit and format slide content and apply transition and animation effects.

Outlook 2016: This course covers the basic functions and features of Outlook 2016. Students will create e-mail accounts and send e-mail messages using several techniques. They will also learn how to manage e-mail messages, contacts, tasks, and meeting requests. Finally, students will customize Outlook for maximum efficiency.

SharePoint 2016: This course covers the basic functions and features of SharePoint 2016. Microsoft SharePoint is a browser-based collaboration and document management platform. It allows groups to set up a centralized, password protected space for document sharing. Organizations use Microsoft SharePoint to create their own social websites. It can also be used as a secure place to store, organize, share, and access information from any device.

Microsoft MOS Certification

The Administrative Assistant program is aligned with the Microsoft MOS Certification and is sanctioned by Microsoft Corporation. Accordingly, at the end of their training, students will have the opportunity to become certified as Microsoft Office Specialists.

Employment Opportunities

Career options upon completion of Administrative Assistant Program include but is not limited to positions as an Office Assistant, Executive Assistant, Office Manager, Accounting Clerk / Assistant, Human Resources Assistant / Coordinator, Customer Service Representative, and Claims Assistant.

Direct Client Placement Assistance

BBA guarantees all students direct client placement assistance and resume submission. Candidates will be screened by industry professionals and career counselors. Resume preparation and career workshops are part of BBA’s placement program. Externships will be provided to all students prior to job placement.

Career Counseling

Professional career counselors will conduct mock interviews, train students on soft skills and interview techniques.

Course Outline

This Series course covers the basic functions and features of Word 2016. This course will help students prepare for the Microsoft Office Specialist for Word 2016 (Exam 77-418).
  • Word interface
  • Navigation and selection techniques
  • Editing text
  • Formatting text
  • Character and paragraph formatting
  • Styles and outlines
  • Sections and columns
  • Headers and Footers
  • Tables
  • Graphics and charts
  • Reference tools
  • Creating a table of contents and index
  • Creating a bibliography
  • Creating bookmarks
  • Footnotes and endnotes
  • Creating forms
  • Macros
  • Mail Merge
  • Document sharing
  • Proofing documents
  • Protecting documents
  • Templates and building blocks
  • Customizing Word
  • Printing techniques
This Series course teaches the basic functions and features of Excel 2016. This course will help students prepare for the Microsoft Office Specialist for Excel 2016 (Exam 77-420).
  • Excel interface
  • Entering and editing data
  • Formatting
  • Modifying a worksheet
  • Modifying a workbook
  • Protecting worksheets and workbooks
  • Functions and formulas
  • Logical and statistical functions
  • Financial and date functions
  • Text Functions
  • 3-D Formulas
  • Absolute and Relative references
  • Autofill
  • Outlining and subtotals
  • Cell and range names
  • Charts
  • Tables
  • Data tables
  • PivotTables
  • V-Lookup and Lookup functions
  • Analytical tools
  • Macros
  • Web and sharing features
  • Data validation
  • Templates
  • Exporting and importing
  • Printing techniques
  • Customizing Excel
This Series course covers the basic functions and features of PowerPoint 2016. This course will help students prepare for the Microsoft Office Specialist for PowerPoint 2016 (Exam 77-422).
  • PowerPoint interface
  • Creating and formatting slides
  • Editing slide content and slide layouts
  • Creating and modifying presentations
  • Working with graphics
  • Working with tables and charts
  • Using Slide Master
  • Applying transitions and animations
  • Applying video and audio clips
  • Applying Action buttons
  • Creating custom slide shows
  • Applying content from a Word outline
  • Proofing and delivering presentations
  • Preparing and printing presentations
  • Distributing presentations
  • Customizing PowerPoint
This Series course covers the basic functions and features of Outlook 2016. This course will help students prepare for the Microsoft Office Specialist for Outlook 2016 (Exam 77-423).
  • Outlook interface
  • E-mail basics
  • E-mail management
  • Customizing messages
  • Handling attachments
  • Contacts management
  • Task management
  • Managing the calendar
  • Appointments and events
  • Managing meetings
  • Meeting requests and responses
  • Mailbox organization
  • Working with folders
  • Calendar and contact sharing
  • Notes and Journal folders
  • Customizing Outlook

Get Started Today

  • 174 Boulevard, Hasbrouck Heights, NJ 07604
  • (201) 426-0299
  • info@bergenblended.com