Data Management With Pivot Table
Duration : 1 day
Course Description
PivotTables are powerful data analysis tools, yet most Excel users don’t use them to their fullest potential. This class shows you why PivotTables are so versatile for data analysis and how you can leverage PivotTables to rapidly spot trends and make fast business decisions on mountains of data.
Who Should Attend
This course is highly recommended for heavy users of Microsoft Excel especially professionals who have made Microsoft Excel as an indispensable tool at work. Most reports at work will be simplified extensively with usage of the PivotTable and PivotChart tool. Participants are required to have fundamental knowledge in Microsoft Excel prior to attending this course.
Course pre-requisites
Delegates enrolling in this course should understand the basics of Windows. They should already have experience working with Microsoft Excel basic calculation such as SUM.
Course Outline
Module 1 – What Are PivotTables?
• Provides an overview of Microsoft Excel PivotTable and the benefits of using PivotTable Module 2 – Creating PivotTables
• This module will exposed the participants to the various methods of creating PivotTable based on the various types of data that can be found in Excel or external data.
Module 3 – Working with PivotTable Components
• Moving forward, participants will uncover the different sections of the PivotTable and how to manipulate them to into a report.
Module 4 – Working with Calculations in PivotTable
• This module will expose the participants to the type of calculations that can be done inside the PivotTable itself. Calculations such as Calculated field and Calculated Item
Module 5 – Working with PivotCharts
• This module will expose the good uses of PivotChart and on how to manipulate it. Module 6 – Using Disparate Data Sources for PivotTable
• This module dealt with consolidation of data from different ranges using PivotTable. Module 7 – Analyzing External Data with PivotTables
• This module dealt with how to extract data from external sources such as MS Access, Paradox, OLAP, etc into Excel using PivotTable and use PivotTable to analyze them
Module 8 – Enhancing PivotTable with Macros
Data Management With Pivot Table
Duration : 1 day
ADMINISTRATIVE DETAILS
Date, Time & Venue
Version JUL AUG SEP OCT NOV DEC
2003 25 - 12 - 9 -
2007 - 22 - 10 - 5
2010 TBA (Upon Request)
Time : 9.00 a.m. – 5.00 p.m. Venue : Suite 37-8,
The Boulavard, Midvalley City, Lingkaran Syed Putra,
59200 Kuala Lumpur.
Fees : RM 700 per participant (Member) RM 850 per participant (Non-Member)
(Fees include course materials, Certificate of Attendance, refreshments)
Registration is on a first-come-first-served basis. Cheque made in favour of the “FMM Institute” should be forwarded one week before the commencement of the programme. Completed registration form, that is faxed, mailed or e-mailed to FMM Institute, would be deemed as confirmed.
All cancellations must be made in writing. There will be no charge for cancellation received 10 or more working days before the start of the programme. Cancellation received 6 – 9 working days before the start of the programme is subject to a cancellation fee of 50% of the course fees. Cancellation received 5 working days and below before the start of the programme is subject to a cancellation fee of 100% of the course fees. If the participant fails to attend the programme, the full course fees are payable. However, replacement can be accepted at no additional cost.
The FMM Institute reserves the right to change the facilitator, reschedule or cancel the programme and all efforts will be taken to inform participants of the changes.
For further enquiries, please contact: Ms Ong Li Choo /Ms Ravathi/Pn Hafifah
FMM Institute
Tel: 03-62867200 Fax: 03-62776712 • Visit us at www.fmm.edu.my
Data Management With Pivot Table
Duration : 1 day
REGISTRATION FORM The Manager FMM Institute Tel: 03-62867200 Fax: 03-62776712Version JUL AUG SEP OCT NOV DEC
2003 25 - 12 - 9 - 2007 - 22 - 10 - 5 2010
TBA (Upon Request)
Dear Madam,
Please register the following participant(s) for the above programme. (To be completed in BLOCK LETTERS)
1 Name Designation E-mail
________________________________________________________________________________
Nationality IC No.
________________________________________________________________________________
2 Name Designation E-mail
________________________________________________________________________________
Nationality IC No.
________________________________________________________________________________
(If space is insufficient, please attach a separate list)
Enclosed cheque/bank draft No. __________________________ for RM _____________________________ being payment for _______________________ participant(s) made in favour of the “FMM Institute”.
Submitted by: Name:__________________________________________________________________________________ Designation: _________________________________E-mail: ______________________________________ Company: _______________________________________________________________________________ Address: ________________________________________________________________________________ ________________________________________________________________________________________ FMM Membership No.: _____________________My Corporate Identity No.: ___________________________ Tel No.: ________________________ Fax No.: ________________________ Date: ____________________
Please tick ( √ ) accordingly: PSMB Scheme SBL
Data Management With Pivot Table
Duration : 1 day
Trainer biodata
(Either One of them will facilitate the programme)
RICKY CHAN
Education History
Bachelor of Computer Science (Honours) University Sains Malaysia
Microsoft Certified Trainer (MCT)
Microsoft Certified Systems Engineer (MCSE) 2003 Microsoft Certified Database Administrator (MCDBA) Microsoft Certified Professional (MCP)
Employment History/Work Experience
Pentawise Sdn Bhd – Training Consultant (2004 – Present)
Mr. Ricky has more than 5 years of experience in conducting training on Microsoft and Linux operating systems, Microsoft SQL and Visual Basic programming courses. He also provide technical support for internal staff and corporate customers.
Ardent Solution - Senior Consultant (1998-2003)
Mr. Ricky provides IT consultancy to customers from various industries. He specializes in firewall
implementations and e-mail systems. He also specializes in software integration to provide total solutions for customers. Mr. Ricky has a broad knowledge of operating systems, network architecture and systems implementation.
OpenSys - Consultant
Mr. Ricky was a vital member of the systems team that is responsible for providing professional services to customers such as NCR in the implementation and support of Branch View delivery system (BDS) – a bank tellering front end for several banks in Malaysia running on Windows NT 4.0.
He is heavily involved in a web based tellering front-end project for Regio bank, a subsidiary of ING group, in the process of security hardening, systems technical testing and load regression testing the system to meet strict requirements for the bank. He helped produce the systems security architecture for securing both the operating systems and application. He was also highly involved in providing the knowledge for securing against system failures through the usage of high availability techniques such as clustering and load balancing. He was frequently absorbed in to other project teams to provide technical and systems knowledge and views to solve problems faced during project implementation.
Apart from systems solutions, Mr. Ricky is also involved in software development projects such as developing and customizing the software for a self service cheque deposit machine for Standard and Chartered Bank Brunei. He was also involved in the development and customization of a workflow system in used in an insurance claims system used in a leading insurance company in the country.
Data Management With Pivot Table
Duration : 1 day
Skill-set
Programming Languages Visual Basic, VB.NET C and C++
Perl
Unix Shell Scripting Database Programming SQL Server 7/2000/ 2005 Microsoft Access IBM U2 mySQL Web Technologies HTML, ASP VBScript PHP JavaScript
Operating Systems & Networking Windows 95/98, DOS
Windows 2003/2000/NT/ 2007/Server 2008 Red Hat Linux
Firewalls
iptables based firewall solutions, smoothwall, sonicwall Messaging
Microsoft Exchange 2000 Sendmail
Data Management With Pivot Table
Duration : 1 day
SAM ONG
Education History
Bachelor of Computer Science (Honours) University Sains Malaysia Microsoft Certified Professional (MCP)
Employment History/Work Experience
Pentawise Sdn Bhd – Training Consultant (2004-present)
Sam Ong has more than 5 years of experience in conducting training on Microsoft Application and Linux operating systems, Microsoft SQL and Visual Basic programming courses. She also provides technical support for internal staff and corporate customers.
Experience
Ardent Solution - Senior Consultant
Sam Ong provides IT consultancy to customers from various industries. She specializes in firewall implementations and e-mail systems. She also specializes in software integration to provide total solutions for customers.
Sam Ong has a broad knowledge of operating systems, network architecture and systems implementation.
Consultant
Sam Ong was a vital member of the systems team that is responsible for providing professional services to customers such as NCR in the implementation and support of Branch View delivery system (BDS) – a bank tellering front end for several banks in Malaysia running on Windows NT 4.0.
Skill-set
Programming Languages Visual Basic, VB.NET C and C++
Perl
Unix Shell Scripting Database Programming SQL Server 7/2000 Microsoft Access IBM U2
mySQL Web Technologies HTML, ASP
VBScript /PHP /JavaScript
Adobe Suites (Photoshop, Illustrators, In Design, PageMaker) Operating Systems & Networking Windows 95/98, DOS /Windows 2003/2000/NT
Red Hat Linux Application
Ms Office Suite 2002 / 2003 and 2007 Excel Power User Modules
Data Management With Pivot Table
Duration : 1 day
CHAN PHOOI LAI
Education History
Bachelor of Economics, Majoring in Accounting La Trobe University, Australia
Graduate Diploma in Business in Computing Monash University, Australia
Employment History/Work Experience
Pentawise Sdn Bhd – Training Consultant (2004 – Present)
Training up new trainers and developing new courses as well as customizing courses accordingly to the needs of customers. Conduct training on Microsoft applications with emphasis on courses for financial professionals. Been running classes for MIA (Malaysian Institute Of Accountant) since freelancing time. Freelancer – Training Consultant (2000 – 2004)
Conduct customized courses for customers especially those in Finance sectors. MCSB (M) Systems Bhd – Training Consultant (1996 – 2000)
Conduct training on Microsoft courses, with emphasis on Visual Basic programming and Visual Basic for Applications. Provide technical support for internal staff and corporate customers. Develop course notes for Microsoft desktop application courses.
Glass Onion – Software Training Instructor (1995-1996)
Developed notes for basic IT courses. Conducted IT training and provided system support for corporate customers.
A.T.I. Coburg, Australia – Account Assistant
Assisted in all accounting activities, such as handling invoicing, petty cash, journals, double-entries Skill-set
Introduction to Internet Netscape Communicator Microsoft Internet Explorer Microsoft Windows Microsoft Word Microsoft PowerPoint Microsoft Project Microsoft Publisher Microsoft Visio
Microsoft Excel for Financial Professionals Analysing Financial Data with Microsoft Excel Expanding Microsoft Excel Charts
Microsoft Excel Functions and Formulas Tasks Automation With Microsoft Excel VBA Macro
Microsoft Excel VBA Programming Microsoft Access VBA Programming Microsoft Visual Basic programming
