MICROSOFT EXCEL 2010 - ADVANCE (1 DAY)
By Mr. Gobinath Ramakrishnan - 18 December 2018, 9:00 am to 5:00 pm
Kuala Lumpur
(100% Claimable From HRDF/PSMB)
Course Objectives:

Designed for those who are geared up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to create macros, audit and analyse worksheet data, create Pivot Tables and Pivot Charts, use lookup tables and import and export data.

Course Pre-Requisites:

To get the most out of this course, we recommend completion of one of the following courses, or equivalent knowledge from another source: Excel 2010 (Basic) / Excel 2010 (Intermediate).

Duration

7 Hours, 1 Day.

Course Outlines :-
  1. SPARKLINES
    • Introduction
    • Insert A Sparkline
    • Customize The Sparkline
  2. ADVANCED FORMULAS & FUNCTIONS
    • Introduction
    • Insert A Function
    • Names In Formulas
    • Sumif Function
    • Date & Time Functions
    • Text Functions
    • Pmt Function
    • Logical Functions
    • Vlookup
  3. FORMULA AUDITING
    • Introduction
    • Formula Auditing Example
    • Trace Precedents
    • Remove Arrows
    • Trace Dependents
    • Show Formulas
    • Error Checking
    • Evaluate Formula
  4. DATA VALIDATION
    • Introduction
    • Applying Data Validation To Restrict Data
    • Applying Data Validation List
  5. PIVOTTABLES
    • Introduction
    • Insert A Pivottable
    • Add Fields To A Pivottable
    • Filter Pivottable
    • Sort Pivottable
    • Refresh Pivottable
    • Change Summary Calculation
    • Another Pivottable
  6. PIVOTCHART
    • Introduction
    • Create A Pivot Chart
    • Filter Pivot Chart
    • Change Pivot Chart Type
    • Switch Row/Column Pivot Chart
  7. WHAT-IF ANALYSIS
    • Introduction
    • Goal Seek
    • Data Tables
    • A Second Data Table
    • Scenarios
  8. PASSWORD PROTECTION
    • Introduction
    • Password Protect A File
    • Password Protect A Worksheet
    • Password Protect A Formula
    • Protecting Workbook
  9. WORKING WITH MACROS AND USER DEFINED FUNCTIONS
    • Introduction
    • Turn On The Developer Tab
    • Create A Command Button
    • Create And Assign The Macro
    • Msgbox
    • Macro Errors
    • Debug Macros
Your Trainer

Mr. Gobinath Ramakrishnan is a PSMB certified soft skills trainer whose abilities vary from technical skills to team building. His passion of going to the root of the problem and solving it successfully has earned him the respect of clients and associates alike.

Creative trouble shooting is his forte in the training room. Dr Gobinath also has the rare skill of mastering moments in a training session which is knowing when to coach, counsel and back track in a calm and measured way. This results in outcomes where participants feel encouraged and supported during learning process.

A sharp trainer Dr Gobinath gets his inspirations to deliver incisive modules in an interesting way where experiences are drawn from sport biking, road riding and 4Wheel Offroads. He is a dynamic and versatile speaker who is multi-lingual and approachable. He is able to conduct programs in three languages: English, Bahasa Malaysia and Tamil.

Dr Gobinath gives his very best in every training session laced with humour and fun activities. Concepts are translated into applicable and practical techniques because he believes that people not only need to know what to do, but more importantly how to do it.

Professional Experience:

  • Coaching, training and designing learning programmes call centre based in Malaysia and Australia
  • Coaching,training and preparing new Service Desk agents before they can take up their duties
  • Based in Australia to train and transition new Service Desk agents in Perth
  • Corporate soft skills training for clients in Malaysia
  • IT Training for local companies and multinationals

Skill Sets

  1. Soft Skills
    • Customer Service Excellence
    • Management Skills
    • Managing Difficult Customers
    • Positive Working Attitude
    • EQ at Workplace
  2. IT Training
    • MS Excel (Basic, Intermediate and Advance)
    • MS Word (Basic, Intermediate and Advance)
    • MS PowerPoint (Basic, Intermediate and Advance)
  3. Team Building
    • The Power of Team Work
    • Achieving Excellency thru Team Work
    • T.E.A.M – Together Everyone Achieves More

Certifications

  1. PSMB Certified Trainer
  2. Advance Level in The Power Of Sub-Conscious Mind

A short list of clients include:

Petroliam Nasional Berhad, Goodyear Malaysia, Monier, YTL Group, SIME Hospital, KPJ Group, TDK Lambda, GAB, PHN Industry Sdn Bhd, Honda, Prudential, Sudong (M) Sdn Bhd, Hong Leong Bank, Dunlopillo (M) Sdn Bhd, QSR Holdings, DRB-HICOM, DHL Supply Chain, EXIM Bank, RHB Bank, Hawley & Hazel, Huntsman, Panasonic, Sapura, Gibraltar BSN,...and more.

Course Fee
(Course fee is inclusive of 2 tea breaks, lunch, course material,Certificate of Attendance)
Early Bird for training in KL : ( Book Before 4 December 2018 )
1 person or more ~ RM 680 / person
Standard
1 person ~ RM 780 / person
2 persons or more ~ RM 680 / person
(Course fee is inclusive of 2 tea breaks, lunch, course material, Certificate of Attendance)
Terms & Conditions:
1. Registration & Fees Policy
Registration is confirmed once registration form is received via fax/email/mail. All Payments/Undertaking Letters/Local Order (LO)/Letter of Approval must be made available and presented prior to the course.
2. Cancellation Policy
Any cancellation must be received in writing within 7 working days prior to the event else full payment will be imposed. Any no-show by registered delegates will be liable for full payment of the program fees.
3. Disclaimer & Program Changes Policy
Scientia Training Sdn Bhd reserves the right to amend or cancel the event due to circumstances beyond its control. We reserved the right to modify the advertised topics or course timing whenever necessary.
Registration:
1. Fax 03-6207 6727
       OR
3. Payment shall be made payable to SCIENTIA TRAINING SDN BHD
Contact Us:
Scientia Training Sdn. Bhd. (1001247-U)
GST: 001871699968
Tel: 03 7732 0477     Fax: 03-6207 6727     
Info    019 335 1111     info@scientia.com.my
Sara    019 335 1111     sara@scientia.com.my
Nonie    019 327 1111     nonie@scientia.com.my
Max    012 375 2003     max@scientia.com.my
For Customised In-House Training:
Ronny     012 223 6666     ronny@scientia.com.my
Office Hour: Monday ~ Friday 9.00 am~6.00 pm
Click here to request for a Brochure
Copyright (c) 2015 by Scientia Training Sdn Bhd