Effective Data Analysis Using Excel

What Skillset do you wish to acquire?

Effective Data Analysis Using Excel

Course Overview

Effective Data Analysis Using Excel

This course will equip learners with data analysis skills using Excel by applying the various formulae and functions available in Excel as well as using Power Pivot to connect to different and multiple data sources for statistical analysis.

Course Title

Effective Data Analysis Using Excel

Course Objectives

At Course Completion

  • Apply principles of data modelling and visualization to create data models to identify and predict trends and patterns.
  • Use data science techniques to perform data analysis on data sets.
  • Apply data protection and legal guidelines to support the creation of business insight reports
  • Apply DAX language to summarize data to provide business insights from data source.
  • Apply statistical techniques and formulas to produce analytical dashboards and insight reports.
  • Join multiple tables using unions to extract data analysis aligned to the domain context.
  • Create clean required dataset with functions and formulas to visualize data.

Pre-requisites

  • Be able to listen and speak English at a proficiency level equivalent to the Employability Skills Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 3.
  • Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 3.
  • Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 3.
  • Learners to have minimum GCE ‘O’ level or ITE certificate education
  • Learner should have at least 1 year’s working experience in any industry.
  • Be able to operate a computer.

Effective Data Analysis using Excel

Course Outline

UNDERSTANDING DATA MODELLING AND VISUALIZATION TO PERFORM DATA ANALYSIS
  • Create Data Models using Power Pivot
  • Create Pivot Tables and Pivot Charts for Forecasting and Recognizing Patterns and Trends.
USING EXCEL FUNCTIONS TO APPLY TECHNIQUES ON DATA SETS FOR DATA ANALYSIS
  • Introduction to Advanced Excel Functions and Features for Data Analysis
USING POWER PIVOT FOR DATA MODELLING AND APPLYING DATA INTEGRITY
  • Using Power Pivot Models to Create Business Insight Reports
  • Applying Data Protection Rules in Excel
USING DAX FOR ANALYSIS TO PROVIDE BUSINESS INSIGHTS
  • Using DAX to summarize data for analysis and business insights
USING STATISTICAL TECHNIQUES AND DATA ANALYSIS TOOL PAK FOR CREATION OF DASHBOARD REPORTS
  • Introduction to Statistical Formulas and Techniques for Dashboard Reports
  • Data Analysis Tool Pak for Business Insight Reports
USING EXCEL FUNCTIONS AND QUERIES TO EXTRACT DATA FOR DATA ANALYSIS
  • Joining Multiple Tables to Extract Data for Data Analysis and Visualization
TRANSFORMING DATA FOR DATA ANALYSIS USING EXCEL FUNCTIONS AND FORMULAE
  • Data cleaning and validation of Required Dataset for Visuals

For other related courses, please visit Design Software or Microsoft Office.

Course Feature

Course Feature

Course Provider: James Cook Institute Pte Ltd
UEN: 198802365N
Course Reference Number: TGS-2023020187
Mode Of Training: Classroom
Funding Validity Period: 17 Apr 2023 To 16 Apr 2025

Effective Data Analysis using Excel

FULL COURSE FEE$518.40
Singaporean 40 yrs and above$182.40
Singaporean 21-39 yrs / PR$278.40
Duration2 Days
(16 hrs)
Skillfuture _ SFEC _PSEA Eligible

Available in: English

Book Class Now!

Contact Us On Whatsapp

Contact Us Now On Whatsapp
+65 6255 5584

Coursemology
4.9
Based on 87 reviews
powered by Google
Tee AhwenwenTee Ahwenwen
08:50 26 Feb 23
Ms Ashley Shirley wong is a nice and cheerful teacher thanks for today 26feb23 thank you I am wenyi is teachable teacher and i understand everything and enjoying your lesson so much 😊 really appreciate that.
Ben HanBen Han
18:30 03 Jan 23
Coursemology provides a wide range of massage courses with flexible training schedules..Sales manager , Rachel Lip, assisted me quickly and positively with both my course enquiries as well as the registration of my chosen massage course in a fuss free manner..So for my friends out there...If you are looking to enrol for serious massage courses..Coursemology is your recommended choice...RegardsBen Han
Devaghi ATDevaghi AT
00:35 15 Aug 22
The trainers were very Knowledgeable n conducted the session to participants understanding. Friendly n approachable. Motivational approach during practicals. I benefited from Course. Tq, trainers.
Mohd IqbalMohd Iqbal
09:58 24 May 22
My Food and Hygiene course here was superb! Instructor is very helpful to ensure you understand the importance of Cleanliness and Safety in the kitchen. I highly recommend Coursemology.
MattMatt
02:58 12 May 22
Attended the Food Hygiene course at vision exchange. The course sign up and payment process was fast and simple. The instructor was fun and engaging and helpful. Highly recommend this place if you want to get your food hygiene cert.
Joey GanJoey Gan
09:29 24 Apr 22
My sister and I had many questions about the different courses. The staff present including the boss Mr Wee were very patient and friendly to help us. The centre at Toa Payoh was also easy to get to and centre facilities were kept clean and tidy. We have a very good experience.
ting siongting siong
06:05 19 Apr 22
The trainer is patient and able to explain food hygiene and safety concept clearly. She demonstrated the hand cleaning techniques, share industry practices and safety standards with participants.A good training indeed.
js_loader

Coursemology is an online course directory, listing short courses in Singapore to provide information on WSQ courses and SkillsFuture Subsidy to corporates and individuals. We do course listing for training providers in Singapore to improve your employability via skills upgrading and job skills upskilling through skills development courses.

About Us

Training Locations

Olympus Learning Academy

Blk 190 Toa Payoh Lorong 6, #02-514
Singapore 310190

2 Venture Drive Vision Exchange, #07-23 Singapore 608526

NTUC Income Tampines Junction, 300 Tampines Avenue 5 (Opposite Our Tampines Hub) #07-05 Singapore 529653

Mon to Sun : 8:30am to 6:00pm
Closed on Public Holidays