Courses

Ms Excel 2013 (Advance)
IT & Corporate System

2 Days

View Details

Overview:
Participants  will  learn  to  use  advanced  functions  of  Excel®  2013  to  improve  productivity, enhance  spreadsheets  with  templates,  charts,  graphics,  and  formulas  and  streamline  their operational work. They will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Students will also learn how to automate common tasks, apply advanced  analysis  techniques  to  more  complex  data  sets,  collaborate  on  worksheets  with others, and leverage on Excel’s advanced functionality to simplify and streamline their day-today work.
Objective:
In this course, you will gain a foundational understanding of after the successful completion of the Intermediate to Advanced Excel 2013 Training program, students will be able to:

• Calculate with advanced functions & formulas.
• Organize worksheet and table data using multiple techniques.
• Create and modify charts & graphs.
• Analyze data using pivot tables and pivot charts.
• Insert graphic objects.
• Customize and enhance workbooks and the microsoft® office excel® 2013 environment.

They will know learn to deploy Advanced Excel 2013 techniques to increase productivity and improve efficiency by streamlining the workflow.

• Collaborate with others using workbooks.
• Audit worksheets.
• Analyze data.
• Work with multiple worksheets & workbooks.
• Import and export data in excel.


for any enquiries please contact:

1. NAME: ROZITA MOHD
   Email: rozitam@tnb.com.my

2. NAME: NOORZIAH ASMAR
   Email: noorziaha2@tnb.com.my

Target Participant: Open to All
Duration: 2 Days
Language:

MS Excel 2010 Macro VBA
IT & Corporate System

2 Days

View Details

Overview:
Excel VBA, which stands for Excel Visual Basic for Applications, is the name of the programming language of Microsoft Excel. With Excel VBA you can automate a task in Excel by writing a so called  Macro. This can save you a lot of time! More importantly there are certain things you cannot do with Excel alone. Excel VBA allows you to do these things in Excel.
Objective:
By  the  end  of  this  course  you  should  be  confident  to  create  procedures  for controlling  the  behaviour  and  appearanceof  an  Excel  spreadsheet,  create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.


for any enquiries please contact:

1. Name: Wan Suziana Wan Sulaiman
   Email: suziana@tnb.com.my

2. Name: Rozita Mohd
   Email: rozitam@tnb.com.my

Target Participant: Open to All
Duration: 2 Days
Language:

MS Excel 2007 - Pemandu
IT & Corporate System

3 Days

View Details

Overview:

  •   Pengunaan Ms Excel
  •   Pengisian automatik
  •   Formula Untuk Pengiraan
  •   Mengawasi kemasukkan data
  •   Memformat data
  •   Mencipta Graf

Objective:
Di  akhir  kursus  peserta-peserta  akan  boleh  menyediakan  data, pengisian  otomatik,  graf  dan  formula  pengiraan  di  dalam  MS  Excel 2007 tahap basic dan intermediate, berpandukan manual latihan yang diberi, tanpa melakukan kesilapan.


untuk maklumat lanjut sila hubungi:

1. NAME: ROZITA MOHD
   Email: rozitam@tnb.com.my

2. NAME: NOORZIAH ASMAR
   Email: noorziaha2@tnb.com.my

Target Participant: TD08
Duration: 3 Days
Language:

Human Resource Minister - Training Provider Award 2007
Role Model Company 2013 for Electrical Training Programmes by Manpower Department (JTM)
Energy Industry Award: Training Institution Excellence 2011

TNB Integrated Learning Solution Sdn Bhd - ILSAS
Jalan IKRAM-UNITEN, Karung Berkunci 205,
43650 Bandar Baru Bangi, Selangor, MALAYSIA

T: (+6) 03-8922 7222 F: (+6) 03-8926 4437 E: infoilsas@tnb.com.my

© 2018 TNB ILSAS