Advanced Administrative Assistant with Microsoft Office 2019 Course.


Course Cover

Register for this course

We are proud to offer this course in a variety of training formats to suit your needs. We use the highest quality learning facilities to make sure your experience is as comfortable as possible. Our face to face calendar allows you to choose any classroom course of your choice to be delivered at any venue of your choice - offering you the ultimate in convenience and value for money.


June 2024

Code Date Duration Location Fee Action
AAA09 17 Jun 2024 - 28 Jun 2024 10 days Kisumu, Kenya KES 165,000 | $2,200 Register
AAA09 17 Jun 2024 - 28 Jun 2024 10 days Kampala, Uganda $3,300 Register
AAA09 24 Jun 2024 - 5 Jul 2024 10 days Nakuru, Kenya KES 166,000 | $2,200 Register
AAA09 17 Jun 2024 - 28 Jun 2024 10 days Accra, Ghana $4,400 Register
AAA09 24 Jun 2024 - 5 Jul 2024 10 days Pretoria, South Africa $4,400 Register
I Want To See More Dates...

Unfortunately, we do not have any dates scheduled at this time. Do you have a date in mind when you would like to take your training?

Request Custom Schedule

Contact Us on (+254) 715 077 817 / (+254) 792 516 000 or email us [email protected].

June 2024

Date
Duration
Location
Fee
Action
17 Jun - 28 Jun 2024
10 days
Kisumu
KES 165,000 $2,200
17 Jun - 28 Jun 2024
10 days
Kampala
$3,300
24 Jun - 5 Jul 2024
10 days
Nakuru
KES 166,000 $2,200
17 Jun - 28 Jun 2024
10 days
Accra
$4,400
24 Jun - 5 Jul 2024
10 days
Pretoria
$4,400
I Want To See More Dates...

Unfortunately, we do not have any dates scheduled at this time. Do you have a date in mind when you would like to take your training?

Request Custom Schedule

Contact Us on (+254) 715 077 817 / (+254) 792 516 000 or email us [email protected].


Introduction

This IRES course is designed for administration professionals to enhance their skills and acquire command over Microsoft Office 2019. It will allow them to leverage their cutting-edge skills in the job market and increase their worth. This course offers training in useful tools and powerful strategies to help you deal with your job responsibilities more efficiently. This course contains two major modules i.e. Administrative Assistant and Microsoft Office 365 Training Bundle.

This course covers the following applications of Microsoft office 2019:

  • Microsoft Word 2019
  • Microsoft Excel 2019
  • Microsoft PowerPoint 2019
  • Microsoft Outlook 2019
  • Microsoft Access 2019
  • Microsoft Publisher 2019

Duration

10 days


Course Level:

Learning Objectives

After completing this course, you should be able to:

  • Type quickly and effectively
  • Identify the steps to complete general office procedures
  • Comprehend the basics of working within Microsoft® Office
  • Identify the steps for creating business documents using professional language
  • Identify the basic requirements for bookkeeping and accounting in the office
  • Recall ways to create, edit, and print documents in Word
  • Recognize how to create and manage worksheets in Excel
  • Identify the steps to develop presentations in PowerPoint
  • List how to create and manage databases in Access
  • Identify the steps to manage email and calendars in Outlook

Course Outline

Administrative Assistant

Module 1: Typing Practice & Improvement

  • ​​​​Pre-Test Your Typing Ability
  • Finger Positioning Exercises
  • Typing Practice Games
  • Typing Progress Tracking
  • Improve Your Typing Skills
  • Increase Your Typing Speed

Module 2: General Office Procedures

  • The New Administrative Assistant
  • The Daily Routine
  • Telephone Usage & Etiquette Tips
  • Mail Services and Shipping
  • Travel Arrangements
  • Transportation Reservations
  • Dealing with Meetings
  • Meeting Agendas and Minutes
  • Engaging in Virtual meetings
    • Skype
    • Zoom
    • Microsoft Teams
    • Google Meet
    • GoToMeeting
    • ezTalks Meetings
    • StarLeaf
    • Cisco Webex
    • Toasty
    • Lifesize
  • Time Management
  • Creating Action Plans
  • Keeping Accurate Records
  • Filing Systems and File Cabinets

