MS OFFICE FULL COURSE

Course Overview www.gteceducation.com.sg

This course covers Basic to Advanced topics of MS Word, MS Excel, MS

PowerPoint and Internet and Emailing.

Entry Requirement : Beginners of MS Office

Course Duration : 30hrs.

Mode of Training : Face to face Instructor led Training

Materials : Course books will be provided to each participant

Course Content

MS WINDOWS, COMPUTER BASICS

 Computer Basic, Creating Folder, Paint

 Directories, input units, Output unit
 Central Processing Units,
 What is hard ware, what is Soft ware
 Windows short cut keys

MS WORD

Module 1: Text Basics

 Typing the text, Alignment of text

 Editing Text: Cut, Copy, Paste, Select All, Clear
 Find & Replace

Module 2: Text Formatting and saving file

 New, Open, Close, Save, Save As

 Formatting Text: Font Size, Font Style
 Font Color, Use the Bold, Italic, and Underline
 Change the Text Case
 Line spacing, Paragraph spacing
 Shading text and paragraph
 Working with Tabs and Indents

1 Sophia Road, #02-03, Peace Centre, Singapore 228149.

Phone: 63360244, 9650 3505, Email: [email protected]
Registered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Module 3: Working with Objects Module 9: Sharing and Maintaining
Document
 Shapes, Clipart and Picture, Word Art, Smart Art
 Columns and Orderings - To Add Columns to a  Changing Word Options
Document  Changing the Proofing Tools
 Change the Order of Objects  Managing Templates
 Page Number, Date & Time  Restricting Document Access
 Inserting Text boxes  Using Protected View
 Inserting Word art  Working with Templates
 Inserting symbols  Managing Templates
 Inserting Chart  Understanding building blocks

Module 4: Header & Footers Module 10: Proofing the document

 Inserting custom Header and Footer  Check Spelling As You Type.

 Inserting objects in the header and footer  Mark Grammar Errors As You Type.
 Add section break to a document  Setting AutoCorrect Options

Module 5: Working with bullets and Module 11: Printing

numbered lists
 Page Setup, Setting margins
 Multilevel numbering and Bulleting  Print Preview, Print
 Creating List
 Customizing List style MS EXCEL
 Page bordering
 Page background Module 12: Introduction to Excel

Module 6: Tables  Introduction to Excel interface

 Understanding rows and columns, Naming Cells
 Working with Tables, Table Formatting  Working with excel workbook and sheets
 Table Styles
 Alignment option Module 13:Formatting excel work book:
 Merge and split option
 New, Open, Close, Save, Save As
Module 7: Styles and Content  Formatting Text: Font Size, Font Style
 Font Color, Use the Bold, Italic, and Underline
 Using Build- in Styles, Modifying Styles  Wrap text, Merge and Centre
 Creating Styles, Creating a list style  Currency, Accounting and other formats
 Table of contents and references  Modifying Columns, Rows & Cells
 Adding internal references
 Adding a Footnote Module 14: Perform Calculations with
 Adding Endnote Functions

Module 8: Merging Documents  Creating Simple Formulas

 Setting up your own formula
 Typing new address list  Date and Time Functions, Financial Functions
 Importing address list from Excel file  Logical Functions, Lookup and Reference
 Write and insert field  Functions Mathematical Functions
 Merging with outlook contact  Statistical Functions, Text Functions.
 Preview Result
 Merging to envelopes Module 15: Sort and Filter Data with Excel
 Merging to label
 Setting rules for merges  Sort and filtering data
 Finish & Merge options  Using number filter, Text filter
 Custom filtering
 Removing filters from columns
 Conditional formatting

1 Sophia Road, #02-03, Peace Centre, Singapore 228149.

Phone: 63360244, 9650 3505, Email: [email protected]
Registered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Module 16: Create Effective Charts to Present MS POWERPOINT
Data Visually
Module 21: Setting Up PowerPoint
 Inserting Column, Pie chart etc. Environment:
 Create an effective chart with Chart Tool
 Design, Format, and Layout options  New, Open, Close, Save, Save As
 Adding chart title  Typing the text, Alignment of text
 Changing layouts  Formatting Text: Font Size, Font Style
 Chart styles  Font Color, Use the Bold, Italic, and
 Editing chart data range Underline
 Editing data series  Cut, Copy, Paste, Select All, Clear text
 Changing chart  Find & Replace
 Working with Tabs and Indents
Module 17: Analyze Data Using PivotTables Module 22:Creating slides and applying
and Pivot Charts themes

 Understand PivotTables, Create a PivotTable  Inserting new slide

 Framework Using the PivotTable and PivotChart  Changing layout of slides
 Create Pivot Chart from pivot Table.  Duplicating slides
 Inserting slicer  Copying and pasting slide
 Creating Calculated fields  Applying themes to the slide layout
 Changing theme color
Module 18: Protecting and Sharing the  Slide background
work book  Formatting slide background
 Using slide views
 Protecting a workbook with a password
 Allow user to edit ranges Module 23: Working with bullets and
 Track changes numbering
 Working with Comments
 Insert Excel Objects and Charts in Word  Multilevel numbering and Bulleting
Document and Power point Presentation.  Creating List
 Page bordering
Module 19: Use Macros to Automate Tasks  Page background
 Aligning text
 Creating and Recording Macros  Text directions
 Assigning Macros to the work sheets  Columns option
 Saving Macro enabled workbook
