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

This course will enable delegates to streamline repetitive tasks and display spreadsheet data in more visually effective ways. The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the web. 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:

Should know to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2010 to streamline and enhance your spreadsheets with templates, charts, formulas and much more. To get the most out of this course, we recommend completion of the following course, or equivalent knowledge from another source: Excel 2010 (Basic)

Duration

7 Hours, 1 Day.

Course Outlines :-
  1. USING TEMPLATES
    • Introduction
    • Creating Templates
  2. PASTE SPECIAL OPTIONS
    • Introduction
    • Paste Special Dialog Box
    • Quickly Transpose Excel 2010 Data Using Paste
    • Skip Blanks
  3. IMPORTING/EXPORTING TEXT FILES & DATABASE
    • Introduction
    • Text Files
    • Access Database
  4. SORTING, FILTERING & OUTLINING DATA
    • Introduction
    • Sorting Data
    • Filtering Data
    • Outlining Data
  5. FORMATTING TABLES
    • Introduction
    • Applying Table Format
    • Modifying Tables
  6. NAMED RANGES
    • Introduction
    • Name A Range - Excel Name Box
    • Use Excel Names
    • Create A Dynamic Named Range
    • Use Range Names In Formulas
  7. HYPERLINKS, LINKING & EMBEDDING
    • Introduction
    • Linking
    • Hyperlink
  8. USING CONDITIONAL FORMATTING
    • Introduction
    • Conditional Formatting Rules
    • Conditional Formatting Presets
    • To Remove Conditional Formatting Rules:
  9. CHARTING
    • Introduction
    • Parts Of A Chart
    • Chart Types
    • Creating A Chart
    • Chart Tools
  10. DATA CONSOLIDATION
    • Introduction
    • Two Types Of Data Consolidation
    • Consolidate Data By Position
    • Consolidate Data By Category
    • An Example Of Data Consolidation
    • Use A Formula To Consolidate Data
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 3 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