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