
The 1st Microsoft Word lecture starts by explaining how Microsoft Word software functions and how to navigate around. Tasks, such as adjusting font type, font size, font colour, alignment and line spacing options are covered in this lecture.
Note: Please download/print the handout.
Coverage: Task 1 and 2
The 2nd Microsoft Word lecture covers about table: how to use ruler, adjust table column width, setting alignment inside table, insert decimal tab, background color, etc.
Note: Please download/print handout from Microsoft Word (Lecture 2 of 6)
Coverage: Task 3, 4 and 5
The 3rd Microsoft Word lecture starts by demonstrating how left, centre and right tabs work. This lecture also cover header and footer, as well as auto-page numbering.
Note: Please download/print handout from Microsoft Word (Lecture 2 of 6)
Coverage: Task 6, 7, 8 and 9
In this 4th Microsoft Word lecture, special fonts such as superscript, subscript and strikethrough are demonstrated. On top of that, exceptional useful functions such as Find, Replace and frequently used shortcut keys are covered.
Note: Please download/print handout from Microsoft Word (Lecture 2 of 6)
Coverage: Task 10, 11, 12, 13 and 14
The 5th Microsoft Word lecture begins by explaining why page break and section break knowledge is so important! By inserting page break helps to save time in removing unnecessary spaces between pages. Meanwhile, the insertion of section break allows different page orientation.
Note: Please download/print handout from Microsoft Word (Lecture 2 of 6)
Coverage: Task 15 and 16
This is the final lecture for Microsoft Word. In this lecture, useful Word functions such as Spelling and Grammar, Thesaurus, Split, New window and etc are shown.
Note: Please download/print handout from Microsoft Word (Lecture 2 of 6)
Coverage: Task 17, 18, 19 and 20
In the 1st Microsoft PowerPoint lecture, the whole coverage of PowerPoint section is shown. Learners are highly encouraged to prepare these slides from scratch, so that PPT skills are picked up in a faster and more efficient manner. Coverage of this lecture includes insert new slide, select PowerPoint design, insert and crop image, etc.
The 2nd Microsoft PowerPoint lecture covers transition effect, animation effect, different slides types, difference between left and justify alignment, design ideas and etc.
The 3rd Microsoft PowerPoint begins by demonstrating how multiple images could be inserted at one go. Further animation settings such as on click, with previous, after previous, animation flow, delay animation effects and etc are covered in this lecture.
In the 4th Microsoft PowerPoint lecture covers how shapes and text within shapes are inserted to slides. Additional quick tips are provided to increase work efficiency. Advance animation settings are further practiced in this lecture.
What if your presentation requires images and words to come out together? That is what we will cover in the 5th Microsoft PowerPoint lecture. Special effects such as creating and grouping image and textbox together, customize arrows, preset default shapes, customize animation panes and many more.
This is the last Microsoft PowerPoint lecture. In this lecture, it is demonstrated how a video is inserted and how transition effect to all slides are added. The newly completed PPT file is presented in this lecture.
The 1st Microsoft Excel lecture begins by explaining about what Microsoft Excel software is about and how to navigate around using this spreadsheet. The lecture continues to cover about columns, rows, format cells, basic formula and etc.
Note: Please download/print the handout.
Coverage: Data Entry, Basic Formula and Copying
The 2nd Microsoft Excel lecture covers how to set absolute cell reference formula. An example is provided to allow learners to fully understand under what condition a formula should be on relative cell and absolute cell. Apart from that, cells formatting such as wrap text, merge cells and alignment is demonstrated in this lecture.
Note: Please download/print handout from Microsoft Excel (Lecture 2 of 8)
Coverage: Using Absolute Cell Referencing
In this 3rd Microsoft Excel lecture, IF formula which is also known as conditional logic is demonstrated. On top of that, the lecture illustrate how an IF formula could be formulated with greater than condition.
Note: Please download/print handout from Microsoft Excel (Lecture 2 of 8)
Coverage: Working with Conditional Logic
The 4th Microsoft Excel lecture covers how Excel data could be used in producing a line chart, including chart title, axis title, data labels and etc. The lecture also demonstrate how a completed chart could be changed to another chart type without losing the customized information.
Note: Please download/print handout from Microsoft Excel (Lecture 2 of 8) and chart data in Excel file from this lecture’s downloadable materials.
Coverage: Drawing line chart & clustered column chart
The 5th Microsoft Excel lecture illustrate how pie chart is to be prepared. This lecture shows how continuous cells and non-continuous cells are to be selected in drawing 2 pie charts. The lecture continues by personalize the chart by including details such as chart title, axis title, data labels and etc.
Note: Please download/print handout from Microsoft Excel (Lecture 2 of 8) and chart data in Excel file from Lecture 4 of 8.
Coverage: Drawing pie charts
The 6th Microsoft Excel lecture covers a comprehensive exercises which required multiple functions to be performed. This lecture covers from task no. 1 to task no. 7. Skills learned in this lecture include how content is copied from PDF to Excel with information remains in useable format, data sorting and vlookup function.
Note: Please download/print handout from Microsoft Excel (Lecture 2 of 8)
Coverage: Multiple functions (task no. 1 to 7)
The 7th Microsoft Excel lecture continues the multiple function exercise from task no. 8 to task no. 13. Learners are able to pick up how to format cells, insert new column, perform nested IF formula, add filter and etc.
Note: Please download/print handout from Microsoft Excel (Lecture 2 of 8)
Coverage: Multiple functions (task no. 8 to 13)
The 8th Microsoft Excel lecture continues the multiple function exercise from task no. 14 to task no. 17. In this lecture, tasks include print set-up which involves setting header and footer, placing auto-page numbering, setting certain row to appear in every page and etc. On top of that, this lecture also covers hiding columns, printing document as PDF file and protecting Excel file with password.
Note: Please download/print handout from Microsoft Excel (Lecture 2 of 8)
Coverage: Multiple functions (task no. 14 to 17)
This course is about Microsoft Office 365, which comprises of Microsoft Word, Excel and PowerPoint. The teaching approach uses efficient and effective hands-on manner to allow learners to pick up the knowledge and skills easily.
Learners are not required to have any pre-requisite knowledge as this course is specially designed for beginners with no basic knowledge. Upon the completion of this course, learners will be able to perform tasks on their own (independently) using Microsoft Word, Excel and PowerPoint.
Learners are highly encouraged to perform the exercises together. This is because hands-on approach has demonstrated the learners are able to remember and apply what they have learned after completing the course.
Instead of merely running through functions, hands-on exercises using easy to understand work-related tasks are used. Downloadable and printable handout are also provided to assist the hands-on learning to be carried out smoothly.
The whole course has 20 lectures, which stood up of 6 lectures on Microsoft Word, 6 lectures on Microsoft PowerPoint and 8 lectures on Microsoft Excel. The coverage of the course in Microsoft Word section, include tasks such as header, footer, auto page numbering, insert table, page break, section break and many more. In the Microsoft Excel section, on the other hand, covers format cells, setting formula, perform conditional formatting, vlookup, print setting, charts and many more. Lastly, Microsoft PowerPoint equip learners with the ability to prepare slides with transition and animation effects, on top of adding photos, videos and shapes with words.