fbpx

ANALYTICS WITH EXCEL 101

The core of having data is to be able to analyse and get actionable insights. The good news is Excel has some tools in analysing data. This course focuses on how you can utilise data from different sources and teaches you how to analyse it using various Excel capabilities.

Enrol Now

Course Duration and Method

Instructor-led sessions | 8.5 hours | Live online

CREATED BY

Course Overview

Learn how to import, transform, filter and visualise data in this hands-on workshop.

Pre-requisites

This is a beginner-friendly course with no pre-requisites; however, some basic knowledge of Excel will be an advantage. Participants should own laptops/PCs with Excel 2016 or later versions installed.

This course utilises Power Query and Power Pivot functions which may not be available in Excel for Mac. Mac users please check if Power Query and Power Pivot can be installed in your version.

Who should attend

Anyone wishing to learn analytics using Excel

Learning Outcomes

At the end of the course, participants will be able to:

  • Describe the analytics life cycle
  • Use Excel to import, transform and clean data
  • Create a data model in Excel
  • Use Excel to create visualisation using PivotChart, slicers and report connections

Course Outline

  • Introduction
  • Analytics Processes – this module covers the analytics life cycle, data extraction & transformation and data visualisation
  • Case Study

Elite Instructors

Our instructors are committed to provide you with personalised guidance and feedback to ensure you get the most out of the course.

Dr Mark Chia

BEng (Hons), BSc, PhD, CEng, MIET, SMIEEE

Mark is a thought leader in data science and is passionate about the data science ecosystem. He is a firm believer in talent development and sits on the advisory boards of various universities. He is also a member of advisory panels in various organisations.

Before launching Mobius, Mark was the Director of Data at Astro. He was responsible for the integration, utilisation and monetisation of data across the Astro Group. He brought together the disciplines of data management, visualisation and advanced analytics to generate value for Astro. Prior to Astro, Mark helmed the graduate and internship programmes at SAS. He has worked in data science and IT for over 15 years with various overseas companies.

Dr Tang U-Liang

Phd (NUS), BSc (Hons) 2nd upper (Mathematics) (NUS)

 U-Liang is the Head of the School of ICT, Faculty of Computing and Digital Technology, HELP University. He is active in promoting the upskilling of adult learners and is driving the Faculty’s Centre for Industry 4.0 (CIR4.0). He has taught in Singapore Polytechnic and is familiar with the adult education especially training in the areas of data science, analytics, machine learning and artificial intelligence. He has conducted several consultancy projects with various government agencies and industry while in Singapore. U-Liang has a keen interest in promoting the importance and impact of IT and data science among professionals. His areas of research are in statistics and data science.

Course Fee

Course Fee:  RM600.  FREE for Aug and Sept sessions

HELP University and Mobius are committed to prepare Malaysians in data science and assist those who wants to level-up their data skills. We are offering this course at no charge for the August and September session.  Limited places only so ENROL NOW to secure your seat!

Course Duration and Schedule

2 x 4 hour 15 min session

Forthcoming Sessions (Bookings Open) :

August intake – 11, 12 August 2021 (6:00pm – 10:15pm)

September intake – 20, 21 September 2021 (6:00pm – 10:15pm)

October intake – 21, 21 October 2021 (6:00pm – 10:15pm)

Learn about data science now and how to use it for the future!

So, what are you waiting for?

Enrol Now

This could be helpful to you

1. Why should I attend this Course?

More and more Corporations and businesses are adopting the use of analytics in order to secure an advantage in this competitive world.  Whatever position you’re in, whether you’re an employee of a organisation or an entrepreneur running your own business, it is vital to learn analytics and how to import and combine data sources, clean and filter data and visualise the data to obtain insights which can be actioned upon to benefit the business.

2. Are there any pre-requisites for this Course?

This is a beginner-friendly course with no pre-requisites; however, some basic knowledge of Excel will be an advantage. Participants should own laptops/PCs with Excel 2016 or later versions installed.

This course utilises Power Query and Power Pivot functions which may not be available in Excel for Mac. Mac users please check if Power Query and Power Pivot can be installed in your version.

3. Will I receive a Certificate on completion?

Yes, upon passing the Course you will receive an Analytics With Excel 101 Certificate!

4. I am working full-time. Do you have evening sessions?

Yes!  Our Course Schedule also takes into account the needs of full-time employees.  You can choose to attend the evening sessions.

5. How do I enroll for this Course?

It’s simple!  Click the ‘Enrol Now’ button and fill in the information and click the ‘Submit’ button.  Our Enrolment team will contact you shortly with the Booking Form