Website

MS Office

Word

Powerpoint

Excel

Excel Adv

Japanese

3D Printing

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)

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

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

Very Good Experience! Wish U can come!