RM 3.6K
Analysing Data using MS Excel 2010

Analysing Data Using MS Excel 2010
IT & Corporate System

Overview:
Participants will learn to use advanced functions of Excel® 2010 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® 2010 environment.
  • Collaborate with others using Workbooks
  • Audit Worksheets.
  • Analyze Data.
  • Work With Multiple Worksheets & Workbooks.
  • mport 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
Languages: Malay


Price

RM NA



Related Course

RM 3.6K
PS163: Distribution Project - Module 2 (Contruction)
IT & Corporate System

4 Days

View Details

Overview:
Participants will learn to use advanced functions of Excel® 2010 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® 2010 environment.
  • Collaborate with others using Workbooks
  • Audit Worksheets.
  • Analyze Data.
  • Work With Multiple Worksheets & Workbooks.
  • mport 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: Malay

RM 3.6K
CGIS03: Generation - Viewer
IT & Corporate System

2 Days

View Details

Overview:
Participants will learn to use advanced functions of Excel® 2010 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® 2010 environment.
  • Collaborate with others using Workbooks
  • Audit Worksheets.
  • Analyze Data.
  • Work With Multiple Worksheets & Workbooks.
  • mport 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: Malay

RM 3.6K
MS Office Visio 2013
IT & Corporate System

2 Days

View Details

Overview:
Participants will learn to use advanced functions of Excel® 2010 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® 2010 environment.
  • Collaborate with others using Workbooks
  • Audit Worksheets.
  • Analyze Data.
  • Work With Multiple Worksheets & Workbooks.
  • mport 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: Malay

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