[Online 2-Day] Certificate In Data Analysis Using Excel & Tableau
Course Information
  • 21-Feb-2023
  • Online
  • N. Selvam
  • English
  • RM 940 RM 870
    Until 16 Feb 2023
  • 9:00am - 5:00pm


In the advent of a data-driven economy, every industry, ranging from finance, manufacturing, retail, information technology to oil & gas, is craving for data savvy personnel. As the name implies, data is being analysed to discover trends and potential implications. As a direct result, there is an increasing demand for Data Analysis. 

Indeed, according to Garter Report, worldwide Business intelligence and Analytics market is expect to grow up to USD22.8 billion in the next 2 years. Both Excel and Tableau are important and popular applications used extensively for data analytic and visual presentation. This training is designed for students who are interested in going beyond basic skills, and grow their capacity for Data Analytics. 

This workshop will guide you in an easy, stress-free way. This course is designed to teach you the most popular functions and features of Excel, as well as useful Tableau’s. 



• Use Cell Styles and format spreadsheets easier and faster 

• Become comfortable and familiar with the entire Excel dashboard, tabs and ribbons 

• Use the most commonly used Excel functions to make powerful calculations 

• Create your own Excel charts, graphs and tables • Create pivot tables and charts for lightning fast 

sorting and organizing
• Learn tips, tricks and shortcuts for Excel
• Introduction to Tableau Business Intelligence tool • Deploying Tableau statistics and interactive 

• Data Connections for simplifying and organizing data • Tableau data visualization and real-time analytics
• Mastering Tableau generated fields and special fields 




• Professionals working with data in any industry, esp. ideal for an intermediate Excel user who wants to improve his/ her data analysis skills 

• Those tasked with analysing data, business intelligence, interpreting statistics 

• Those who are interested in data visualization
• Students from various quantitative backgrounds, like 

Engineering, Finance, Maths, Statistics, Economics, 

Business Management
• Graduates and Professionals looking to move into the 

analytics domain 



• You will learn how to install Tableau Public which is free. There will be more than 3-5 hands-on exercises which will help you build the skills you need to work with Tableau Public 

• Participants will be given a copy of “Data Visualization with Tableau for Beginners” (2nd Edition) 



Computer literacy and knowledge of working with basic Microsoft Excel is necessary. Please bring along 64 bit Notebook installed with Excel 2013 or later. 


Computer literacy and knowledge of working with basic Microsoft Excel is necessary. Please bring along 64 bit Notebook installed with Excel 2013 or later. 


[06] DATE, TIME & FEE 


DATE:              21-22 February 2023 (Tue-Wed)

TIME:               9.00am - 5.00pm

MODE:             Online / Interactive


FEE:   [ HRD Corp Claimable ]

  -  Special Offer (before 16 Feb 2023)       –       RM 870

  -  Normal Price       –       RM 940

>> Fee includes Course Notes, Certificate of Completion and 6% Service Tax

** OFFER **
- 10% Cashback for SST2u Learner Card+ (SLC+) members. T&Cs applied.


HRDCorp Claimable Course:

Trainer MyCoiD: 429594X

Course Scheme: HRDCorp Claimable Course

Course Type: Remote Online Training (Public)

Course Code: 1000164708




DAY 1 

[01] Excel For Analytics 

• Workbook and Backstage View / Excel Options 

- Working with the Ribbon
- Working with the Quick Access Toolbar
- Auto Recover 


• Working with Name Range 


[02] Working with Constant Values and Formulas 

• COPY and PASTE AS Options 

• Using AutoFill/ Flash Fill 


[03] Working with Formatting and Data Validation 

• Applying Conditional Formatting 

• Using Data Validation
• Cell Formatting 


[04] Working with Advance Formula/ Functions 

• Text Formula
• Date & Time Formula
• Logical Formula
• Lookup & Reference Formula
• Financial Formula
• Industry related solution practices [Formula] 


[05] Using Protection and Shared Workbook Features 

• Protecting Workbooks and Worksheets 


[06] Working with Data 

• Converting Text to Columns • PASTE As Options 


[07] Working with Charts 

• Creating Charts
• Changing the Chart Location and Size • Changing the Chart Type
• Modifying Chart Elements
• Formatting Chart Elements
• Adding and Removing Data Series
• Applying a Chart Filter
• Printing Charts 



[08] Additional Excel Features 

• Reference Styles [A1] & R1C1 

• Outline [Group – Ungroup]
• View [Panel] 


[09] Using Tableau’s Interactive, Slice-and-dice Features 

• Introduction to Tableau Public 

• Installation
• Creating A Profile 

[10] The Startup Screen for Tableau Public
[11] The Data Source Page
[12] Exploring the Tableau Workspace
[13] 4 Pivot Tables, 3 Pivot Charts and 1 Dashboard built using Microsoft Excel

[14] Building Similar Tables & Charts using Tableau Public [15] Building 6 Popular Charts to Acquire Additional Skills Sets

[16] Putting the Viz/ Charts Together to Build a Dashboard and Sharing
[17] Introduction to Sets, Filters, Parameters and LOD
[18] Exercises, Q&As 






Excel & Tableau Expert, Author, Chartered Accountant

HRDF Certified Trainer


N. Selvam is a Member of the Malaysian Institute of Accountants (MIA), Chartered Institute of Managements (CIMA), Chartered Global Management Accountant.

(CGMA) and a Certified Software Consultant. He runs a software consulting firm for over 30 years.

When Malaysia implemented GST, he was an authority on analysing the GST Audit File (GAF) using Excel. He conducted over 300 hands-on training session for MIA, CIMA, Customs and many big corporations.

He lectured for more than 6 years in a local university on Computerized Accounting and wrote 5 Users Guides. In 2019, he was given TTT exemptions by HRDF.   In 2020, he published two books on “Data Visualization with Tableau for Beginners” and he is now working on Volume 3.





Enquiry: yes@sst2u.com


- Teo (011 - 3178 9203)

- Logesh (012 - 503 0346)

- Siti (012 - 383 8603)

- Han (019 - 323 0507)