ONLINE

CERTIFICATE IN DATA ANALYSIS USING EXCEL & TABLEAU DATE TIME

: 28-29 JULY 2021 (WED-THU)

: 30-31 9.00AM - 5.00PM2023 (MON-TUE) JANUARY FE TIME : 9.00AM - 5.00PM Early Bird Offer RM 1000 (before 9 Jul 2021) FEE* DATE

Early Bird Offerȩ

RM

800

RM

870

RM

940

FIJSVI11 Jan3 

Special Offer

FIJSVI25 Jan 

Normal Fee

Fee includes Course Notes & Certificate of Completion and 6% Government Service Tax

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.

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 Copyrights 3ntity Sdn Bhd 2018 - 2023

COURSE OUTLINE 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 DAY 2 [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

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

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)

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.

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.

Copyrights 3ntity Sdn Bhd 2018 - 2023

REGISTRATION FORM ONLINE COURSE: CERTIFICATE IN DATA ANALYSIS USING EXCEL & TABLEAU

Certified to ISO 9001: 2015

Billing Details

TERMS & CONDITIONS Cancellation Policy Course fess are non-refundable one reservation has been confirm. No refund is given for cancellations or withdrawals. Cancelled unpaid registration will also be liable for full payment of the Course fees.

Organization Address

Replacements Please note registrations for the event are not interchangeable but replacements are acceptable. Please notify us at least five days prior to the event if you intend to send replacement.

Contact person

Designation

Email

Learner Card No.

Office Tel

Recording Video / Sound recording is strictly prohibited.

Mobile

Method of Payment Enclosed cheque/IBG no_______________________ for the sum of RM______________ Payable to “3NTITY SDN BHD (RHB: 2143 1600 000949)”

Disclaimer All information contained in this brochure is correct and accurate at the time printing. The Course Organisers reserve the right to cancel, make any amendments and/ or changes to the programme if warranted by circumstances beyond the control of the Organisers. The Course Organisers also reserve the right to make alternative arrangements without prior notice should it be necessary to do so. Upon signing the registration form, you are deemed to have read and accepted the terms and conditions.

Note: Customers using Maybank Online Payment facility, please enter Account Payee as “ENTITY SDN BHD” (due to the first alphabet “3” is not accepted)

Register your FREE SST2u Learner Card+ (SLC+) and be entitled to 10% Cashback

Registration is on a first-come-first-served basis. Only fully completed registration will be processed Reservation is only confirmed with full payment cleared

Participant Details *Please Fill In BLOCK LETTER using BLACK or BLUE Pen

No

Participant Full name Certificate of Attendance will be printed according to this name

Vegetarian [Y/N]

Mobile

Email

Claiming HRDF [Y/N]

1. 2. 3. NOTE: SCAN THIS FORM AND DEPOSIT SLIP AND EMAIL TO:

[email protected]

Online Form at www.sst2u.com Registration / Enquiry Han (019 - 323 0507)

Logesh (012 - 503 0346) Web Browser

Minimum Requirements

Operating System

Siti (012 - 383 8603)

Inbound Internet connection

• Computer: 5 Mbps or better • Mobile device: 4G or better

Software

• No additional software needed

• Windows 7 and above • Mac OS X 10.9 (Mavericks) and above

Hardware

• 4GB or more of RAM (recommended)

Click “Login” Head to www.sst2u.com

Receiving invoice & receipt

Proceed to upload Proof of Payment & Documentations (e.g. JD/14)

Phang (03 - 5888 7357)

• Google Chrome (most recent 2 versions) • Mozilla Firefox (most recent 2 versions) • Internet Explorer v11 • Apple Safari (most recent 2 versions)

MEMBER

How to Register at sst2u.com

Teo (011 - 3178 9203)

NON-MEMBER

Search “By States” or “By Categories”

Receive email confirmation including proforma invoice & HRDF supporting documents

MEMBER

Enter ID & Password. Click “Sign In” button NON-MEMBER

Official SME Business Digitalization Grant Provider Click “Register Now” You have fully understood the DISCLAIMER OF WARRANTIES AND LIMITATION OF LIABILITY stated in our 3ntity Sdn Bhd website at http://www.3ntity.com/disclaimer/.

Select the Seminar interested

Receive on-screen confirmation

Submit once you have completed the particulars

You may not, without our prior written permission, frame or inline link any of the content of this brochure, or incorporate it into another website or other service any of our material, content or intellectual property.

Organized by: 3ntity Sdn Bhd Sponsored by: FAV365

Copyrights 3ntity Sdn Bhd 2018 - 2023