MS Office

Learn about the basic concepts and main features of Microsoft Office. You will learn to work with a range of Office suite applications and create different documents, PowerPoint presentations, spreadsheets, organizing mails, and much more. 

Applications:

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

Topics:

MS Word:

• 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

MS Excel:

• 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

MS PowerPoint:

• 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

MS Outlook:

• 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

KHDA Certificate:

• Course completion certificate attested by KHDA (Knowledge and Human Development Authority), UAE.