Courses

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

MS Office Basic Commencing on 04 March 2024 (Classroom Training)

Autocad 2D Commencing on 16 March 2024 (Classroom Training)

Please Call/Whatsapp 96503505 for more details.

 

 

More Info
MS Excel

courses 

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

We also train Ms Excel 2010/2013 versions. For alternate time slots, please call 63360244/96503505 

Course Content

Module 1: 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 2: 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 3: 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 4:  Cell referencing 
  • Relative cell referencing
  • Absolute Cell referencing
  • Using Cell references in formulas
  • Doing quick calculations with Cell referencing
  • Mixed cell referencing
Module 5: 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 6: Working with Graphics andhyperlinks
  • 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 7: 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 8: 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 9: Analyze Data Using Pivot Tables 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 10: 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 11: 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

No data found

Course Name Duration Entry Requirement Fee (SGD)
MS Excel 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