Course Code: IT 11440
235 Course Visits
Microsoft Office
Course Sector:
Information Technology
Course Dates and Locations
Choose a date and location to book your seat
No.
Date
Days
Location
Fees
Enrollment
No available dates now, will be added soon..
Introduction
Training course introducion / brief
This training course is designed to provide participants with the basic and advanced techniques needed to use all Microsoft Office programs. This course will allow participants to explore the Microsoft office environment and create a presentation.
You will acquire advanced skills working within Microsoft Word, Excel, PowerPoint, Outlook, and Access.
Course Objectives
At the end of the training course, participants will be able to
  •       Master creating and editing formulas, audit equations, and present information in charts and tables
  •      Understand How to create and format professional business documents, including mail merges, Web pages, and interactive forms
  •       Master creating slide presentations, including editing graphics, formatting text and text boxes, and animating objects and transitions
  •    Understand How to create and edit Outlook objects, such as e-mail, meetings, tasks, and contacts
  •      Master creating and Managing databases, including creating tables, forms, reports and strategies for archiving data with Action Queries
Course Audience
Who is this course for, and can benefit the most

Anyone looking for developing his/her professional life efficiently by enhancing knowledge and improving the use of all Microsoft Office programs

Course Outline
The course aims and learning outcomes

 Introduction to Microsoft Excel

          Creating a Microsoft Excel Workbook

•                The Ribbon

•                The Backstage View (The File Menu)

•                Entering Data in Microsoft Excel Worksheets

•                Formatting Microsoft Excel Worksheets

•                Using Formulas in Microsoft Excel

•                Working with Rows and Columns

•                Editing Worksheets

•                Finalizing Microsoft Excel Worksheets

•                Microsoft Excel Features that Were New in 2013

•                Features New in 2019

•                Introduction to Microsoft Excel 2016 Exam

 

 Intermediate Microsoft Excel 2019

•                Advanced Formulas

•                Working with Lists

•                Working with Illustrations

•                Visualizing Your Data

•                Working with Tables

•                Advanced Formatting

•                Microsoft Excel Features that Were New in 2013

•                Features New in 2019

•                Intermediate Microsoft Excel 2019 Exam

 

 Advanced Microsoft Excel 2019

•                Using Pivot Tables

•                Auditing Worksheets

•                Data Tools

•                Working with Others

•                Recording and Using Macros

•                Random Useful Items

•                Microsoft Excel Features that Were New in 2013

•                Features New in 2019

•                Advanced Microsoft Excel 2019 Exam

 

 Practical Application

Introduction to Microsoft Word 2019

    A.    Creating a Microsoft Word Document 
    B.    The Ribbon 
    C.    The File Tab 
    D.    The Quick Access Toolbar 
    E.    Formatting Microsoft Word Documents 
    F.    Editing Documents 
    G.    Finalizing Microsoft Word Documents 
    H.    Introduction to Microsoft Word 2019 Exam


  Intermediate Microsoft Word 2016
    A.    Advanced Formatting  
    B.    Working with Tables 
    C.    Working with Images 
    D.    Page Layout 
    E.    Working with Illustrations 
    F.    Viewing Your Document(s) 
    G.    Intermediate Microsoft Word 2019 Exam


Advanced Microsoft Word 2019
    A.    Working with Long Documents 
    B.    Reviewing and Collaborating on Documents 
    C.    Comparing and Combining Documents 
    D.    Managing Mailings 
    E.    Protecting Documents 
    F.    Random Useful Items 
    G.    Advanced Microsoft Word 2019 Exam


  Practical Application

Introduction to Microsoft PowerPoint 2019
    A Creating a PowerPoint Presentation
    B.    The Ribbon
    C.    The Quick Access Toolbar
    D.    The Backstage View (The File Menu)
    E.    Formatting Microsoft PowerPoint Presentations
    F.    Working with Images
    G.   Working with Tables and Charts
    H.    Finalizing Microsoft PowerPoint Presentations
    I.      Introduction to Microsoft PowerPoint 2019 Exam

 Advanced Microsoft PowerPoint 2019
    A.    Customizing Presentations
    B.    Presentation Masters 
    C.    Working with Special Effects 
    D.    Using SmartArt
    E.    Multimedia
    F.    Setting up the Slide Show
    G.    Outlines and Slides
    H.    Managing Multiple Presentations
    I.    Sharing and Securing a Presentation 
    J.    Features New in 2019
    K.   Advanced Microsoft PowerPoint 2019 Exam


