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 Full Course

coursesProvide the knowledge in MS Word, MS PowerPoint, MS Excel and open the world of Internet and Emailing.

Course Name Duration Entry Requirement Fee (SGD)
MS Office Full Course 30 hrs Beginner of MS office S$790

For alternate time slots, please call 63360244/96503505

Course Content

Module 1: 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 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 Objects
  • Shapes, Clipart and Picture
  • Word Art, Smart Art
  • Add columns to a document
  • Change the Order of Objects
  • Page Number, Date & Time
  • Inserting Text boxes, Inserting Word art
  • Inserting symbols, Inserting Chart
Module 4: Header & Footers
  • Inserting custom Header and Footer
  • Customising header and footer
  • Inserting objects in the header and footer
  • Add section break to a document
  • Inserting page numbers
Module 5: Working with bullets and numbered lists
  • Multilevel numbering and bulleting
  • Creating list
  • Customizing list style
  • Shading paragraph
  • Bordering paragraph
  • Page bordering
  • Page background
Module 6: Tables
  • Working with Tables
  • Table Formatting
  • Table Styles
  • Alignment option
  • Merge and split option
Module 7: Styles and Content
  • Using Build- in Styles, Modifying Styles
  • Creating Styles, Creating a list style
  • Table of contents and references
  • Adding internal references
  • Adding a Footnote
  • Adding Endnote
Module 8: Merging Documents
  • Typing new address list
  • Importing address list from Excel file
  • Write and insert field
  • Merging with outlook contact
  • Preview Result
  • Merging to envelopes
  • Merging to label
  • Setting rules for merges
  • Finish & Merge options
Module 9: Sharing and Maintaining Document
  • Changing Word Options
  • Changing the Proofing Tools
  • Managing Templates
  • Restricting Document Access
  • Using Protected View
  • Working with Templates
  • Managing Templates
  • Understanding building blocks
Module 10: Proofing the document
  • Check Spelling As You Type
  • Mark Grammar Errors As You Type
  • Setting AutoCorrect Options
Module 11: Printing
  • Page Setup, Setting margins, Print Preview, Print
  • Print Preview, Print

MS EXCEL

Module 12: 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 13: 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 14: Perform Calculations with Functions
  • Creating Simple Formulas
  • Setting up your own formula
  • Calculations between worksheets
  • Mathematical Functions
  • Statistical Functions
  • Date and Time Functions
  • Logical IF Function
  • Logical functions with multiple conditions
  • Lookup Functions (V-Lookup and H-Lookup)
  • Using range names in formulas
  • Conditional summary function
  • Countif, Sumif, Averageif functions
Module 15: Cell referencing
  • Relative cell referencing
  • Absolute Cell referencing
  • Using Cell references in formulas
  • Doing quick calculations with Cell referencing
  • Mixed cell referencing
Module 16: 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 17: Working with Graphics and hyperlinks
  • Adding Pictures into a Worksheet
  • Customizing Pictures and Objects
  • Adding Drawing Objects into a Worksheet
  • Adding SmartArt into a Worksheet
  • Creating Hyperlinks
  • Hyperlinks to worksheet
  • Hyperlinks to file
Module 18: 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, Editing chart data range
  • Editing data series, Changing chart types
  • Moving chart to a new worksheet
  • Preparing combination chart
  • Visualizing data with spark lines
  • Editing and modifying sparklines
Module 19: Protecting and Sharing the work book
  • Protecting a workbook with a password
  • Allow user to edit ranges
  • Tracking the changes
  • Accepting and rejecting changes
  • Working with Comments
  • Editing and deleting comments
Module 20: Analyze Data Using PivotTables and Pivot Charts
  • Understand PivotTables
  • Understanding Row and columns
  • Understanding pivot table field list
  • Creating new field items
  • Create Pivot Chart from pivot Table
  • Creating Calculated fields
  • Editing Calculated field
  • Filtering pivot tables with slicers
  • Moving pivot table and updating data
Module 21: Use Macros to Automate Tasks
  • Creating and Recording Macros
  • Assigning Macros to the work sheets
  • Saving Macro enabled workbook
  • Editing and deleting macros
  • Assigning macro to a button
Module 22: 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 23: 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 Intends
Module 24: Creating slides and applying themes
  • Inserting new slide
  • Changing layout of slides
  • Duplicating slides
  • Copying and pasting slide
  • Applying themes to the slide layout
  • Changing theme color
  • Slide background
  • Formatting slide background
  • Using slide views
Module 25: Working with bullets and numbering
  • Multilevel numbering and Bulleting
  • Creating List
  • Page bordering
  • Page background
  • Aligning text
  • Text directions
  • Columns option
Module 26: 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
Module 27: Hyperlinks and Action Buttons
  • Inserting Hyperlinks and Action Buttons
  • Edit Hyperlinks and Action Button
  • Word Art and Shapes
Module 28: Working With Movies and Sounds
  • Inserting Movie From a Computer File
  • Inserting Audio file
  • Audio Video playback and format options
  • Video options, Adjust options
  • Reshaping and bordering Video
Module 29: Using SmartArt and Tables
  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option
  • Merge and split option
  • Converting text to smart art
Module 30: Animation and Slide Transition
  • Default Animation, Custom Animation
  • Modify a Default or Custom Animation
  • Reorder Animation Using Transitions
  • Apply a Slide Transition, Modifying a
  • Transition, Advancing to the Next Slide
Module 31: Using slide Master
  • Using slide master
  • Inserting layout option
  • Creating custom layout
  • Inserting place holders
  • Formatting place holders
Module 32: Slide show option
  • Start slide show
  • Start show from the current slide
  • Rehearse timing
  • Creating custom slide show
Module 33: Proofing and Printing
  • Check Spelling As You Type
  • Setting AutoCorrect Options
  • Save as video
  • Save as JPEG files
  • Save as PowerPoint Show file
  • Print Preview, Print

No data found

Course Name Duration Entry Requirement Fee (SGD)
MS Office Full Course 30 hrs Beginner of MS office S$790
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