Courses

Enquiries Registration Training Calendar corp-training Corporate Training corp-training Project Training Online training

   AUTO CAD 3D COURSE SCHEDULE ON DEC 19TH TO DEC 24TH 2024 ( EVENING CLASSES)

 

MS EXCEL ADVANCE CLASSES SCHEDULE ON JAN 6TH AND JAN 7TH OF 2025

 

 

 

More Info
MS Office Basic

courses
MS Office Basic course is mainly focusing on people who do not have any knowledge in computer. This course deals with basics of computer and basics of Microsoft applications such as Word, Excel and PowerPoint. Students will learn how to create and manage Word documents by using MS Word application. Students will also be able to organise and analyse the data in tables, perform simple calculations, create graphs and charts using MS Excel.  This course will also provide the students a basic understanding of Internet and emailing.

Course Name Duration Entry Requirement Fee (SGD)
MS Office Basic 15 hrs Basic Computer Knowledge S$399

For alternate time slots, please call 63360244/96503505

Course Content

Module 1: MS Windows & Computer Basics  
  • Computer Basics, Creating Folder
  • Paint & Directories
  • Input and Output units
  • Central Processing Units
  • Hardware and Software
  • Windows shortcut keys
Module 2: Text formatting and saving file
  • Editing text: cut, copy, paste, select all,
  • formatting text: font size, font style
  • Font color, use the bold, italic, and 
  • Underline, change the text case
  • Finding and replacing text
  • Line spacing, paragraph spacing
  • Shading text and paragraph
  • Working with tabs and indents
Module 3: Working with bullets & numbering
  • Multilevel numbering and bulleting
  • Creating list
  • Customizing list style
  • Shading paragraph
  • Bordering paragraph
  • Page bordering
  • Page background
Module 4: Working with objects
  • Shapes, clipart and picture, 
  • Add columns to a document
  • Change the order of objects
  • Page number, date & time
  • Inserting text boxes
Module 5: Header & footers
  • Inserting header & footer
  • Customising header and footer
  • Inserting objects in the header and footer
  • Add section break to a document
  • Inserting page numbers
Module 6: Tables
  • Working with tables
  • Table formatting
  • Table styles
  • Alignment option
  • Merge and split option
Module 7: Proofing & printing
  • Check spelling as you type.
  • Mark grammar errors as you type.
  • Setting autocorrect options
  • Page setup, setting margins, 
  • Print preview, print.

MS EXCEL

Module 8: Introduction to Excel
  • Introduction to Excel interface
  • Understanding rows and columns
  • Adding and deleting new worksheet 
  • Working with excel workbook and sheets
  • Understanding cell referencing
  • Introduction to Excel interface
  • Understanding rows and columns
  • Adding and deleting new worksheet 
  • Working with excel workbook and sheets
  • Understanding cell referencing
Module 9: Formatting excel work book
  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style,
  • Font Color, Use the Bold, Italic & Underline,
  • Wrap text, Merge and Centre
  • Currency, Accounting and other formats
  • Modifying Columns, Rows & Cells.
Module 10: Perform Calculations with Functions
  • Creating Simple Formulas
  • Setting up your own formula
  • Calculations between worksheets
  • Mathematical Functions, Statistical Functions
  • Date and Time Functions, Text Functions
Module 11: Cell referencing
  • Relative cell referencing
  • Absolute Cell referencing
  • Using Cell references in formulas
  • Doing quick calculations with Cell referencing
  • Mixed cell referencing
Module 12: Sort and Filter Data with Excel
  • Sort and filtering data
  • Using number filter, Text filter
  • Custom sort and filtering
  • Removing filters from columns
  • Using Conditional formatting
  • Modifying and deleting rules
  • Creating custom rules
Module 13: Working with Graphics and hyperlinks
  • Adding Pictures & SmartArts into a Worksheet
  • Drawing objects into a Worksheet
  • Creating Hyperlinks
  • Hyperlinks to worksheet
  • Hyperlinks to file
Module 14: Create Effective Charts to Present Data Visually
  • Inserting Column, Pie chart etc.
  • Create an effective chart with Chart Tool 
  • Design, Format, and Layout options
  • Adding chart title, Changing layouts
  • Chart styles & Chart Types
  • Editing chart data range & data series
  • Moving chart to a new worksheet
  • Preparing combination chart
  • Visualizing data with spark lines
Module 15: Proofing and Printing
  • Page setup, setting print area, Print titles
  • Editing print area, add to print area
  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Page Setup, setting margins 
  • Print Preview, Changing worksheet views

MS POWERPOINT

Module 16: Setting up PowerPoint environment
  • New, open, close, save, save as
  • Typing the text, alignment of text
  • Formatting text: font size, font style
  • Font color, use the bold, italic, and underline
  • Cut, copy, paste, select all, clear text
  • Find & replace, working with tabs and indents
Module 17: Creating slides & applying themes
  • Inserting new slide
  • Changing layout of slides
  • Duplicating slides
  • Copying and pasting slide
  • Applying themes to the slide layout
  • Changing theme color
  • Formatting slide background
  • Using slide views
Module 18: Working with bullets & numbering
  • Multilevel numbering and bulleting
  • Creating list
  • Page bordering
  • Page background
  • Aligning text
  • Text directions
  • Columns option
Module 19: Working with objects
  • Shapes, clipart and picture, word art, smart art
  • Change the order of objects
  • Inserting slide header and footer
  • Inserting text boxes, inserting word art
  • Inserting shapes, using quick styles
  • Inserting symbols, inserting chart
  • Apply a slide transition, modifying a 
  • Transition, advancing to the next slide
Module 20: Animation and slide transition
  • Default animation, custom animation
  • Modify a default or custom animation
  • Reorder animation using transitions
Module 21: Slide show option
  • Start slide show
  • Start show from the current slide
  • Rehearse timing
  • Creating custom slide show
Module 22: Saving & printing
  • Save as video
  • Save as jpeg files
  • Save as PowerPoint show file
  • Print preview, print
Module 23: Internet & email
  • What is internet? 
  • Receiving incoming messages
  • Sending messages, Email attachments,
  • Browsing, search engines/>

No data found

Course Name Duration Entry Requirement Fee (SGD)
MS Office Basic 15 hrs Basic Computer Knowledge S$399
Time Slot
Please call 63360244/96503505
or
mail to info.sg@gteceducation.com
We also provides flexible timing to meet the customer's requirement

Request For Brochure

Captcha

Frequently asked questions

No data found