Module 3: Office Equipment and Computers Applications

  • Understanding Office Equipment
  • Using Microsoft Windows
  • Using Apple Macintosh
  • Navigating with Mac OS X
  • Email Accounts & Programs
  • Organizing Your Email
  • Using the Internet
  • Computer Networking
  • Web Conferencing
  • Data Security
  • Troubleshooting Computer Problems
  • Office Ergonomics

Module 4: Using Microsoft Office

  • Common Microsoft Office 2010 Features
  • Using Microsoft Word
  • Using Microsoft PowerPoint
  • Using Microsoft Excel
  • Using Microsoft Publisher
  • Using Microsoft One Note
  • Using Microsoft Outlook
  • Using Microsoft Web Applications

Module 5: Business Documents

  • Creating a Great Business Letter
  • Appearance and Paragraphing
  • Interoffice Memorandums and E-Mails
  • Reports and Report Templates
  • Press Releases
  • Editing and Proofreading
  • Forms of Address
  • Legal Documents and Terms
  • Grammalogues
  • Notary Public Forms
  • Agreements and Contracts
  • Legal and Real Estate Terms

Module 6: Language Usage

  • Grammar
  • Using Adjectives and Adverbs
  • Language Usage and Style
  • Subject-Verb Agreement
  • Avoiding Redundancies
  • Phrases and Words to Omit
  • Common English Usage Problems
  • Spelling and Spell Check
  • American English vs. British English
  • Punctuation: Using a Period or Comma
  • Writing Numerals
  • Roman Numerals

Module 7: Financial Activities

  • Bookkeeping and Accounting
  • Business Taxes
  • The Company’s Bank
  • Business and Financial Information for Small Businesses
  • U.S. Weights and Measures
  • International Weights and Measures (Metric)
  • Business Math
  • Career Advancement
  • Growing as the Company Grows
  • Presentation Skills
  • Communication Skills
  • Office Management and Supervision

Microsoft Office 365

Lesson 1: Common Office Tasks

  • All about Office 365
  • Office Interface
  • Saving Your Files
  • Manipulating the Text
  • Handling Case or Capitalization
  • Entering Symbols and Foreign Characters
  • Undoing and Repeating Commands
  • Correcting Typos
  • AutoCorrect Command

Lesson 2: One Step Beyond

  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar
  • Ways of Distributing Your Work
  • Working with Publisher
  • Printing a Publication
  • Filing Sharing and Collaborating
  • OneDrive
  • Sharing Files and Folders with Other

Lesson 3: Working with Charts and Graphs

  • Creating a Chart
  • Saving a Chart as a Template
  • Chart Tricks
  • SmartArt Diagram
  • Handling Graphics and Photos Touching Up a Picture
  • Drawing and Manipulating Lines, Shapes and Objects
  • WordArt

Lesson 4: Working with Publisher

  • Introducing Frames
  • Creating a Publication
  • Redesigning a Publication
  • Formatting Text
  • Text Wraps
  • Placeholder Pictures
  • Frames
  • Decorating the Text
  • Design Checker

Lesson 5: Working with Access

  • Tables and Queries
  • Forms
  • Creating a Database File
  • Designing a Database
  • Field Properties
  • Entering Data
  • Sorting
  • Querying
  • Filtering for Data

Lesson 6: SharePoint for End Users

  • SharePoint Overview
  • Creating Your First Site
  • Adding Content to the Team Site

Word

Lesson 1: Working with Word Part I

  • Getting Started with Word 2019
  • Formatting Text and Paragraphs
  • Working More Efficiently
  • Managing Lists
  • Adding Tables
  • Inserting Graphic Objects
  • Controlling Page Appearance
  • Preparing to Publish a Document

Lesson 2: Working with Word Part II

  • Organizing Content Using Tables and Charts
  • Customizing Formats Using Styles and Themes
  • Inserting Content Using Quick Parts
  • Using Templates to Automate Document Formatting
  • Controlling the Flow of a Document
  • Simplifying and Managing Long Documents
  • Using Mail Merge to Create Letters, Envelopes, and Labels

