Versatile Learning
Knowledge is Power
About Us
Versatile Learning provides leadership development, technical and soft skill development and performance qualified training professionals with diversified skills and experience. Versatile Learning offers a holistic approach in strengthening and developing organizations by creating innovative learning culture in the working environement.
Our Location
3-2, 1st Floor, Jalan Elektron F U16/F Denai Alam, Seksyen U16, 40160 Shah Alam, Selangor D.E.
P: 03-77344582 F: 03-77344781
Production Planning Preventive Maintenance
100% HRDF Claimable
Introduction
Productive Planned Preventive Maintenance (PPPM) has the following meanings:
- The care and servicing by personnel for the purpose of maintaining equipment and facilities in satisfactory operating condition by providing for systematic inspection detection, and correction of incipient failures either before they occur or before they develop into major defects.
- Maintenance, including tests, measurements, adjustments, and parts replacements, performed specifically to prevent faults from occuring.
The primary g0al of PPPM is to avoid or mitigate the consequences of failure equipment. This may be by preventing the failure before it actually occurs.
Course Overview
This course is industry designed to provide a broad understanding of the improvement methodology, concepts, and process. The methodology is presented and manufacturing applications. With a heavy practice prientation, as much as a third of your time will be spent working through interactive practical exercises and assessments. This course is designed towards concepts, methodology and actual applicaitons in industry.
Learning Outcomes
- Relate the concepts of PPPM to the overall maitenance mission and objectives.
- Think about maintenance as a c0llecti0n of processes, with inputs that determine the output.
- Evaluate the capability of a PPPM program.
- Recognize the model used to improve PPPM
- Recognize the factors that are necessary for a successful PPPM program.
- Integrate PPPM efforts with other process improvement initiatives.
Dr Shafa - Mechanical Engineering Expert
- Ph.D in Engineering, University of Technology Malaysia
- M. Science in Business Management, Warwick University, U.K
- B. Eng. in Mechanical Engineering, University of Technology Malaysia
- 1st Grade Steam Engineer and 1st Grade Internal Combustion Engine Engineer
What's in the course content & Who's the speaker?
We want to help you, we want you to engage with us so that we could serve you better in any of your grey ares.
If you want full details, please call us @ 03-77344582 or E-mail us at info@versatile-learning.com
My name is Asha and I am here to help you.
Versatile Learning Sdn Bhd | Versatile Learning, Kuala Lumpur | O: 03-77344582 F: 03-77344781
Kami TIDAK bertanggungjawab terhadap sebarang kehilangan atau kerosakan atau kerugian yang dialami kerana menggunakan kandungan di dalam blog ini. Pendapat atau bahan yang dikemukakan di dalam blog ini adalah pandangan peribadi semata-mata dan untuk kegunaan peribadi sahaja.
Showing posts with label Promosi 2017. Show all posts
Showing posts with label Promosi 2017. Show all posts
Wednesday, February 15, 2017
Conference for Pegawai Tadbir Diplomatik (PTD) 27-28 Mar 2017, The Everly Putrajaya
Conference for Pegawai Tadbir Diplomatik (PTD)
Accelerate PTD Development
27-28 Mar 2017, The Everly Putrajaya
Kindly call Elite Essential at 603 8063 9211 to request for the full brochure and registration form.
DO YOU KNOW?
1 98% customers recommended kami
2 RM 50 Giant / Tesco Hypermarket Cash Voucher untuk semua peserta
3 Program kami adalah HRDF Claimable
What You Will Learn
Session 1 ? A CHAMPION LEADER
Y. Bhg. Emeritus Professor Dato' Dr. Sheikh Omar Abdul Rahman
This
session covers the important topic of unlocking the leader inside you ?
the What, the When, the How and the Why. It emphasizes on
self-awareness and self-discovery of the "personal me? and the
"leadership me? and on developing the mindset of a champion leader
needs.
Session 2 ? TALK WITH CHARISMA
Mr. Rizal Rashid
This
session turns you to be a great presenter by giving you the techniques
to deliver presentation in an interesting and lively manner. It
highlights the techniques to persuade with the use of appropriate
language, to help expand your influence over the audience. Leaders can
speak!
Session 3 ? THE PROBLEM SOLVER & DECISION MAKER
Ms. Amy Wan-Ratos
Participants
will gain insight about thinking out of the box as a leader, to learn a
6-step model of problem solving, to practise some techniques of problem
solving and decision making, and lastly to select and apply them to
issues at work confidently.
Session 4 ? BUILD YOUR AURA
Mr. Hafiz Mustapha
This
session aims to provide you some holistic framework in communication
and insight on how to build your personal brand as a leader, which will
reinforce energy to drive results at work!
Session 5 ? HANDLE THE NEGATIVITY
Ms. Shariffah Anisah Syed Idrus
This
session covers the tips to manage your negativity, as well as giving
you the tools to handle your stress and time effectively.
Session 6 ? MAXIMIZING POTENTIAL TO SUCCESS
Ms. Zarina Zainal
An
individual can to be pushed to another level of personal excellence by
getting a refresh perspective of what he or she can do and is worthy of.
In this session, we will look into how you can develop excellent and
exceptional performance.
Thursday, February 9, 2017
Kursus MS Excel anjuran Nor Shawani (TED)
Data Analytics : Excel 2010|2013 Dashboard Interactive Reports
Details of the training :
|
MS EXCEL 2010|2013 : EXCEL DASHBOARDS & INTERACTIVE REPORTSRM 1,400 | per paxDashboard popularity is continuing to grow as organizations look for easier ways to access information within large data sets and to analyze that information in hopes of managing performance, making better decisions and lowering overall costs. Dashboard reports allow managers to get high-level overview of the business. Essentially, a dashboard report is a way to visually present critical data in summary form so that you can make quick and effective decisions. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner. A dashboard is a business tool that displays a set of PIs (performance indicators), KPIs (key performance indicators), and any other relevant information to a business user. Dashboard data is often displayed in real-time after retrieval from one or more data sources in a business. Dashboards are interactive, allowing an executive to drill into particular aspects of the display or switch between facets or views of the data. Basic Requirements Users must have basic knowledge of Excel charts, pivot tables, functions and formulas. Course Contents Chapter 1DashboardsIntroduction To DashboardsExcel Dashboards What Makes Good Dashboard Using The Proper Visualizations Dashboard Creation Process Why Is the Chart Type Important? Chapter 2Data Visualisation ToolsWhen to Use A Secondary AxisCombining Two Chart Types Formatting Tricks Chapter 3Analysing Data With Pivot ReportsWhat Are Pivot Reports?Creating A Dynamic Range For Data Expansion Creating a Pivot Report Incorporating Visual Analysis With Conditional Formatting Grouping Data Adding Interactive ElementsSlicing & Dicing DataQuerying Pivot Reports Creating Pivot Charts Chapter 4 Creating Interactive ReportsAn Alternative To The VLOOKUP FunctionCharting Tricks Showing Positive & Negative indicators Variance Analysis DashboardReturning A Value Based On User SelectionIncorporating Form Controls Incorporating Hyperlinks Chapter 5Automating Dashboards With FunctionsOffset FunctionCountA Function Structuring Your Data Linked Textbox Named Formulas Creating Gauge / Speedometer Charts Chapter 6Visual Basic For ApplicationsWhat Is VBA?Basics of VBA & Macros Executing A Procedure Converting A Workbook To A Macro Enabled Workbook Microsoft Excel VBA (Macro Programming) For Non Programmers
RM 1400 per pax
Dates : 22 & 23 Feb 17 | 13 & 14 Mar 17 | 6 & 7 Apr 17
Venue : Binjai 8 , KLCC
Students are required knowledge from Intermediate to Advanced of Microsoft Excel before joining this course. Students are not required programming knowledge background. Microsoft Excel VBA training course increase user productivity thru automated and worksheets process by using the inbuilt programming language. It will benefits students with the automated worksheet in MS Excel built in programming language. Course Objectives Upon completion of this Microsoft Excel VBA training course, participants should have learned Microsoft Excel VBA sufficiently to be able to:
Course contentThis Microsoft Excel VBA training course covers the following topics:Day 1 Recorded Macros
Understanding VBA
Using the VBA editor
Procedures
Using variables
Using Microsoft Excel objects
Programming techniques
Nor Shawani (TED) Tel : 03-2386 7788 | 03-2742 1828 Email : training@ted.com.my |
Kursus MS Excel anjuran TED LEARNING
MS Excel 2013 : Excel Dashboards & Interactive Reports
RM 1,400 per paxcourse duration : 27 & 28 Feb 2017 |6 & 7 March 2017
Venue : Binjai 8 , KLCC
Dashboard popularity is continuing to grow as organizations look for easier ways to access information within large data sets and to analyze that information in hopes of managing performance, making better decisions and lowering overall costs.
Dashboard reports allow managers to get high-level overview of the business. Essentially, a dashboard report is a way to visually present critical data in summary form so that you can make quick and effective decisions. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.
A dashboard is a business tool that displays a set of PIs (performance indicators), KPIs (key performance indicators), and any other relevant information to a business user. Dashboard data is often displayed in real-time after retrieval from one or more data sources in a business. Dashboards are interactive, allowing an executive to drill into particular aspects of the display or switch between facets or views of the data.
Basic Requirements
Users must have basic knowledge of Excel charts, pivot tables, functions and formulas.
Course Contents
Chapter 1
Dashboards
Introduction To DashboardsExcel Dashboards
What Makes Good Dashboard
Using The Proper Visualizations
Dashboard Creation Process
Why Is the Chart Type Important?
Chapter 2
Data Visualisation Tools
When to Use A Secondary AxisCombining Two Chart Types
Formatting Tricks
Chapter 3
Analysing Data With Pivot Reports
What Are Pivot Reports?Creating A Dynamic Range For Data Expansion
Creating a Pivot Report
Incorporating Visual Analysis With Conditional Formatting
Grouping Data
Adding Interactive Elements
Slicing & Dicing DataQuerying Pivot Reports
Creating Pivot Charts
Chapter 4
Creating Interactive Reports
An Alternative To The VLOOKUP FunctionCharting Tricks
Showing Positive & Negative indicators
Variance Analysis Dashboard
Returning A Value Based On User SelectionIncorporating Form Controls
Incorporating Hyperlinks
Chapter 5
Automating Dashboards With Functions
Offset FunctionCountA Function
Structuring Your Data
Linked Textbox
Named Formulas
Creating Gauge / Speedometer Charts
Chapter 6
Visual Basic For Applications
What Is VBA?Basics of VBA & Macros
Executing A Procedure
Converting A Workbook To A Macro Enabled Workbook
Big Data using Power Query & Power Pivot 2013
RM 2,000 per paxcourse duration : 27 & 28 Feb | 27 & 28 March 2017 | 27 & 28 April 2017
Venue : Binjai 8 , KLCC
Power Pivot is an add-in for Microsoft Excel 2013 that enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and Pivot Charts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.
This hands-on course demonstrates how to take advantage of self-service business intelligence using Microsoft PowerPivot for Excel.
Course Objectives:
During the training, you will use Power Pivot to:
- Import external data from multiple sources.
- Client database
- Excel tables
- CSV files
- Handling massive data from multiple sheets.
- Create relationships between multiple tables.
- How to create a user friendly models
- Perform calculations in Power Pivot
- Calculated columns.
- Calculated fields.
- Create PivotTables and Pivot Charts.
- Introduction to Data Analysis Expression language (DAX)
Excel Power Users, data analysts, business analysts, managers, MIS professionals and BI Consultants / BI Developers.
Prerequisites:
Delegates should be proficient users of Excel and be experienced in creating Excel PivotTables & PivotCharts and also be familiar with Functions & Formulas.
At Course Completion:
Upon successful completion of this course, the delegate should be proficient with PowerPivot and have the necessary skills to implement PowerPivot applications, manipulate data and perform data analysis.
Introduction To PowerPivot
This module explains what is a power pivot and how you can download and install the power pivot on your computer.- What is Power Pivot
- Limitation of the normal Pivot Table
- The Power Pivot Interface
Handling Data In Power Pivot
This module explains how to bring your data into Excel whether it's an external source, text files, Excel data and other sources. It also shows you how to build relationships between tables which is vital to data analysis.- Importing Data
- Creating Linked Tables
- Managing Relationships
- Creating Your Power Pivot Table
Power Pivot At Work
This module explains how to use create and format your reports as creating reports from Power Pivot may differ from a normal pivot table. It also touches on making your data model more user friendly for end users.- Creating and customising reports that are user friendly
- Formatting your Numbers
- Customising your data model
- Performing calculations with calculated columns
- Performing calculations with calculated fields
- Working with dates
- Using slicers
Introduction To DAXS
PowerPivot has its own syntax for defining calculation expressions. It is conceptually similar to an Excel expression, but it has specific functions that allow you to create more advanced calculation on data stored in multiple tables.- DAXS operators
- Calculated Columns
- Calculated Fields
- Date calculations
Microsoft Excel VBA (Macro Programming) For Non Programmers
RM 1,400 per paxcourse duration : 22 & 23 Feb | 13 & 14 March 2017 | 6 & 7 April 2017
Venue : Binjai 8 , KLCC
Joining in usage of both Microsoft Excel and VBA are to increase your productivity, become more powerful and flexibility to spreadsheets, automating processes and improving user interaction.
Students are required knowledge from Intermediate to Advanced of Microsoft Excel before joining this course. Students are not required programming knowledge background.
Microsoft Excel VBA training course increase user productivity thru automated and worksheets process by using the inbuilt programming language. It will benefits students with the automated worksheet in MS Excel built in programming language.
Course Objectives
Upon completion of this Microsoft Excel VBA training course, participants should have learned Microsoft Excel VBA sufficiently to be able to:
- Create recorded macros in Microsoft Excel
- Use the macro recorder to create a variety of macros
- Understand the Microsoft Excel object model and VBA concepts
- Create command procedures
- Create and use variables
- Write code to manipulate Microsoft Excel objects
- Use a range of common programming techniques
Course content
This Microsoft Excel VBA training course covers the following topics:Day 1
Recorded Macros
- Understanding Microsoft Excel macros
- Setting macro security
- Saving a workbook as a macro enabled workbook
- Recording a simple macro
- Running a recorded macro
- Viewing a macro
- Editing a macro
- Running a macro from the toolbar
- Assigning a keyboard shortcut to a macro
- Tips for developing macros
Recorder workshop
- Preparing data for an application
- Recording a macro that updates opening balances
- Recording a macro to open text files
- Creating objects to run macros
- Assigning a macro to an object
Understanding VBA
- VBA terminology
- About objects
- Accessing the Microsoft Excel object model
- Using the immediate window
- Working with object collections
- Setting property values
- Working with worksheets
- Using the object browser
Using the VBA editor
- The VBA editor
- Opening and closing the editor
- Working with the project explorer
- Working with the properties window
- Working with a code module
- Stepping through a procedure
Procedures
- About procedures
- Creating a command procedure
- Making sense of intellisense
- Using the edit toolbar
- Commenting statements
- Indenting code
Using variables
- Understanding variables
- Creating and using variables
- The scope of variables
- Procedure level scoping
- Module level scoping
- Passing variables by reference
- Passing variables by value
- Data types
- Declaring data types
Using Microsoft Excel objects
- Application methods and properties
- Workbook methods and properties
- Viewing Microsoft Excel and the editor together
- Using workbook objects
- Worksheets methods and properties
- Using worksheet objects
- Range methods and properties
- Using range objects
- Using objects in a procedure
Programming techniques
- The msgbox function
- Sending messages to the user
- Inputbox techniques
- Using the inputbox function
- Using if for multiple conditions
- Looping with known or specified iterations
- The do...loop statement
- Looping with unknown iterations
Noor Shawani
TED LEARNING
E : training@ted.com.my
T : 03-2742 1828 | 03-2386 7788
Kursus MS Excel anjuran MEDUKAS SDN BHD
MS Excel 2013|2010 : Excel Dashboards & Interactive Reports
RM 1,400 per pax (HRDF CLAIMABLE)
course duration : 22 & 23 February 2017 | 21 & 22 April 2017
Dashboard popularity is continuing to grow as organizations look for easier ways to access information within large data sets and to analyze that information in hopes of managing performance, making better decisions and lowering overall costs.
Dashboard reports allow managers to get high-level overview of the business. Essentially, a dashboard report is a way to visually present critical data in summary form so that you can make quick and effective decisions. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.
A dashboard is a business tool that displays a set of PIs (performance indicators), KPIs (key performance indicators), and any other relevant information to a business user. Dashboard data is often displayed in real-time after retrieval from one or more data sources in a business. Dashboards are interactive, allowing an executive to drill into particular aspects of the display or switch between facets or views of the data.
Basic Requirements
Users must have basic knowledge of Excel charts, pivot tables, functions and formulas.
Course Contents
Chapter 1
Dashboards
Introduction To Dashboards
Excel Dashboards
What Makes Good Dashboard
Using The Proper Visualizations
Dashboard Creation Process
Why Is the Chart Type Important?
Chapter 2
Data Visualisation Tools
When to Use A Secondary Axis
Combining Two Chart Types
Formatting Tricks
Chapter 3
Analysing Data With Pivot Reports
What Are Pivot Reports?
Creating A Dynamic Range For Data Expansion
Creating a Pivot Report
Incorporating Visual Analysis With Conditional Formatting
Grouping Data
Adding Interactive Elements
Slicing & Dicing Data
Querying Pivot Reports
Creating Pivot Charts
Chapter 4
Creating Interactive Reports
An Alternative To The VLOOKUP Function
Charting Tricks
Showing Positive & Negative indicators
Variance Analysis Dashboard
Returning A Value Based On User Selection
Incorporating Form Controls
Incorporating Hyperlinks
Chapter 5
Automating Dashboards With Functions
Offset Function
CountA Function
Structuring Your Data
Linked Textbox
Named Formulas
Creating Gauge / Speedometer Charts
Chapter 6
Visual Basic For Applications
What Is VBA?
Basics of VBA & Macros
Executing A Procedure
Converting A Workbook To A Macro Enabled Workbook
MS Excel : VBA (Macro Programming) For Non Programmers
RM 1,400 / per pax (HRDF CLAIMABLE)
course duration : 20 & 21 March 2017
Duration 2 days
Joining in usage of both Microsoft Excel and VBA are to increase your productivity, become more powerful and flexibility to spreadsheets, automating processes and improving user interaction.
Students are required knowledge from Intermediate to Advanced of Microsoft Excel before joining this course. Students are not required programming knowledge background.
Microsoft Excel VBA training course increase user productivity thru automated and worksheets process by using the inbuilt programming language. It will benefits students with the automated worksheet in MS Excel built in programming language.
Course Objectives
Upon completion of this Microsoft Excel VBA training course, participants should have learned Microsoft Excel VBA sufficiently to be able to:
This Microsoft Excel VBA training course covers the following topics:
Day 1
Recorded Macros
Using Microsoft Excel objects
Do not hesitate to inquire the following subject;
Manipulating Big Data with Power Query & Power Pivot 2 days
MS Excel 2013/2010 ( Basic & Intermediate ) 2 days
MS Excel 2013/2010 ( Advanced ) 2 days
MS PowerPoint 2013/2010 ( Basic - Advanced ) 2 days
MS Word 2013 / 2010 ( Basic - Advanced ) 2 days
MS Projects
Adobe Courses
SQL Server
Looking forward to serve you!
Sincerely,
Kelvin
014 392 0889
Business Manager
MEDUKAS SDN BHD
Level 23, NU Tower 2,
Jalan Tun Sambanthan,
Kuala Lumpur Sentral,
50470 Kuala Lumpur, Malaysia.
Tel : 03 - 2727 1622 Fax : 03 - 2727 1623
WWW.MEDUKAS.COM
RM 1,400 per pax (HRDF CLAIMABLE)
course duration : 22 & 23 February 2017 | 21 & 22 April 2017
Dashboard popularity is continuing to grow as organizations look for easier ways to access information within large data sets and to analyze that information in hopes of managing performance, making better decisions and lowering overall costs.
Dashboard reports allow managers to get high-level overview of the business. Essentially, a dashboard report is a way to visually present critical data in summary form so that you can make quick and effective decisions. Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner.
A dashboard is a business tool that displays a set of PIs (performance indicators), KPIs (key performance indicators), and any other relevant information to a business user. Dashboard data is often displayed in real-time after retrieval from one or more data sources in a business. Dashboards are interactive, allowing an executive to drill into particular aspects of the display or switch between facets or views of the data.
Basic Requirements
Users must have basic knowledge of Excel charts, pivot tables, functions and formulas.
Course Contents
Chapter 1
Dashboards
Introduction To Dashboards
Excel Dashboards
What Makes Good Dashboard
Using The Proper Visualizations
Dashboard Creation Process
Why Is the Chart Type Important?
Chapter 2
Data Visualisation Tools
When to Use A Secondary Axis
Combining Two Chart Types
Formatting Tricks
Chapter 3
Analysing Data With Pivot Reports
What Are Pivot Reports?
Creating A Dynamic Range For Data Expansion
Creating a Pivot Report
Incorporating Visual Analysis With Conditional Formatting
Grouping Data
Adding Interactive Elements
Slicing & Dicing Data
Querying Pivot Reports
Creating Pivot Charts
Chapter 4
Creating Interactive Reports
An Alternative To The VLOOKUP Function
Charting Tricks
Showing Positive & Negative indicators
Variance Analysis Dashboard
Returning A Value Based On User Selection
Incorporating Form Controls
Incorporating Hyperlinks
Chapter 5
Automating Dashboards With Functions
Offset Function
CountA Function
Structuring Your Data
Linked Textbox
Named Formulas
Creating Gauge / Speedometer Charts
Chapter 6
Visual Basic For Applications
What Is VBA?
Basics of VBA & Macros
Executing A Procedure
Converting A Workbook To A Macro Enabled Workbook
MS Excel : VBA (Macro Programming) For Non Programmers
RM 1,400 / per pax (HRDF CLAIMABLE)
course duration : 20 & 21 March 2017
Duration 2 days
Joining in usage of both Microsoft Excel and VBA are to increase your productivity, become more powerful and flexibility to spreadsheets, automating processes and improving user interaction.
Students are required knowledge from Intermediate to Advanced of Microsoft Excel before joining this course. Students are not required programming knowledge background.
Microsoft Excel VBA training course increase user productivity thru automated and worksheets process by using the inbuilt programming language. It will benefits students with the automated worksheet in MS Excel built in programming language.
Course Objectives
Upon completion of this Microsoft Excel VBA training course, participants should have learned Microsoft Excel VBA sufficiently to be able to:
- · Create recorded macros in Microsoft Excel
- · Use the macro recorder to create a variety of macros
- · Understand the Microsoft Excel object model and VBA concepts
- · Create command procedures
- · Create and use variables
- · Write code to manipulate Microsoft Excel objects
- · Use a range of common programming techniques
This Microsoft Excel VBA training course covers the following topics:
Day 1
Recorded Macros
- · Understanding Microsoft Excel macros
- · Setting macro security
- · Saving a workbook as a macro enabled workbook
- · Recording a simple macro
- · Running a recorded macro
- · Viewing a macro
- · Editing a macro
- · Running a macro from the toolbar
- · Assigning a keyboard shortcut to a macro
- · Tips for developing macros
- · Preparing data for an application
- · Recording a macro that updates opening balances
- · Recording a macro to open text files
- · Creating objects to run macros
- · Assigning a macro to an object
- · VBA terminology
- · About objects
- · Accessing the Microsoft Excel object model
- · Using the immediate window
- · Working with object collections
- · Setting property values
- · Working with worksheets
- · Using the object browser
- · The VBA editor
- · Opening and closing the editor
- · Working with the project explorer
- · Working with the properties window
- · Working with a code module
- · Stepping through a procedure
- · About procedures
- · Creating a command procedure
- · Making sense of intellisense
- · Using the edit toolbar
- · Commenting statements
- · Indenting code
- · Understanding variables
- · Creating and using variables
- · The scope of variables
- · Procedure level scoping
- · Module level scoping
- · Passing variables by reference
- · Passing variables by value
- · Data types
- · Declaring data types
Using Microsoft Excel objects
- · Application methods and properties
- · Workbook methods and properties
- · Viewing Microsoft Excel and the editor together
- · Using workbook objects
- · Worksheets methods and properties
- · Using worksheet objects
- · Range methods and properties
- · Using range objects
- · Using objects in a procedure
- · The msgbox function
- · Sending messages to the user
- · Inputbox techniques
- · Using the inputbox function
- · Using if for multiple conditions
- · Looping with known or specified iterations
- · The do...loop statement
- · Looping with unknown iterations
MS Excel 2013|2010 : Pivot Tables
13 February 2017
RM 900 per pax (HRDF CLAIMABLE)
Introduction
A Pivot Table is essentially a dynamic summary report generated from a database.
The database can reside in an Excel worksheet (in the form of a table) or in an external data file.
You can organise and summarise your data, perform comparisons, and extract meaningful information that can be invaluable to you and organisation.
Also, a Pivot Table can help transform endless rows and columns of numbers into a meaningful presentation of the data.
At Course Completion
At the end of the course, participants will be able to gain the knowledge of:
Completion of Microsoft Excel (Advanced Level) course or equivalent knowledge
13 February 2017
RM 900 per pax (HRDF CLAIMABLE)
Introduction
A Pivot Table is essentially a dynamic summary report generated from a database.
The database can reside in an Excel worksheet (in the form of a table) or in an external data file.
You can organise and summarise your data, perform comparisons, and extract meaningful information that can be invaluable to you and organisation.
Also, a Pivot Table can help transform endless rows and columns of numbers into a meaningful presentation of the data.
At Course Completion
At the end of the course, participants will be able to gain the knowledge of:
- · Creating PivotTables
- · Modifying PivotTable Calculations
- · Using VLOOKUP with the Pivot Tables
- · Advanced Pivot Table Options
- · Creating a PivotTable based on External Data
- · Creating Pivot Charts
- · Working Pivot Table with Macro
Completion of Microsoft Excel (Advanced Level) course or equivalent knowledge
Do not hesitate to inquire the following subject;
Manipulating Big Data with Power Query & Power Pivot 2 days
MS Excel 2013/2010 ( Basic & Intermediate ) 2 days
MS Excel 2013/2010 ( Advanced ) 2 days
MS PowerPoint 2013/2010 ( Basic - Advanced ) 2 days
MS Word 2013 / 2010 ( Basic - Advanced ) 2 days
MS Projects
Adobe Courses
SQL Server
Looking forward to serve you!
Sincerely,
Kelvin
014 392 0889
Business Manager
MEDUKAS SDN BHD
Level 23, NU Tower 2,
Jalan Tun Sambanthan,
Kuala Lumpur Sentral,
50470 Kuala Lumpur, Malaysia.
Tel : 03 - 2727 1622 Fax : 03 - 2727 1623
WWW.MEDUKAS.COM
Kursus Feb, Mac & Apr 2017 anjuran U Smart Resources
Assalamualaikum dan Salam Sejahtera,
Dengan segala hormatnya kami merujuk perkara di atas, sukacita dimaklumkan U Smart Resources sebuah syarikat yang berdaftar dengan Kementerian Kewangan Malaysia akan menganjurkan kursus-kursus awam seperti berikut pada bulan Febuari, Mac & April 2017. Pihak kami dengan sukacitanya menjemput tuan atau mencalonkan pegawai-pegawai yang berkenaan untuk menyertai kursus-kursus yang dianjurkan. Bersama-sama ini dilampirkan brosur kursus untuk perhatian pihak tuan.
(1) KURSUS REKA GRAFIK KREATIF ADOBE PHOTOSHOP CS6
Tarikh : 27-28 Februari , Tempat : Jomtraining Centre, Puchong - Selangor
Sila Muat Turun Brosur disini
(2) KURSUS PENGGUNAAN BAHASA INGGERIS DENGAN YAKIN DI TEMPAT KERJA: OH MY ENGLISH!
Tarikh : 8-9 Mac 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun Brosur disini
(3) KURSUS STATISTIK UNTUK KEGUNAAN BUKAN AHLI STATISTIK
Tarikh : 15-16 Mac 2017 , Tempat : Jomtraining Centre, Puchong - Selangor
Sila muat turun brosur disini
(4) KURSUS MS POWERPOINT: PROFESIONAL SLAID KORPORAT
Tarikh : 15-16 Mac 2017 , Tempat : Jomtraining Puchong Centre, Selangor
Sila muat turun brosur disini
(5) KURSUS PEMANDUAN BERHEMAH DAN CEMERLANG
Tarikh : 29-30 Mac 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun brosur disini
(6) KURSUS KEMAHIRAN PENULISAN (MEMO, EMEL, SURAT RASMI, DAN MINIT MESYUARAT)
Tarikh : 29-30 Mac 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun brosur disini
(7) KURSUS MS POWERPOINT: SUNTINGAN KREATIF DAN ANIMASI MONTAJ
Tarikh : 3-5 April 2017 , Tempat : Jomtraining Puchong Centre, Selangor
Sila muat turun brosur disini
(8) KURSUS MS EXCEL - "FUNCTIONS & FORMULAS"
Tarikh : 5-6 April 2017 , Tempat : Jomtraining Puchong Centre, Selangor
Sila muat turun brosur disini
(9) KURSUS ASAS PENYELENGGARAAN KENDERAAN BERAT
Tarikh : 10-11 April 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun brosur disini
(10) KURSUS PENYELIA DAN PENGAWAL KESELAMATAN YANG EFEKTIF & PROFESIONAL
Tarikh : 12-13 April 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun brosur disini
(11) KURSUS PENGACARAAN MAJLIS CEMERLANG
Tarikh : 12-13 April 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun brosur disini
(12) KURSUS PEMBANGUNAN WEB PROFESIONAL JOOMLA! 3.6.X (VERSI TERKINI) PROBE & RESPONSIVE
Tarikh : 7-9 Mac 2017 , Tempat : Kota Kinabalu, Sabah
Tarikh : 14 - 16 Mac 2017 , Tempat : Kuantan, Pahang
Tarikh : 21 - 23 Mac 2017 , Tempat : Pulau Pinang
Tarikh : 28 - 30 Mac 2017 , Tempat : Kuching, Sarawak
Sila Muat Turun Brosur disini
Sila hubungi kami di talian 03-80631570 / 03-80527197 / 017-2390929, Faksimili;03-21784824 atau email ke training@usmart-resources.com.my untuk sebarang pertanyaan lanjut. Kami juga ingin memohon jasa baik tuan untuk menghebahkannya ke seluruh organisasi tuan maklumat kursus ini. Segala sokongan dan pertimbangan pihak tuan untuk menjayakan kursus ini amat kami hargai. Sekian, terima kasih.
Yang benar,
Nurzuliana Isa
Penyelaras Kursus
Dengan segala hormatnya kami merujuk perkara di atas, sukacita dimaklumkan U Smart Resources sebuah syarikat yang berdaftar dengan Kementerian Kewangan Malaysia akan menganjurkan kursus-kursus awam seperti berikut pada bulan Febuari, Mac & April 2017. Pihak kami dengan sukacitanya menjemput tuan atau mencalonkan pegawai-pegawai yang berkenaan untuk menyertai kursus-kursus yang dianjurkan. Bersama-sama ini dilampirkan brosur kursus untuk perhatian pihak tuan.
(1) KURSUS REKA GRAFIK KREATIF ADOBE PHOTOSHOP CS6
Tarikh : 27-28 Februari , Tempat : Jomtraining Centre, Puchong - Selangor
Sila Muat Turun Brosur disini
(2) KURSUS PENGGUNAAN BAHASA INGGERIS DENGAN YAKIN DI TEMPAT KERJA: OH MY ENGLISH!
Tarikh : 8-9 Mac 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun Brosur disini
(3) KURSUS STATISTIK UNTUK KEGUNAAN BUKAN AHLI STATISTIK
Tarikh : 15-16 Mac 2017 , Tempat : Jomtraining Centre, Puchong - Selangor
Sila muat turun brosur disini
(4) KURSUS MS POWERPOINT: PROFESIONAL SLAID KORPORAT
Tarikh : 15-16 Mac 2017 , Tempat : Jomtraining Puchong Centre, Selangor
Sila muat turun brosur disini
(5) KURSUS PEMANDUAN BERHEMAH DAN CEMERLANG
Tarikh : 29-30 Mac 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun brosur disini
(6) KURSUS KEMAHIRAN PENULISAN (MEMO, EMEL, SURAT RASMI, DAN MINIT MESYUARAT)
Tarikh : 29-30 Mac 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun brosur disini
(7) KURSUS MS POWERPOINT: SUNTINGAN KREATIF DAN ANIMASI MONTAJ
Tarikh : 3-5 April 2017 , Tempat : Jomtraining Puchong Centre, Selangor
Sila muat turun brosur disini
(8) KURSUS MS EXCEL - "FUNCTIONS & FORMULAS"
Tarikh : 5-6 April 2017 , Tempat : Jomtraining Puchong Centre, Selangor
Sila muat turun brosur disini
(9) KURSUS ASAS PENYELENGGARAAN KENDERAAN BERAT
Tarikh : 10-11 April 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun brosur disini
(10) KURSUS PENYELIA DAN PENGAWAL KESELAMATAN YANG EFEKTIF & PROFESIONAL
Tarikh : 12-13 April 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun brosur disini
(11) KURSUS PENGACARAAN MAJLIS CEMERLANG
Tarikh : 12-13 April 2017 , Tempat : Vistana Kuala Lumpur Titiwangsa
Sila muat turun brosur disini
(12) KURSUS PEMBANGUNAN WEB PROFESIONAL JOOMLA! 3.6.X (VERSI TERKINI) PROBE & RESPONSIVE
Tarikh : 7-9 Mac 2017 , Tempat : Kota Kinabalu, Sabah
Tarikh : 14 - 16 Mac 2017 , Tempat : Kuantan, Pahang
Tarikh : 21 - 23 Mac 2017 , Tempat : Pulau Pinang
Tarikh : 28 - 30 Mac 2017 , Tempat : Kuching, Sarawak
Sila Muat Turun Brosur disini
Sila hubungi kami di talian 03-80631570 / 03-80527197 / 017-2390929, Faksimili;03-21784824 atau email ke training@usmart-resources.com.my untuk sebarang pertanyaan lanjut. Kami juga ingin memohon jasa baik tuan untuk menghebahkannya ke seluruh organisasi tuan maklumat kursus ini. Segala sokongan dan pertimbangan pihak tuan untuk menjayakan kursus ini amat kami hargai. Sekian, terima kasih.
Yang benar,
Nurzuliana Isa
Penyelaras Kursus
Subscribe to:
Posts (Atom)