[Online 2-Day] Certificate In Data Analysis Using Excel & Tableau
Course Information
  • 09-Jun-2021
  • Online
  • N. Selvam
  • English
  • RM 1130 RM 990
    Until 20 May 2021
  • 9:00am - 5:00pm
[01] OVERVIEW
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.

[02] COURSE OBJECTIVES
• 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 dashboard
• Data Connections for simplifying and organizing data
• Tableau data visualization and real-time analytics
• Mastering Tableau generated fields and special fields

[03] WHO SHOULD ATTEND
• 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

[04] METHODOLOGY
• 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)

[05] REQUIREMENTS
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: 9 - 10 June May 2021 (Wed - Thu)
TIME: 9.00am - 5.00pm
MODE: Online/ Interactive
CPD: 8 Hours

[HRDF CLAIMABLE | SBL KHAS]

FEE:
- Early Bird Offer (before 20 May 2021) - RM 990
- Special Offer (before 4 Jun 2021) - RM 1,060
- Normal Fee - RM 1,130

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

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

[07] COURSE CONTENTS

DAY1

[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

DAY2

[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

[08] SPEAKER PROFILE

N. SELVAM
EXCEL & TABLEAU EXPERT, AUTHOR, CHARTERED ACCOUNTANT

N.Selvam is a Member of the Malaysian Institute of Accountants (MIA), Chartered Institute of Managements (CIMA) 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.

In 2019, he was given TTT exemptions by HRDF. Besides Tableau software, he also conducts hands-on training for Excel. He is the author of “Data Visualization with Tableau for Beginners”, released in June 2020.

[09] ENQUIRY & REGISTRATION

Enquiry: SSTcourse@gmail.com
Contact:
- Teo (011 - 3178 9203)
- Logesh (012 - 503 0346)
- Siti (012 - 383 8603)
- Han (019 - 323 0507)