Courses

Ms Excel 2013 (Basic And Intermediate)
IT & Corporate System

3 Days

View Details

Overview:
In  this  course,  you  will  gain  a  foundational  understanding  of  the  basic functionality  in  Excel  2013.  You  will  begin  by  navigating  the  Excel  2013 environment. From there, you will perform the basic tasks associated with creating and saving Excel worksheets  and exploring the Help system. You will use formulas and functions to perform calculations in your worksheets, and you will modify worksheets by manipulating cells and data, by searching for and  replacing  data,  and  by  checking  for  spelling  errors.  You  will  format worksheets and prepare them for printing. You will also begin working with larger  workbooks  that  contain  multiple  worksheets.  Finally,  you  will customize how Excel behaves to more closely meet your needs.
Objective:


After attending this program, participants will be able to:
 
<div id="cke_bm_156S" type="_moz" with="" excel="" div="" none;"="" started="" span="" get="" br="">Perform calculations.
Format a worksheet.
Learn to use formulas and functions.
Convert, sort, filter, and manage lists.


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: 3 Days
Language:

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:

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

© 2017 TNB ILSAS