top of page

Microsoft MS Office Excel, Word and PowerPoint 

2013, 2016, 2019 and 365

Well Delivered, Effective Instructor! Empowered & Confident to use MS Office

Very Excellent Course! Great Instructor!

Microsoft Office Course Plan:


Microsoft MS Excel (Basic to Intermediate)


  • Purpose of Excel

  • Navigate and Select Cells in Worksheets 

  • Create a Basic Worksheet 

  • Inputting data

  • Inserting, Renaming, Deleting Rows and Columns 


  • Add Borders and Colours to Cells

  • Change column width and row height

  • Merge Cells and Wrap Text

  • Apply Number Formatting 

  • Apply Font Properties 


  • Edit Worksheet Data 

  • Find and Replace Data 

  • Autofill Data

  • Data Segregation using Text to Column

  • Working with Lists - Sorting and Filtering (> vs >=, <  vs <=, AND vs OR).

  • Sort and Filter by Color

  • Deleting Every Other Row



  • Create Formulas in a Worksheet 

  • Understand commonly used Functions like SUM, AVERAGE, MIN, MAX, COUNT, ROUND, ROUNDUP, ROUNDDOWN.

  • Insert Functions in a Worksheet 

  • Reuse Formulas


  • Create Formulas using $ sign 


  • Convert Text to Column

  • Transposing Data 


  • Inserting Header and Footer 

  • Align Content in a Cell 

  • Apply Page Break, Split and Freeze Panes


  • Creating 2D and 3D Charts

  • Showing Data Labels, Legend, Titles, Format

  • Moving and copying Worksheet 

  • Inserting, Renaming, Deleting, Hiding Worksheet 

  • Save and Print a Worksheet

  • Recording Macro



  • How to improve productivity by doubling typing speed for reports, emails, internet search, etc


  • Learning the main features in the MS Word environment

  • Understanding the Word Program Screen Using Keyboard Shortcuts

  • Navigating, Browsing & Viewing a Document 

  • Copying & Moving Text Collecting Multiple Items to Move or Copy

  • Inserting Symbols & Special Characters like POã䯮¬

  • Bullets, Numbering and Multi-Level List


  • Using Undo, Redo

  • Finding Text & Replacing Text automatically

  • Checking Spelling & Grammar 

  • Using Word Count


  • Advantages of and using multiple Columns

  • Difference and adding Column, Page and Section Breaks

  • Showing and Hiding Editing Marks


  • Indents and Margins

  • Adding Page Number and Total Pages

  • Using Headers & Footers

  • Portrait vs Landscape


  • Changing Font Type, Size & Colour 

  • Changing Font Styles & Effects

  • Comparing & Cleaning Up Styles    

  • Applying Document Themes  


  • Inserting Clip Art, Inserting Screenshots, Inserting Pictures & Graphics 

  • Formatting Pictures or Graphics

  • Inserting Shapes & Formatting Shape     

  • Aligning & Distributing Objects      

  • Flipping & Rotating Objects, Layering Objects 

  • Inserting a Text Box and Understanding difference with text


  • Mail Merge to automate tasks

  • Importing existing lists

  • Creating emails with different names and data

  • Creating invoices and report with different names and data



Lesson 1: Getting Started

A: Navigate the PowerPoint Environment 

B: Create and Save a PowerPoint Presentation 

C: Create impressive background with Gradient fill and Title tracking 


Lesson 2: Developing a Presentation 

A: Select a Presentation 

B: View and Navigate a Presentation 

C: Edit Text Topic 

D: Build a Presentation 

E: Using Eyedropper

F: Portrait and Landscape


Lesson 3: Performing Advanced Text Editing

A: Format Characters

B: Format Paragraphs

C: Format Text Boxes

D: Create Wavy and Circular Text

E: Create 3D text and adjusting depth and rotation


Lesson 4: Adding Graphical Elements 

A: Insert Clip Art and JPEG, GIF Images and Video

B: Insert Shapes 

C: Make 2D image become 3D automatically


Lesson 5: Modifying Objects 

A: Edit Objects 

B: Format Objects 

C: Group Objects 

D: Arrange Objects 


Lesson 6: Adding Tables 

A: Create a Table 

B: Format a Table  

C: Insert a Table from Other Microsoft Office Applications 


Lesson 7: Adding Charts 

A: Create a Chart 

B: Format a Chart 

C: Insert a Chart from Microsoft Excel


Lesson 8: Animations and Transitions

A: Transitions between Slides

B: Animations within a Slide: Entrance, Emphasis and Exit Effects

C: Animation Sequence, Start, Duration, Delay

D: Sound

Lesson 9: Using Action Buttons

A: Add buttons to navigate to various parts of the presentation

B: Add buttons to run an application

C: Add buttons to browse a website


Lesson 10: Presentation Tips and Actual Presentation

A: Have a great start

B: Learn about 10/20/30 rule

C: Understand importance of content versus delivery

D: Understand important of eye contact, body language, power of pause

E: Have meaningful comparisons

Very useful course! I assure you instructor is knowledgeable and expert!

Very Good Experience! Wish U can come!

bottom of page