MS Office (Basic / Advanced) هذه الدورة تدرس باللغة الإنجليزية

تفاصيل الدورة

This course is designed for those students who wish to learn numerous advance MS Word. Excel, PowerPoint, and Outlook features. By the end of this training one will be able to use advanced features of Word, Excel, PowerPoint, and Outlook in an office environment with maximum efficiency as well as the most important office applications which are extremely useful in secretarial routine and office administrative tasks.
It is one of the vital skills that the company seeks for in your resume. Build up your career with computer skills. LearnersPoint is here to assist you in building your career.

Course Objective
The state of UAE is the home to more than around various companies and you can be a part of them. Presently, computer knowledge is crucial especially in finding better jobs. You should be a computer literate, particularly in office application.

Outline

                                                      Excel 2016


Section 1: Formulas and Functions 
Entering Formulas
Excel Arithmetic Operators
Using AutoFill Options
Using Commonly Used Functions
Section 2: Organizing Worksheet and Table Data
Create and Modify Tables
Sorting and Filtering Data in a Table
Getting Summary Information in a Table
Section 3: Working with Charts
Summarizing Data Using Charts
Customizing Chart Data
Format Chart Legend and Titles
Creating a Pie Chart
Section 4: Working with Graphics
Adding Pictures into a Worksheet
Customizing Pictures and Objects
Adding Drawing Objects
Adding SmartArt into a Worksheet
Section 5: Managing Large Workbook
Managing Large Workbooks
Printing Worksheets
Setting Page Setup Options
Section 6: Customizing & Enhancing Workbooks
Customizing Excel to Your Work
Creating Hyperlinks
Customizing Quick Access Toolbar
 
  
                                        Word 2016
 
Lesson 1: Formatting Text & Paragraphs 
Setting Tab Stops
Organizing List Information
Lesson 2: Formatting Documents to Print
Using Headers & Footers
Proofing
Preparing for Print
Lesson 3: Using Tables in Word 16
Inserting Tables
Modifying Tables
Sorting Lists
Lesson 4: Working with Illustrations 
Inserting Pictures
Manipulating Images
Wrapping Text around a Picture
Lesson 5: Creating Mass Mailing Documents  
How do I merge?
Setting Rules for Merging
Creating Simple Mailing Documents
Lesson 6: Referencing Information
Creating an Index
Creating a Table of Contents

 
                                 PowerPoint 2016

Section 1: Working with Text 
Using an Outline
Adding Text
Using Bullets and Numbering
Formatting Text & Paragraphs
Using Text Boxes
Setting Tabs
Section 2: Adding Multimedia Elements
Using Multimedia Elements
Working With Pictures
Applying Styles & Effects
Modifying Hyperlinks
Working With SmartArt

Section 3: Enhancing Presentations
Adding Audio & Video Media
Using Animation
Managing Multiple Transitions
Changing Animation Order
Using Slide Transitions
Section 4:  Preparing The Slide Show
Reviewing The Presentation
Customizing the Presentation
Proofing the Presentation
Setting up a Slide Show
Using Presentation Tools
Using Presenter View
Rehearsing a Presentation
Presenting The Slide Show

                                       Outlook 2016

Organising Messages

• Moving Messages
• Recovering Deleted Messages
• Cleaning Up Conversations
• Working with Favourites
• Recovering Deleted Folders
• Automating Common Tasks with Quick Steps
• Customising a Default Quick Step
• Using Quick Steps
• Archiving Messages

SEARCHING

• Using Instant Search
• Expanding the Search
• Search Query Syntax
• Search Query Syntax Dates and Size
• Using Recent Searches
• Adding a Predefined Search Folder
• Customising Predefined Search Folders
• Creating a Custom Search Folder

WORKING WITH VIEWS

• Changing the Current View
• Arranging Messages Within a View
• Sorting Messages Within a View
• Working with Columns in a View
• Formatting Columns in a View
• Creating a Custom View
• Adding a Filter to a Custom View
• Deleting a Custom View

COLOUR CATEGORIES

• Creating a New Colour Category
• Assigning a Colour Category
• Finding Messages with Categories
• Removing Categories from Messages
• Deleting a Colour Category

WORKING WITH RULES

• Creating a New Rule from a Template
• Selecting the Rule Conditions
• Selecting the Rule Actions
• Selecting the Rule Exceptions
• Naming and Reviewing the Rule
• Testing the Rule
• Managing Existing Rules

EMAIL TECHNIQUES

• Effective Email Management
• Recalling a Sent Message
• Printing a Message List
• Changing the Message Format
• Choosing Themes or Stationery
• Applying a Theme or Stationery to a Message
• Turning Themes or Stationery Off
• Applying a Theme
• Sending a Voting Message
• Responding to a Voting Message
• Tracking Voting Responses
• Sending Automatic Responses

APPOINTMENTS AND EVENTS

• Quickly Scheduling an Appointment
• Scheduling Using the Appointment Window
• Rescheduling an Appointment to Another Day
• Rescheduling an Appointment to Another Time
• Creating Recurring Appointments
• Changing Recurring Appointments
• Scheduling an Event
• Scheduling Free and Busy Times
• Categorising Activities
• Printing Your Calendar
• Deleting Activities

SCHEDULING MEETINGS

• Scheduling a Meeting
• Meeting Response Options
• Responding to Meeting Requests
• Tracking Meeting Responses
• Changing a Meeting
• Adding or Removing Attendees
• Preventing Responses
• Cancelling a Meeting
• The Scheduling Assistant
• Using the Scheduling Assistant
• Scheduling Meetings Using Calendar Groups

MANAGING CONTACTS

• Pinning a Contact to Favourites
• Contacting a Contact from the People Peek
• Forwarding Contacts
• Creating a Contact Group
• Using a Contact Group
• Using a Partial Contact Group
• Linking Contacts

TASK REQUESTS

• How Task Requests Work
• Creating a Task Request
• Responding to a Task Request
• Completing an Assigned Task
• Viewing Updated Task Requests

 

 
  تحديث بتاريخ 22 August, 2024