COURSE OVERVIEW
Master data visualization to convey key messages effectively. This course teaches foundational skills using Excel and Google Sheets, helping you present data clearly, whether you’re a beginner or refining your skills.
Learning path objective
- Create impactful, interactive data visualizations.
- Master Pivot Tables and Excel Dashboards for dynamic reporting.
- Apply statistical analysis to derive meaningful insights.
Recommended for
All types of professionals seeking to enhance their data visualization skills.
COURSE HIGHLIGHTS
Learn and customize
conditional formatting
Create interactive
dashboards
Build Pivot Charts from
Pivot Tables
Master statistical
analysis fundamentals
Course Outline
Conditioning Formating
Learn to apply and customize conditional formatting in Excel and Google Sheets to highlight key data points. Use color scales, data bars, and icon sets to visually enhance your data and make it more readable.
1
Basics of Descriptive Data Analytics
Understand statistical measures such as mean, median, mode, variance, and standard deviation. Use these to summarize and interpret data, identify trends, and make informed decisions.
2
Pivot Table
Master creating and using Pivot Tables to organize, summarize, and analyze large datasets. Learn to configure fields, filter and sort data, and use calculated fields for complex calculations.
3
Dashboards
Build comprehensive and interactive dashboards in Excel. Integrate various charts and tables, use slicers for dynamic filtering, and design layouts that present key metrics clearly.
4
Intro to Statistical Analysis for Data Analysis
Get introduced to basic statistical analysis, including hypothesis testing, correlation, and regression analysis. Apply these methods to analyze data, identify relationships, and make data-driven decisions.
5
For course customization and further discussion, feel free to reach out to us at marketing@matrixc.com
Trainers Profile
Mazlita Mat Hassan
Director / Lead Trainer, MatrixC Academy
Mazlita Mat Hassan, known as “MEM,” is an accomplished IT corporate trainer and data science expert with a BSc in Computer Science from University College London. With over a decade of experience, she has trained more than 10,000 professionals across Southeast Asia, specializing in Microsoft Office, Google Apps, and Tableau.
As the CEO of RECQA, she drives DeLIMA 2.0, Malaysia’s National Digital Learning Platform, and leads MatrixC Academy’s Change Management training with Google Tools. Globally recognized, she is the SEA & Pacific Leader for UNCTAD’s “e-trade for women” initiative and received the 2023 Women in STEM award from Business and Professional Woman Malaysia for her contribution in co-developing DeLIMA 2.0 with MOE and Google Malaysia.
Ikmal Nordin
Data & AI Lead, Matrix Connexion
A distinguished data analytics trainer, data scientist, and AI specialist with deep expertise in data science, AI, and economic analysis. Renowned for architecting cutting-edge data solutions, he translates complex concepts into practical, high-impact training for both corporate teams and individuals.
Ikmal has successfully trained and consulted for leading companies like Proton, Star Media Group, and BE International, empowering professionals across industries to harness the power of big data and AI for significant productivity gains and career advancement.