MICROSOFT EXCEL FOR WORK 2013 - ADVANCE LEVEL (1 DAY)
By Mr. Gobinath Ramakrishnan - 17 November 2017, 9:00 am to 5:00 pm
Kuala Lumpur
(100% Claimable From HRDF/PSMB)
PROGRAMME OBJECTIVE

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 learn advanced formulas, creating macros, using What If Analysis tools, create Pivot Tables and Pivot Charts, subtotaling and securing your data.

COURSE PRE-REQUISITES:

Participants should be familiar with using computers and have used a mouse and keyboard. Participants should be comfortable in the Windows environment and be able to use Windows to manage information on their computer.

To get the most out of this course, we recommend completion of one of the following courses, or equivalent knowledge from another source: Windows 2003/ Windows 7 and Microsoft Excel 2013 Basic and Microsoft Excel 2013 Intermediate.

METHODOLOGY

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Duration

7 Hours, 1 Day.

OUTLINE :-
  1. MODULE 1: USING ADVANCED FORMULAS
    • Using Formulas to Conditionally Summarize Data
    • Using Formulas to Look Up Data in a Workbook
    • Adding Conditional Logic Functions to Formulas
    • Using Formulas to Modify Text
  2. MODULE 2: SECURING YOUR WORK WITH PASSWORDS
    • Protecting a Worksheet
    • Protecting a Workbook
  3. MODULE 3: TRACKING CHANGES
    • Turning Track Changes On and Off
    • Set Track Change Options
    • Insert Tracked Changes
    • Delete Your Changes
    • Accept Changes from Another User
    • Reject Changes from Another User
    • Remove Shared Status from a Workbook
  4. MODULE 4: ADDING COMMENTS
    • Inserting a Comment
    • Viewing a Comment
    • Editing a Comment
    • Deleting a Comment
    • Printing Comments in a Workbook
  5. MODULE 5: OUTLINING AND SUBTOTALING DATA
    • Grouping and Ungrouping Data
    • Auto-Outlining Data
    • Collapsing Groups of Data in an Outline
    • Subtotaling Data in Outlines
  6. MODULE 6: PIVOTTABLES AND PIVOTCHARTS
    • Creating a Basic PivotTable
    • Adding a PivotChartr
  7. MODULE 7: WHAT IF ANALYSIS
    • Using PMT function as a Platform
    • Goal Seek
    • Data Table
    • Scenario Manager
  8. MODULE 8: USING BASIC MACROS
    • Recording a Basic Macro
    • Running a Macro
    • Managing Macro Security
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. 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 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.

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. Communication and Interpersonal Skills
    • Good Telephone Manners and Courtesies
    • Interpersonal Skills
  2. Frontline Staff Training
    • Delivering Excellent Customer Service
    • Managing difficult customers
    • Customer service communication
    • Managing Call Centres
    • Effective Telemarketing
  3. IT Training
    • MS Excel (Basic, Intermediate and Advance)
    • MS Word (Basic, Intermediate and Advance)
    • MS PowerPoint (Basic, Intermediate and Advance)
  4. Team Building
    • The Power of Team Work
    • Achieving Excellency thru Team Work
    • T.E.A.M – Together Everyone Achieves More

Education

BMM (HONS), University Utara Malaysia

A short list of clients include:

Petroliam Nasional Berhad, Goodyear Malaysia, GAB, PHN Industry Sdn Bhd, Honda, Prudential, Hong Leong Bank, QSR Holdings, DRB-HICOM, DHL Supply Chain, EXIM Bank, RHB Bank, Hawley & Hazel, Huntsman, Panasonic, Sapura, Gibraltar BSN and many more.

Course Fee
(Course fee is inclusive of 2 tea breaks, lunch, course material,Certificate of Attendance and 6% GST)
Early Bird for training in KL : ( Book Before 3 November 2017 )
1 person or more ~ RM 995 / person
Standard
1 person ~ RM 1095 / person
2 persons or more ~ RM 995 / person
(Course fee is inclusive of 2 tea breaks, lunch, course material, Certificate of Attendance and 6% GST)
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-7735 6006     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 8.30 am~5.30 pm
Click here to request for a Brochure
Copyright (c) 2015 by Scientia Training Sdn Bhd