RM 3.6K
Analysing Data using MS Excel 2007

Analysing Data Using MS Excel 2007
IT & Corporate System

Overview:
Participants  will  learn  to  use  advanced  functions  of  Excel®  2007  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-to-day work.

Objective:
After attending this program, participants 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® 2007 environment.
• 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: NOOR HASLIZA SAID
   Email: noorhaslizas@tnb.com.my

Duration: 3 Days


Request Form





Available Sessions

Upon Request


Other Information
Target Participant: Executive & Non-Executive


Price

Upon Request



Related Course

RM 3.6K
MS Excel 2010 Macro VBA
IT & Corporate System

2 Days

View Details

Overview:
Participants  will  learn  to  use  advanced  functions  of  Excel®  2007  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-to-day work.
Objective:
After attending this program, participants 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® 2007 environment.
• 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: NOOR HASLIZA SAID
   Email: noorhaslizas@tnb.com.my

Target Participant: Executive & Non-Executive
Duration: 3 Days
Language:

RM 3.6K
PR200: Overall Procurement Process
IT & Corporate System

4 Days

View Details

Overview:
Participants  will  learn  to  use  advanced  functions  of  Excel®  2007  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-to-day work.
Objective:
After attending this program, participants 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® 2007 environment.
• 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: NOOR HASLIZA SAID
   Email: noorhaslizas@tnb.com.my

Target Participant: Executive & Non-Executive
Duration: 3 Days
Language:

RM 3.6K
SCM - CLM ( Enforcement)
IT & Corporate System

2

View Details

Overview:
Participants  will  learn  to  use  advanced  functions  of  Excel®  2007  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-to-day work.
Objective:
After attending this program, participants 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® 2007 environment.
• 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: NOOR HASLIZA SAID
   Email: noorhaslizas@tnb.com.my

Target Participant: Executive & Non-Executive
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

© 2017 TNB ILSAS