Module 2 - Creating and Publishing

At the end of this module, you will be able about:

• Inserting pictures and charts, and adding descriptions to them 
• Using appropriate structures for the templates such as headings and titles
• Saving files and converting them into different types of files
• Using Spreadsheet and formatting cells
• Creating and Editing some Advanced Formulas
• Sorting and Filtering ,and Creating Tables
• Creating, editing and formatting a power-point presentation 

Please watch all videos and review the PDF slides. After each module, take a moment to check your understanding with the quiz. At the end of the course, you will get the opportunity to take an exam to get a certificate.

2.1 Microsoft Word – Saving and text formats

In this part we are going to learn about saving as pdf, font and line spacing, inserting image and formatting, adding caption and shapes, Inserting special character and symbols up to creating different types of charts.

2.2 Inserting tables in MS Word

This video will teach us how to create a tables  and charts in Microsoft Word, and sorting information in table. 

2.3 Microsoft Excel

In this video, we are going to learn how to use and create tables including pivot tables. We shall focus more on filtering information using pivot tables.

2.4 Using Excel formulas

In this video, we are going to learn how to use and create tables including pivot tables. We shall focus more on filtering information using pivot tables.

2.5 Sort, filter and conditional formatting

In this lesson we are going to learn about two major things used in Excel, Conditional Formatting to highlight cells based on specific criteria, and Sorting and Filtering.

2.6 Power Point

In this video we are going to learn text formatting on different slides, format shapes and applying animations on your power-point presentation.

2.7 Slide Show

In this lesson we shall elaborate more about Formatting text, Using master page, Inserting Images from the Gallery, outline view, slide sorter and slide show. Finally we shall learn how to save a presentation into different types and display slide show.

To review the course or come back to a specific lesson, check out the PDF:

Once you have finished and revised this module, check your understanding: Click here