Courses

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

Python Weekend Batch Commencing on 19 June 2021! Special Offer Available! Book Your Slot ASAP!

Please call on 96503505 or email to info.sg@gteceducation.com for booking.

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