Module 24: Working with Objects
Module 20: Proofing and Printing
 Shapes, Clipart and Picture, Word Art, Smart
 Page setup, Setting print area, Print titles Art
 Inserting custom Header and Footer  Change the Order of Objects
 Inserting objects in the header and footer  Inserting slide header and footer
 Page Setup, Setting margins, Print Preview, Print  Inserting Text boxes
 Enable back ground error checking  Inserting shapes, using quick styles
 Setting AutoCorrect Options  Inserting Word art
 Inserting symbols
 Inserting Chart

Module 25: Hyperlinks and Action Buttons

 Inserting Hyperlinks and Action Buttons

 Edit Hyperlinks and Action Button
 Word Art and Shapes

1 Sophia Road, #02-03, Peace Centre, Singapore 228149.

Phone: 63360244, 9650 3505, Email: [email protected]
Registered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Module 26: Working With Movies and Module 30: Slide show option
Sounds
 Start slide show
 Inserting Movie From a Computer File  Start show from the current slide
 Inserting Audio file  Rehearse timing
 Audio Video playback and format options  Creating custom slide show
 Video options, Adjust options
 Reshaping and bordering Video Module 31: Proofing and Printing

Module 27: Using SmartArt and Tables  Check Spelling As You Type
 Setting AutoCorrect Options
 Working with Tables, Table Formatting  Save as video
 Table Styles  Save as JPEG files
 Alignment option  Save as PowerPoint Show file
 Merge and split option  Print Preview, Print
Converting text to smart artModule 28:
Animation and Slide Transition
INTERNET & E-MAIL
 Default Animation, Custom Animation
 Modify a Default or Custom Animation  What is Internet?, Receiving Incoming Messages
 Reorder Animation Using Transitions  Sending Outgoing Messages, Email addressing
 Apply a Slide Transition, Modifying a  Email attachments, Browsing, Search engines
 Transition, Advancing to the Next Slide  Text chatting, Job Searching
 Downloading video and Music
Module 29: Using slide Master  Uploading Video or Music, Voice chatting,
Webcam Chatting etc.
 Using slide master  Introduction to Blogging, Facebook
 Inserting layout option
 Creating custom layout
 Inserting place holders
 Formatting place holders

1 Sophia Road, #02-03, Peace Centre, Singapore 228149.

Phone: 63360244, 9650 3505, Email: [email protected]
Registered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Student’s Testimonial

MS Office-“I will encourage everyone to come for the Ms Office Basic course as the lessons are relevant
to work. Teachers are willing to teach until I understood my work”.
Odin Marine (Singapore) Pte Ltd, Admin Assistant

MS Word-"Next time I want to do another computer course I will definitely consider G-Tec".
Homemaker, Singapore

MOS Excel core-"The instructor is friendly and approachable. The course is taught in a detailed and
structured way"
Assistant Engineer, Singapore

Java/J2EE Programming Course- “This is the best institution I found in Singapore.Because here the
trainer as well as training was good. The trainers are very good because if we have any doubts they are
giving clarification through mail even after the course completed (Java/J2EE)”.
Comdo 2000 Pte Ltd, Software Engineer

Java/J2EE Programming Course-“The Java/J2ee course material was well presented and very helpful for
my work. I really got a great amount out of it. The one to one training was excellent. It met all my
expectations. I can even try my hand at getting a SCJP cert now. Thanks to GTEC! “.
Sylvia Lawrence , IBM , IT Professional.

C#.net Programming Course-“G-TEC provides a good trainer qualified. It was a good learning
experience in G-TEC for C#.net”.
Emerson Process Management, Software Test Engineer.

Our Clients

Singapore Airlines, Bosch, Ministry of Home Affairs, Seagate, Land Transport Authority, NETS , Inland
Revenue Authority of Singapore, Tiger Airways, DSO Laboratories, DHL, Changi Airport Group, DB
Schenker, National University Hospital,Gemalto, Thales, Housing Development Board,Philips ,Micron,
Surbana International Consultants Pte. Ltd., Singapore Polytechnic, ING Bank, Nanyang Polytechnic,
Nanyang Technological University, Genetic Technologies Solutions, Singapore Chemical Industry Council
(SCIC), State Bank of India , ST Engineering, Emerson Process Management, Keppel FELS , ST
Aerospace, MCI

1 Sophia Road, #02-03, Peace Centre, Singapore 228149.

Phone: 63360244, 9650 3505, Email: [email protected]
Registered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)
Company Profile

G-TEC Computer Education Centre is an Information Technology

company in the field of Software Training, Technology Resourcing
What We and Knowledge Consulting. We provide Corporate Training, Project
do : Training, and Customized Training, One to One trainings for
professionals, individuals and students.

Who are We have special teaching methodologies to train people in

our different categories ranging from corporate clients to school level
students. Over 900000 students are certified by G-TEC all over
Customers the world. We have the privilege of working with some of the most
: well-known companies in the world.

G-TEC Computer Education Centre is the largest computer

Where we education networks with more than 510 centers all over the world
are : and corporate office in Singapore. We are operating in Mexico,
Qatar, India, Dubai, Singapore, Kuwait, Srilanka and Iran.
Our aim is to make IT education affordable to all sections of
Our Goal society through various projects associating with government’s
and quasigovernment public and private company to reach each
corner. Our ultimate goal is to achieve cent percentage computer
Focus : literacy. We are committed to provide 100% quality training to
all; our focus is to provide Quality Education World Wide.

Our Location

1 Sophia Road, #02-03, Peace Centre, Singapore 228149.

Phone: 63360244, 9650 3505, Email: [email protected]
Registered with Committee for Private Education (CPE) is part of SkillsFuture Singapore (SSG)