MS Office (Basic / Advanced)

Course details

                                       MS OFFICE
 
Course Overview              
 
Microsoft Office was primarily created to automate the manual office work with a collection of multipurpose built applications. It is a popularoffice software suite which provides programs for functions including spreadsheets, word processing, database management, email and desktop ;
 
Microsoft Office Products includes

• MS word(documentation)
• MS excel (spread sheet)
• MS power point(presentation)
• MS outlook ( sharing information & communication)

 
Objectives

This course provides the basic concepts and main features of Microsoft ;On completion of this course, the delegate will be able to create various kinds of documents, spreadsheets, power point presentation, sharing messages, creating tasks and organizing mails, 
 
Designed for

This course is suited for anyone who wants to improve their skills and  interests in micro soft Office and If you are a beginner, or looking for a Microsoft Office refresher course, start with the basic lessons and work your way up. If you have some prior knowledge and want to further your skills, jump right into intermediate or advanced lessons. You will receive a KHDA certificate for each course you successfully ;
 
Description

The course covers the main features of Word that are used by most people on a day to day basis, including spreadsheets, financial calculations, slide shows and managing automatic meeting responses.
 
MS Word Topics

• Introduction to Styles, Themes and Templates
• Managing Bulleted and Numbered Lists
• Using Quick Parts
• Headers and Footers in large documents
• Adding Text box, Tables, pictures, smart Art
• Mail merge and Tracking
• Adding Comments and views
• Hyperlink and Protecting Document
• Managing files and document printing
• Adding and editing tables
• Drop cap and border setting
• Working with Tabs and word art
• Protecting and splitting documents
• Working with tables

 
Applications

Letters, Documents, Resume, Mail Merge, Greeting cards, Flyers . 
 
MS Excel Topics

• Cell Styles and Conditional
•  Formatting
• Paste Special
• Text ,time and Date Formulas
• Sorting and Filtering Lists
• Importing and Exporting Data
• IF and Related  logical Functions
• VLOOKUP and Related Functions
• Advanced Filter / Subtotals
• Database Functions
• Multiple Workbooks / Consolidation
• Data Validation
• Pivot Tables
• Shared Workbooks / Tracking
• Protecting Worksheets
• Linking and Embedding
•  Data analyzing and Scenarios
• Sumif, countif and average if functions
• Creating and customizing pivot table with charts

Applications

• Spreadsheets
• Charts
• Numerical Calculations
• Formulas
• Financial Functions
• Dashboard & look up

 
MS Power Point Topics

• Introduction to Microsoft PowerPoint
• Creating a Presentation
• Managing Text, pictures and charts
• Presentation Designs and Formatting
• Printing PowerPoint Presentations
• Simple Animations
• Running Slide Shows
• Creating transitions between slides
• Integrating with Word and Excel
• Multimedia Objects
• Adding video and graphics
• Customizing the worksheet view
   

Applications

• Professional presentation
• Demonstration
• Lecture
• Speech
• It can include text, images, movie clip, audio, video and graphics.

 
MS Outlook Topics

• Customize message settings.
• Organize and locate outlook messages.
• Set calendar options
• Creating tasks and notes.
• Creating mail with contacts
• Creating and sending message
• Archiving outlook data

 
Applications

• Create a mail
• Organizing tasks
• Appointments
• Storing contacts
• Keeping notes

 
KHDA Certificate
 
Course completion certificate attested by KHDA(Knowledge and Human Development Authority), UAE.
 
 
 
  Updated on 10 April, 2023