Lesson 3: Working with Word Part III

  • Manipulating Images
  • Using Custom Graphic Elements
  • Collaborating on Documents
  • Adding Document References and Links
  • Securing a Document
  • Using Forms to Manage Content
  • Automating Repetitive Tasks with Macros

Excel

Lesson 1: Working With Excel Part I

  • Getting Started with Microsoft Office Excel 2019
  • Performing Calculations
  • Modifying a Worksheet
  • Formatting a Worksheet
  • Printing Workbooks
  • Managing Workbooks
  • Adding Borders and Colors to Worksheets
  • Basic Excel Customization

Lesson 2: Working with Excel Part II

  • Working with Functions
  • Working with Lists
  • Analyzing Data
  • Visualizing Data with Charts
  • Using PivotTables and PivotCharts
  • Working with Graphical Objects
  • Using Array Formulas

Lesson 3: Working with Excel Part III

  • Working with Multiple Worksheets and Workbooks
  • Sharing and Protecting Workbooks
  • Automating Workbook Functionality
  • Using Lookup Functions and Formula Auditing
  • Forecasting Data
  • Creating Sparklines and Mapping Data
  • Importing and Exporting Data
  • Internationalizing Workbooks
  • Working with Power Pivot
  • Advanced Customization Options
  • Working with Forms and Controls

PowerPoint

Lesson 1: Working With PowerPoint Part I

  • Getting Started with PowerPoint 2019
  • Developing a PowerPoint Presentation
  • Performing Advanced Text Editing Operations
  • Adding and Arranging Graphical Elements
  • Modifying Graphical Elements
  • Preparing to Deliver Your Presentation

Lesson 2: Working with PowerPoint Part II

  • Customizing Design Templates
  • Using Ink to Hand Draw Elements
  • Adding Tables
  • Adding Charts
  • Working with Media
  • Building Advanced Transitions and Animations
  • Finalizing a Presentation
  • Customizing Presentation Navigation
  • Securing and Distributing a Presentation

Outlook

Lesson 1: Working with Outlook Part I

  • Getting Started With Outlook 2019
  • Formatting Messages
  • Working with Attachments and Illustrations
  • Customizing Message Options
  • Organizing Messages
  • Managing Your Contacts
  • Working with the Calendar
  • Working with Tasks and Notes

Lesson 2: Working with Outlook Part II

  • Modifying Message Properties and Customizing Outlook
  • Organizing, Searching, and Managing Messages
  • Managing Your Mailbox
  • Automating Message Management
  • Working with Calendar Settings
  • Managing Contacts
  • Managing Activities Using Tasks
  • Sharing Outlook Items
  • Managing Outlook Data Files

Related Courses


Course Administration Details:

METHODOLOGY

The instructor led trainings are delivered using a blended learning approach and comprise of presentations, guided sessions of practical exercise, web-based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

All facilitation and course materials will be offered in English. The participants should be reasonably proficient in English.

ACCREDITATION

Upon successful completion of this training, participants will be issued with an Indepth Research Institute (IRES) certificate certified by the National Industrial Training Authority (NITA).

TRAINING VENUE

The training will be held at IRES Training Centre. The course fee covers the course tuition, training materials, two break refreshments and lunch.

All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

ACCOMMODATION AND AIRPORT PICKUP

Accommodation and airport pickup are arranged upon request. For reservations contact the Training Officer.

Email:[email protected]/[email protected]

Mob: +254 715 077 817/+250789621067

TAILOR- MADE

This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our IRES Training Centre or at a convenient location.

For further inquiries, please contact us on Tel: +254 715 077 817/+250789621067

Mob: +254 792516000+254 792516010 , +250 789621067 ,or mail [email protected]/[email protected]

PAYMENT

Payment should be transferred to IRES account through bank on or before start of the course.

Send proof of payment to [email protected]/[email protected]


Share this course:


Who else has taken this course?


# Job Title Organisation Country
1 Personal Assistant Governor office CENTRAL BANK OF SOMALIA Somalia

Related Courses

People who took this course also viewed: