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 presentations, guided sessions of practical exercise, web-based tutorials, and group work. Our facilitators are seasoned industry experts with years of experience, working as professionals 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 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 to 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]
- Phone: +254715 077 817
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:
- Email: [email protected]
- Phone: +254715 077 817
PAYMENT
Payment should be transferred to the IRES account through a bank on or before the start of the course. Send proof of payment to [email protected]
Click here to register for this course.
Register NowCustomized Schedule is available for all courses irrespective of dates on the Calendar. Please get in touch with us for details.
Do you need more information on our courses? Talk to us.
