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

This course will enable participants to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target audience for this course are participants who desire to gain the skills necessary to manage worksheets, sort and filter data, creating charts and using Functions. In addition, this course is suitable for those interested to step-up a level with existing knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

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.

Methodology

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

Duration

7 Hours, 1 Day.

Course Outlines :-
  1. MANAGING WORKSHEETS
    • Organizing Worksheets
    • Working with Multiple Worksheets
    • Finding and Replacing Data
  2. FORMAT AS TABLE
    • Using Quick Style
    • Removing Style from a Table
    • Defining a Title
    • Using the Total Row Command
    • Removing Duplicates
    • Using a Slicer to View Table Data
    • Converting a Table into a Range
  3. USING CONDITIONAL FORMATTING
    • Apply a Specific Conditional Format
    • Apply Multiple Conditional Formatting Rules
    • Use the Rules Manager to Apply Conditional Formats
  4. DATA VALIDATION
    • Restrict Cell Entries to Certain Data Types
    • Allow Only Specific Values to Be Entered in Cells
    • Remove Duplicate Rows from a Worksheet
  5. SORTING DATA
    • Sort Data on a Single Criterion
    • Sort Data on Multiple Criteria
    • Sort Data Using Cell Attributes
  6. FILTERING DATA
    • Using AutoFilter
    • Creating a Custom AutoFilter
    • Filtering Data Using Cell Attributes
  7. CREATING CHARTS
    • Building Charts
    • Formatting a Chart with a Quick Style
    • Formatting the Parts of a Chart Manually
    • Modifying a Chart
    • Using New Quick Analysis Tools
  8. USING FUNCTIONS
    • Displaying Dates and Times with Functions
    • Summarizing Data with Functions
    • Uncovering Formula Errors
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 2 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