Microsoft Office Diploma

In this training track, the trainee will be qualified to start working on the Microsoft Excel program completely from the beginning, by introducing the program user interface and the main tasks it performs, and the general principles of use.
In the next stage, we will go deeper into the world of data types, how to deal with and manage workbooks and worksheets, adding all types of data to sheets in a professional and clear manner, filtering and arranging data and distinguishing it visually, using conditional formatting rules, Creating, and modifying charts and a lot of advanced tools that will take you to the next level in using Microsoft Excel
Microsoft Excel is basically a Calculation program, that’s why we will deeply focus in using Different Formulas basics and advanced ones such as (aggregations, If Sum if/ifs, VLOOKUP, etc.) which will make you able to complete simple and advanced tasks easily and in no time.
And eventually, you will learn all types of worksheets and workbook protection in addition to the professional way to print out your sheets

In this course we will go through a very interesting journey, starting with the main interface of the program and going through adding and formatting all types of content such as Text, images, illustrations, tables, shapes and so much more.
The next step of this journey will be designing and formatting slides and presentations by using different background design techniques and attractive themes
Now all content and slides look great and it’s time to animate all content in a professional and attractive way in addition to making dynamic slide transitions
Now we have arrived at the last station, and it is time to start the show, print the presentation, and save it in different formats

In this course, we will learn to create integrated Microsoft Word files, starting with the program interface and basics of writing, passing through and adding all types of content to the file pages such as images, illustrations, tables, etc.
you will also be able to format and design the document in a professional way in addition to different ways to Protect the file as well as print it professionally

• using Basic and advanced formulas for complicated calculations
• present data on the right chart type
• Format, manage and modify charts
• manage worksheets content
• finish daily tasks in much shorter time
• Create and manage drop lists
• Sorting and filtering data in the right way
• Protect your workbooks and worksheets
• Print worksheets and solve all printing problems
• Split and merge columnsRemove duplicated data easily
• Using all types of conditional formatting rules

• Using Microsoft PowerPoint in the right way to create professional presentations
• Understanding slides layouts
• Typing and formatting text
• Adding and formatting images and shapes
• Adding, formatting, and modifying Tables
• Adding and formatting SmartArt and charts
• Format slides using different background styles
• Format your presentation using Themes
• Deep understating for content animations
• Apply animation to all types of content
• Apply slide transitions to your presentation
• Showing your presentation and using helping tools
• Save and print your presentation in a professional way

• familiar with the user interface of the program
• Understand the basics of writing in Microsoft Word
• Add and format all types of data such as images, tables, illustrations, and others
• Adjust header and footer
• Apply Page Boarders and watermark to file pages
• Adjust page size and margins
• Save and protect the file
• Print file pages properly
• Protect Document

Microsoft Office Diploma