Practical Tips & Tricks on Microsoft Excel
Course Information
  • 25-Feb-2020
  • Klana Resort Hotel, Seremban
  • N. Selvam
  • English
  • RM 590 RM 490
    Until 02 Feb 2020
  • 9am - 5pm
[01] COURSE OBJECTIVES

To train the participants on many of the tips, tricks and useful functions found in Ms-Excel. This will allow the participants to make “greater use” of Excel to increase productivity and move their Excel knowledge and skills to the next level

[02] REQUIREMENTS
• A working knowledge of Excel is required
• Attendees are required to bring along a laptop equipped with Excel 2016 or Office 365 Excel Application

[03] METHODOLOGY

• 20% Discussion & Tutorial by Facilitator
• 80% Hands-on training with Exercises

[04] WHO SHOULD ATTEND

• Anyone who uses Excel his/ her line of works
• Anyone who wishes to improve Excel skills and application
• Executives & managers who use Macros & Pivot Tables in reportings
• Those who need exposure to some advanced features for their works (incl. financial analysis)

[05] DATE, TIME & FEE

DATE: 25 February 2020 (Tue)
TIME: 9AM - 5PM
VENUE: Klana Resort Hotel, Seremban

[HRDF CLAIMABLE]

FEE:
Early Bird Offer (before 2 Feb 2020) - RM 490
Special Offer (before 14 Feb 2020) - RM 540
Normal Fee - RM 590

>> Fee includes Course Notes, Lunch, Refreshments/ Tea Breaks, Certificate of Attendance & 6% Government Service Tax

**Discounts**
(i) SST2u Loyalty Card Member - overriding 10%

[06] COURSE CONTENT


• Learn many of the useful short-cut keys to speed data entry and movement in Excel
• Learn over 50 practical tips & tricks
• Learn how to build simple MACROS to automate processes
• Learn how to combine files using Power Query
• Learn why you should use Tables when building Pivot Table
• Learn more about building Charts e.g. Waterfall Chart
• Learn how many of the useful Excel Commands & Function
• Learn how to use the many Text Functions in Excel
• Learn how to use Conditioning Formatting
• Learn about protection in Excel

[07] SPEAKER PROFILE

N. SELVAM
CA,(M),ACMA,
CGMA PRINCIPAL CONSULTANT

N. Selvam is a Chartered Accountant and a Member of the Malaysian Institute of Accountants (MIA). He has more than 15 years experience in the corporate world.He has conducted more than 100 hands-on training sessions for Pivot table-and excel functions.
To-date, he has written five training manuals for renowned accounting software. He is a Certified Software Consultant and has conducted numerous seminars, trainings and workshops on GST for KL Customs & MIA Members.

[08] ENQUIRY & REGISTRATION

Enquiry: SSTcourse@gmail.com
Enquiry:
General (03 - 8082 3357)
Teo (011 - 3178 9203)
Logesh (012 - 503 0346)
Siti (012 - 383 8603)