Courses

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

Until June 1, 2020, all training is provided through Online Live Interactive Classes! 

More Info
MS Excel

courses 

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

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, Naming Cells
  • Working with excel workbook and sheets
Module 2: Formatting excel work book
  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and 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
  • Date and Time Functions, Financial Functions
  • Logical Functions
  • Lookup(V-Lookup and H-Lookup) and Reference Functions
  • Mathematical Functions
  • Statistical Functions, Text Functions
  • Working with Templates
Module 4: Managing Tables
  • Creating Tables
  • Naming the Table
  • Changing the Table Style
  • Creating a Total Row
  • Creating a calculated column
  • Using Filtering in Table
  • Removing the Duplicate Record
Module 5: Sort and Filter Data with Excel
  • Sort and filtering data
  • Using number filter, Text filter
  • Custom filtering
  • Removing filters from columns
  • Conditional formating
Module 6: 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
  • Saving chart as template
  • Summarizing data using spark line
Module 7: Analyze Data Using Pivot Tables and Pivot Charts
  • Understand PivotTables, Create a PivotTable
  • Framework Using the PivotTable and PivotChart
  • Create Pivot Chart from pivot Table
  • Inserting slicer
  • Creating Calculated fields
Module 8: Protecting and Sharing the work book
  • Protecting a workbook with a password
  • Allow user to edit ranges
  • Track changes
  • Working with Comments
  • Insert Excel Objects and Charts in Word Document and Power point Presentation
Module 9: Use Macros to Automate Tasks
  • Creating and Recording Macros
  • Assigning Macros to the work sheets
  • Saving Macro enabled workbook
Module 10: proofing and Printing
  • Page setup, Setting print area, Print titles
  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Page Setup, Setting margins, Print Preview, Print
  • Enable back ground error checking
  • Setting AutoCorrect Options
  • Remove the appropriate check marks to disable any unwanted features

No data found

Course Name Duration Entry Requirement Fee (SGD)
MS Excel 15 hrs Basic Computer Knowledge S$350
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