Course Information

  • Sessions 2 days
  • Duration 15 hrs
  • Level Beginner
  • Assessment NA

Venue

Download Course Brochure

Certification

  • Certificate of Completion from Tertiary Courses - Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from Tertiary Courses.

Data Analytics with Excel

Course Code: M939

What's This Course About

Our Data Analytics with Excel course offers an in-depth exploration into the world of data analysis through the lens of Excel. Designed for professionals and enthusiasts alike, this course emphasizes practical skills in data interpretation, visualization, and reporting. You will learn to leverage Excel's advanced features and data tools to transform raw data into meaningful insights. Whether you're looking to enhance your career or simply improve your analytical skills, this course provides a comprehensive learning experience.

The curriculum is meticulously crafted to include the latest in data analytics techniques and Excel functionalities. You will engage in hands-on projects that simulate real-world business scenarios, ensuring that you gain practical and applicable knowledge. From mastering pivot tables and advanced formulas to creating impactful data visualizations and dashboards, this course is your gateway to becoming proficient in using Excel for effective data analytics. Join us to unlock your potential in the evolving field of data analytics.

Course Fee

₦340,000.00

Course Date

Course Time

* Required Fields

Additional Note

Please bring your own laptop for hands-on training. If you don't have laptop, we can provide spare laptop for training use.

Post-Course Support

We provide free consultation related to the subject matter after the course. Please email your queries to info@tertiarycourses.com.ng and we will forward your queries to the subject matter experts and get back to you as soon as possible.

Cancellation & Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.

Note: the venue of the training is subject to changes due to class size and availability of the classroom. The minimum class size to start a class is 3 Pax.

Course Details

Course Details

What You'll Learn

Topic 1 Getting Started with Excel

  • Explore Excel user interface
  • Enter and validate data for analysis using Excel Power Query
  • Data management with Excel
  • Use formulas and functions

Topic 2 Basic Data Analysis using Excel

  • Use LOOKUP and REFERENCE functions to integrate information
  • Use IF functions to analyse data
  • Basic statistics and use statistical functions

Topic 3 Basic Data Visualisation using Excel

  • Create chart and reports to identify trends in data
  • What is regression?
  • Create reports on regression and risk analysis

Topic 4 Advanced Data Analysis using Excel

  • Use PivotTables and PivotCharts to identify patterns across multiple datasets
  • Perform what-if analysis using Scenario Manager, Goal Seek and Data Table
  • Data governance and security with Excel

Topic 5 Hypothesis Testing with Excel

  • What is hypothesis testing?
  • Apply hypothesis testing techniques in Excel

Course Info

HRDF Funding

Please refer to this video https://youtu.be/Kzpd-V1F9Xs

1-     HRD Corp Grant Helper

How to submit grant applications for HRD Corp Claimable Courses

2-     Employers are required to apply for the grant at least one week before training commences.

Employers must submit their applications with supporting documents, including invoices/quotations, trainer profiles, training schedule and course content.

3-     First, Login to Employer’s e-TRIS account -https://etris.hrdcorp.gov.my

Second, Click Application

4-     Click Grant on the left side under Applications

5-     Click Apply Grant on the left side under Applications

6-     Click Apply

7-     Choose a Scheme Code and select HRD Corp Claimable Courses: Skim Bantuan Latihan Khas. Then, click Apply

8-     Scheme Code represents all types of training that suit the requirements provided by HRD Corp. Below are the list of schemes offered by HRD Corp:

9-     Select your Immediate Officer and click Next

10-  Select a Training Provider, then click Next

11-  Please select a training programme from the list, then key in all the required details and click Next

Select your desired training programme.

Give an explanation on why the participant is required to attend the training. E.g., related to their tasks/ career development, etc.

Explain the background and objective of this training.

Select a relevant focus area. For Employer-Specific Courses, select ‘Not Applicable’.

12-  If the training programme is a micro-credential programme, you are required to complete these 3 fields. Save and click Next

Insert MiCAS Application number

13-  Based on the nine (9) pillars listed below, HRD Corp Focus Area Courses are closely tied to support government initiatives towards nation building. As such, courses offered through the HRD Corp Focus Areas are designed to provide the workforce with skills required for current and future demands. Details of the focus areas are as follows:

14-  Please select a Course Title and Type of Training

15-  Select the correct type of training according to the actual type of training, or as mentioned in the training brochure:

16-  Please key in the Training Location and click Next

17-  Please select the Level of Certification and click Next

18-  Please follow the instructions and key in trainee details

19-  Click Add Batch, then click Save

20-  Click Add Trainee Details

21-  Please key in all the required details, then click Add

22-  Click Add if there are more participants. Once done, click Save

23-  Click Next

24-  Please key in the course fees and allowance details, then click Save

25-  Estimated cost includes the course fees/external trainer fees, allowances, and consumable training materials. Please comply with the HRD Corp Allowable Cost Matrix.

26-  Select Upfront Payment to Training Provider and key in the percentage from 0% to 30%. Then, click Save and Next

27-  Complete the declaration form and select a desired officer

28-  Add all the required documents, then click Add Attachment. Then, click Save and Submit Application

29-  Once the New Grant Application is successfully submitted, the Grant Officer will evaluate the application accordingly. The application may be queried if additional information is required.

The application status will be updated via the employer’s dashboard, email, and the e-TRiS inbox.

Job Roles

Job Roles

  • Data Analyst
  • Business Analyst
  • Financial Analyst
  • Operations Manager
  • Marketing Analyst
  • HR Metrics Specialist
  • Sales Operations Specialist
  • Report Developer
  • Project Manager
  • Management Accountant
  • Product Manager
  • Supply Chain Analyst
  • Performance Metrics Specialist
  • Market Researcher
  • Business Intelligence Coordinator

Trainers

Trainers

Belinda Gan

Belinda graduated from Nanyang Academy of Fine Arts (NAFA) in 2017 with a diploma in Furniture & Spatial Design. With 3 years of training in software skills , mainly Photoshop , Illustrator , Rhinoceros , Inventor ,T spline, Autocad and Vray. Belinda works with softer and rounder forms that are more challenging to create . Also more towards graphic design in Photoshop and Illustrator for most occasions.

Review

Write Your Own Review

You're reviewing: Data Analytics with Excel