Practical Application

Introduction to Microsoft Outlook 2019
    A.    The Outlook 2019 Interface
    B.    Performing Popular Tasks in Outlook 2019
    C.    Working with Messages
    D.    Working with the Calendar
    E.    Organizing Contacts
    F.    Introduction to Microsoft Outlook 2019 Exam


Advanced Microsoft Outlook 2019
    A.    Working with Tasks and Notes
    B.    Using Signature and Themes
    C.    Managing Your Inbox
    D.    Working with Multiple Email Accounts
    E.    New Features in 2019 
    F.    Advanced Microsoft Outlook 2019 Exam


  Practical Application


 Introduction to Microsoft Access 2019
    A.    Quick Overview of the Access User Interface  
    B.    Fundamentals  
    C.    Tables and Their Views  
    D.    Tables  

 Queries  
    F.    Forms  
    G.    Reports  
    H.    Databases and Access Terms  
    I.    Introduction to Microsoft Access 2019 Exam

  
 
Advanced Microsoft Access 2019
    A
   Relationships  
    B.    Queries  
    C.    Table Functions  
    D.    Forms  
    E.    Reports  
    F.    Macros  
    G.    Completing the Desktop Application  
    H.    Advanced Microsoft Access 2019 Exam  


  Practical Application
Providers and Associations
Providing the best training services and benefits to our valued clients
Boost certificate of completion
BOOST's Professional Attendance Certificate “BPAC” is always given to the delegates after completing the training course, and depends on their attendance of the program at a rate of no less than 80%, besides their active participation and engagement during the program sessions.
ENDORSED EDUCATION PROVIDER
Over all rating
Excellent
Average
Below average
Flexible deadlines
Customized dates accordance to your schedule
Shareable Certificate
Earn certificate upon completion
COURSE METHODOLOGY

Our Training programs are implemented by combining the participants' academic knowledge and practical practice (30% theoretical / 70% practical activities).

At The end of the training program, Participants are involved in practical workshop to show their skills in applying what they were trained for. A detailed report is submitted to each participant and the training department in the organization on the results of the participant's performance and the return on training. Our programs focus on exercises, case studies, and individual and group presentations.

Trending Courses
The most bespoke and flexible training courses
10
Feb
- 05 -
Days
The Scheduling Professional (PMI-SP Exam Preparation)
Dubai, UAE
07
Apr
- 05 -
Days
IOSH Managing and Working Safely
Abu Dhabi, UAE
17
Feb
- 05 -
Days
Artificial Intelligence for Leaders
Abu Dhabi, UAE
01
Sep
- 05 -
Days
Introduction to Machine Learning and Artificial Intelligence
Abu Dhabi, UAE
30
Jun
- 05 -
Days
The Risk Management Professional (PMI-RMP Exam Preparation)
Istanbul, Turkey
01
Sep
- 05 -
Days
Certified Business Analysis Professional- IIBA
Dubai, UAE
24
Nov
- 03 -
Days
Happiness To Have and Hold
Dubai, UAE
20
Jan
- 05 -
Days
Leading and Building a Positive, Motivated, and Empowered Teams
Online, Virtual
10
Aug
- 05 -
Days
Emotional Intelligence and Advanced Communication Skills for Leaders
Salalah, Oman
13
Apr
- 05 -
Days
OSHA: Occupational Safety and Health Administration Standards
Riyadh, KSA
10
Nov
- 05 -
Days
Practical Negotiation Skills for Contract Management
Jeddah, KSA
14
Sep
- 05 -
Days
Competitive Bidding: Understanding Procurement Bids
Riyadh, KSA
18
May
- 05 -
Days
Professional in Business Analysis (PMI-PBA Exam Preparation)
Jeddah, KSA
18
Aug
- 05 -
Days
ISO 55001 2014 Lead Auditor (Asset Management Systems) – Lead Auditor
Muscat, Oman
20
Jan
- 05 -
Days
Certified Treasury Professional
Dubai, UAE
15
Dec
- 05 -
Days
The Business Analyst (PBA) - PMI Certified
Dubai, UAE