Microsoft Office Course Plan:

 

Microsoft MS Excel (Basic to Intermediate)

4hrs

• 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

 

4hrs

• 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 

• IF, SUMIF and COUNTIF

• 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

​

MS WORD

2hrs

• 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

​

MS POWERPOINT

6hrs  

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