MICROSOFT OFFICE MASTERY SERIES

 

COURSE REQUIREMENT

• Participants should be able to use a PC at the beginner level;
• Basic knowledge and functionality of Microsoft Word;
• Microsoft Office 2013 and above

 

MICROSOFT WORD

Microsoft Word is an under-rated software. Most of the Users will assumed that Microsoft Word is a very easy software to learn and use. There is some truce in the statement. Microsoft Word is a very powerful word processing software. It can be used to write letters, proposals, articles, marketing mailing tools, and more. Not only it has vast applications, but it can be done very fast if you know the right way to use it.

 

LEARNING OUTCOME

Upon completion of the Microsoft Word session, users can:

• Use the Word Styles to simplify Formatting and create Table of Contents.
• Create and use the Building Block (AutoText) to simplify the workflow.
• Design Word document with confident.

 

COURSE OUTLINE

MODULE 1 : EXPOSE THE SECRET BUILDING BLOCK IN MS WORD

• What is the Building Block?
  • Locate the Building Block
  • Super Shortcut : add AUTOTEXT to the Building Block
  • Maximize the advantage of using AutoText in Microsoft Word.
  • Administer the AutoText Entry.

MODULE 2 : LET‘S OUTDO THE MANUAL FORMATTING

• The magical world of Word Styles
  • Discover how you can format easily using Word Styles.
  • Modify the whole document formatting like a Superhero in just seconds.
• Why applies Styles? What else can it do?
  • Prepare a Table of Contents in just 3 Clicks… yes 3 Clicks. It is not a Joke.
  • Be amazed with the flexibility to Modify and Update the TOC.

MODULE 3 : GET READY TO DESIGN A MAGAZINE ALIKE DOCUMENT

• What does Magazine look alike document?
• Turn a single column document to multi column document.
• Explore the Sections in a Document.
  • Adding, Modify and Remove Sections in the Document.
• Pictures Speaks a thousand words
  • Place the picture anywhere you want.
  • Wrap the Text around the Image

 

MICROSOFT EXCEL

Many people have always been pressed to understand the best of Microsoft Excel. You will be making your Microsoft Excel the best companion in this course and generating the best report using Microsoft Excel faster than you might imagine. The course is designed to help users bridge the gap between their current Excel expertise and the final report they want. Impress the boss with excellent reports and get the management’s attention.

LEARNING OUTCOME

Upon completion of the Microsoft Excel session, users can:

• Apply all the Best practices in Microsoft Excel.
• Write Excel Formulas to clean up messy data.
• Navigate and manage worksheets like a Excel Master.

COURSE OUTLINE

MODULE 1 : NAVIGATE AND PASTE IN A SPECIAL WAY WITHIN EXCEL

• How to instruct Excel to Select what we want?
• Select Blank cells and summarized Data Quickly… just ONE click.
• Calculate in Microsoft Excel without Formula… just Paste Operation.

MODULE 2 : THE BENEFIT OF EXCEL TEXT FUNCTIONS

• Data Cleansing can be difficult but not with Text Functions.
• Convert data can never be easier.

MODULE 3 : WORK WITH MULTIPLE WORKSHEETS THE EASY WAY

• Navigate between the Sheets can never be any easier
• Arrange multiple worksheet side by side within the same File.

MODULE 4 : DATA ANALYSIS AND INTERACTIVE REPORT USING PIVOTTABLE

• Managing a Data with Table
• Generate quick reports with PivotTable
• Analyze data with Grouping and Calculated Field
• Present Complex Data in Mini Dashboard

 

MICROSOFT POWERPOINT

Microsoft PowerPoint is a presentation software that enables users to create engaging presentations. PowerPoint enables users to add animation and effects to slideshow elements. As a presentation tool PowerPoint can be used to organize and structure your presentations, create a professional and consistent format for the content of your presentation, and animate your slides to give them greater visual impact.

LEARNING OUTCOME

Upon completion of the Microsoft PowerPoint course, participant will learn:

• Present your PowerPoint Slides like a Professional Speaker.
• Add Content to the Slides from any source.
• Apply custom Slides Presentation using one Deck of Slides.

COURSE OUTLINE

MODULE 1 : INTRODUCTION TO POWERPOINT

• PowerPoint Slides Guidelines
• PowerPoint Presentation and Controls

MODULE 2 : SLIDE CONTENTS – TEXT CONTENTS

• Prepare contents using Microsoft Word.
• Import text from Microsoft Word.

MODULE 3 : PREPARING MODERN SLIDE WITH ANIMATION

• Apply Morph and Zoom effect to Objects, Texts and Images

MODULE 4 : FINALIZING POWERPOINT SLIDES

• Use Custom Slide Show
• Reuse Slides

 

WHO SHOULD ATTEND ?

Open to all who want to enhance their skill and competency in Microsoft Office platform.

 

FEES

INDIVIDUAL RM1,000.00 per pax

EARLY BIRD RM800.00 per pax

(payment 14 days before the program)

2 PAX  RM900.00 per pax

3 PAX or  > RM850.00 per pax

(Fees – without accomodation)

 

TRAINER

Shamsiyah Abdul Kadir

Kelvin Ng Choo Kent