Business Analytics with Excel

Excel in business analytics with our comprehensive Excel-focused course. Master analytical techniques to interpret complex data and gain insights that drive strategic decisions. Enroll now for an engaging learning experience with practical case studies and hands-on exercises.

Face-to-Face Apr 24, 2025
updated
beginner
Business Analytics with Excel
MYR 1750

Training Provider Pricing

Material Fees: MYR 400

Pax:

MYR 2400

Features

1 day (9:00 AM - 5:00 PM)
7 modules
21 intakes
English

Subsidies

HRDC Claimable logo

What you'll learn

  • Gain proficiency in constructing confidence intervals and conducting hypothesis testing.
  • Develop skills in predictive modeling with linear regression techniques.
  • Understand the core concepts of business analytics and differentiate it from simple analysis.
  • Master measures of central tendency and variability to describe datasets accurately.
  • Grasp the fundamentals of probability and statistical distributions.
  • Apply the Central Limit Theorem for practical statistical inference.
  • Engage in practical exercises including a detailed case study to solidify your learning.
  • Learn how to manage different types of data and perform effective data summarization.

Why should you attend?

Business Analytics with Excel is a transformative course designed to empower professionals with the analytical prowess needed to make data-driven decisions. Understanding the definition and difference between analytics and analysis sets the foundation for appreciating the role of business analytics in various domains and recognizing its potential challenges. Participants will learn about different types of analytics and real-world examples where they are applied. The course delves into data management, covering essential concepts such as population vs. sample, data variables, summarization techniques, central tendency measures, spread/variability, symmetry, skewness, collection methods, dictionaries, outlier treatment, and missing value imputation. Building on this knowledge, the course introduces basic statistics including probability theories, distributions, random variables, central limit theorem applications, sampling methods, confidence intervals, and hypothesis testing. A dedicated section on predictive modeling using linear regression provides hands-on experience with gains charts, Gini coefficients, heteroskedasticity issues, logistic regression models and includes a practical case study for learners to apply their skills.

Course Syllabus

Definition
Analytics vs. Analysis
Business Analytics
Types of Analytics
Business Domains within Analytics
Challenges
Examples
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 1

Instructor

Tasmeea Rahman
Tasmeea Rahman Lecturer Teaching

Tasmeea Rahman is a highly skilled and versatile professional with a rich background in both academia and industry. Currently serving as a Freelance Corporate Trainer at Abundent in Kuala Lumpur, Malaysia, Tasmeea specializes in developing content and providing training on a wide array of subjects including Machine Learning, Data Analysis with Python, MS Excel, Power BI, Minitab, Jaspersoft, Apache Superset, TIBCO Spotfire, and various electrical and mechanical 2D/3D design tools such as AutoCAD and Autodesk Fusion 360. Her role also encompasses project management training. Previously, Tasmeea worked as an Adjunct Lecturer at Leading University in Sylhet, Bangladesh where she was involved in curriculum development and delivering engaging lectures on electrical and electronics courses. She has hands-on experience in teaching subjects like electrical circuits, VLSI design, digital signal processing, and microprocessors. Before her academic stint, she served as a Design Engineer at ALCOVE in Dhaka, Bangladesh where she was responsible for providing electrical and architectural drawings along with planning and executing projects. Tasmeea holds a Ph.D. in Project Management from Universiti Putra Malaysia with a perfect CGPA of 4.00/4.00. She also earned a Master of Engineering Management from the same university and an MBA in Marketing from the University of Dhaka. Her educational foundation is built on a Bachelor's Degree in Electrical and Electronics Engineering from United International University in Bangladesh. In addition to her formal education, Tasmeea has several certifications including Train the Trainer Certification from HRD Corp and Agile Project Management Certifications from Google via Coursera. She is proficient in multiple engineering software tools and programming languages including MATLAB, AutoCAD, C++, Assembly language, and Python. Fluent in both Bengali and English, Tasmeea is committed to continuous learning and professional development.

57 Courses
7 Years

Instructor

Mohammad Mehdi Lotfinejad
Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer Not Teaching

Mohammad Mehdi Lotfinejad is an accomplished Chief Data Officer with a profound expertise in data science and engineering, amassing over ten years of experience in developing data processing pipelines for enterprise insights. He is a proven leader with exceptional communication, presentation, and leadership skills, certified as an HRDF trainer with more than 15 years of experience as a computer science instructor both in academia and as a professional data science/engineering trainer in the industry. His academic credentials include a PhD in Computer Science from Universiti Malaya, Malaysia, and he holds certifications from Harvard Business School in Business Analytics. Mohammad specializes in cutting-edge technologies such as Apache Spark, MySQL, PostgreSQL, MongoDB, Snowflake, Redshift, Apache Airflow, API and Microservices, and Amazon Web Services. Currently serving as the Chief Data and Knowledge Officer at Magna.ai since February 2024, Mohammad leads the development of graph databases and data warehouses to support AI-driven law case analysis services. He architects robust API and microservice solutions to enhance system interoperability and scalability while ensuring data security and compliance with legal standards. Prior to this role, he has been contributing his expertise as a Senior Data Engineer at AXIATA Digital Advertising (ADA) since March 2020. Here, he collaborates on designing automated data pipelines using AWS RedShift and Snowflake for storing telco data and implements BI dashboards leveraging Google BigQuery. From June 2018 to February 2020, Mohammad was the Lead Senior Data Scientist Professional Trainer at The Center of Applied Data Science in Kuala Lumpur. He led teams of data scientists and engineers to design professional training programs for prominent clients like CIMB, PETRONAS, SHELL, and TNB. His earlier roles include leading big data engineering teams at RAHA in Iran where he developed large-scale analytics pipelines using Hadoop Ecosystem tools like Hive and Spark. In academia, Mohammad served as a faculty member at Payame Noor University from September 2014 to June 2018 where he supervised graduate research projects and contributed significantly to curriculum development. His tenure also includes leadership positions at Islamic Azad University where he managed departments to achieve high academic standards. With technical proficiencies spanning RDBMS like MySQL and PostgreSQL to programming languages such as Python and C++, Mohammad is adept at web design using HTML/CSS/Bootstrap alongside project management skills including Scrum Master certification. His published works include books on Object-Oriented Programming and Project Management Fundamentals along with numerous journal articles on topics ranging from solar radiation prediction models to machine learning algorithms for intrusion detection systems.

2 Students
56 Courses
18 Years

Minimum Qualification

undergraduate

Target Audience

students
entry level
engineers

Methodologies

lecture
slides
case studies
labs
group discussion

Course Reviews

review avatar
Nenad J
3 years ago
3 years ago

I was pleasantly surprised by the course I attended; I gained a great deal of knowledge, as well as several examples and case studies that would be valuable in my future job. I appreciate the instructor's willingness to teach us everything, and I am grateful to be a part of this class.

review avatar
Saravanan R
3 years ago
3 years ago

The course and material is really good. The instructor is a consummate professional and an excellent trainer who routinely receives high marks from his students. I would gladly recommend him.

review avatar
Aneel A
3 years ago
3 years ago

I will not hesitate to recommend this course to business people because it was designed for them and the instructor is extremely good.

Instructor Reviews

review avatar
Rohit R
2 years ago
2 years ago

Tasmeea was an excellent teacher. Very pleasant, willing to assist and answer concerns, and continuously asked how she could assist more. She made the course enjoyable as well as informative.

review avatar
Sam A
2 years ago
2 years ago

Thank you so much for your invaluable guidance. I really enjoyed it and appreciated how much fun you made it! I feel much more equipped to cope with difficult challenges.

review avatar
Carmen S
2 years ago
2 years ago

The training was both fascinating and beneficial. Many members of the staff commented on how useful it was. Tasmeea delivers the topic with authority, wit, and passion.

Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer
review avatar
Michael Ogheneme
12 months ago
12 months ago

Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert.

review avatar
Amin Jula
12 months ago
12 months ago

Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly.

review avatar
Kennedy Okonkwo
12 months ago
12 months ago

I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for.

Why should you attend?

Business Analytics with Excel is a transformative course designed to empower professionals with the analytical prowess needed to make data-driven decisions. Understanding the definition and difference between analytics and analysis sets the foundation for appreciating the role of business analytics in various domains and recognizing its potential challenges. Participants will learn about different types of analytics and real-world examples where they are applied. The course delves into data management, covering essential concepts such as population vs. sample, data variables, summarization techniques, central tendency measures, spread/variability, symmetry, skewness, collection methods, dictionaries, outlier treatment, and missing value imputation. Building on this knowledge, the course introduces basic statistics including probability theories, distributions, random variables, central limit theorem applications, sampling methods, confidence intervals, and hypothesis testing. A dedicated section on predictive modeling using linear regression provides hands-on experience with gains charts, Gini coefficients, heteroskedasticity issues, logistic regression models and includes a practical case study for learners to apply their skills.

What you'll learn

  • Gain proficiency in constructing confidence intervals and conducting hypothesis testing.
  • Develop skills in predictive modeling with linear regression techniques.
  • Understand the core concepts of business analytics and differentiate it from simple analysis.
  • Master measures of central tendency and variability to describe datasets accurately.
  • Grasp the fundamentals of probability and statistical distributions.
  • Apply the Central Limit Theorem for practical statistical inference.
  • Engage in practical exercises including a detailed case study to solidify your learning.
  • Learn how to manage different types of data and perform effective data summarization.

Course Syllabus

Definition
Analytics vs. Analysis
Business Analytics
Types of Analytics
Business Domains within Analytics
Challenges
Examples
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
Lunch
1 hour
Short Break
15 mins
Short Break
15 mins
Short Break
15 mins
Recap and Q&A
15 mins
End of Day 1

Course Reviews

review avatar
Nenad J
3 years ago
3 years ago

I was pleasantly surprised by the course I attended; I gained a great deal of knowledge, as well as several examples and case studies that would be valuable in my future job. I appreciate the instructor's willingness to teach us everything, and I am grateful to be a part of this class.

review avatar
Saravanan R
3 years ago
3 years ago

The course and material is really good. The instructor is a consummate professional and an excellent trainer who routinely receives high marks from his students. I would gladly recommend him.

review avatar
Aneel A
3 years ago
3 years ago

I will not hesitate to recommend this course to business people because it was designed for them and the instructor is extremely good.

Instructor Reviews

review avatar
Rohit R
2 years ago
2 years ago

Tasmeea was an excellent teacher. Very pleasant, willing to assist and answer concerns, and continuously asked how she could assist more. She made the course enjoyable as well as informative.

review avatar
Sam A
2 years ago
2 years ago

Thank you so much for your invaluable guidance. I really enjoyed it and appreciated how much fun you made it! I feel much more equipped to cope with difficult challenges.

review avatar
Carmen S
2 years ago
2 years ago

The training was both fascinating and beneficial. Many members of the staff commented on how useful it was. Tasmeea delivers the topic with authority, wit, and passion.

Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer
review avatar
Michael Ogheneme
12 months ago
12 months ago

Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert.

review avatar
Amin Jula
12 months ago
12 months ago

Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly.

review avatar
Kennedy Okonkwo
12 months ago
12 months ago

I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for.

MYR 1750

Training Provider Pricing

Material Fees: MYR 400

Pax:

MYR 2400

Features

1 day (9:00 AM - 5:00 PM)
7 modules
21 intakes
English

Subsidies

HRDC Claimable logo

Instructors

Tasmeea Rahman
Tasmeea Rahman Lecturer Teaching

Tasmeea Rahman is a highly skilled and versatile professional with a rich background in both academia and industry. Currently serving as a Freelance Corporate Trainer at Abundent in Kuala Lumpur, Malaysia, Tasmeea specializes in developing content and providing training on a wide array of subjects including Machine Learning, Data Analysis with Python, MS Excel, Power BI, Minitab, Jaspersoft, Apache Superset, TIBCO Spotfire, and various electrical and mechanical 2D/3D design tools such as AutoCAD and Autodesk Fusion 360. Her role also encompasses project management training. Previously, Tasmeea worked as an Adjunct Lecturer at Leading University in Sylhet, Bangladesh where she was involved in curriculum development and delivering engaging lectures on electrical and electronics courses. She has hands-on experience in teaching subjects like electrical circuits, VLSI design, digital signal processing, and microprocessors. Before her academic stint, she served as a Design Engineer at ALCOVE in Dhaka, Bangladesh where she was responsible for providing electrical and architectural drawings along with planning and executing projects. Tasmeea holds a Ph.D. in Project Management from Universiti Putra Malaysia with a perfect CGPA of 4.00/4.00. She also earned a Master of Engineering Management from the same university and an MBA in Marketing from the University of Dhaka. Her educational foundation is built on a Bachelor's Degree in Electrical and Electronics Engineering from United International University in Bangladesh. In addition to her formal education, Tasmeea has several certifications including Train the Trainer Certification from HRD Corp and Agile Project Management Certifications from Google via Coursera. She is proficient in multiple engineering software tools and programming languages including MATLAB, AutoCAD, C++, Assembly language, and Python. Fluent in both Bengali and English, Tasmeea is committed to continuous learning and professional development.

57 Courses
7 Years
Mohammad Mehdi Lotfinejad
Mohammad Mehdi Lotfinejad Certified Data Science Trainer and Data Engineer Not Teaching

Mohammad Mehdi Lotfinejad is an accomplished Chief Data Officer with a profound expertise in data science and engineering, amassing over ten years of experience in developing data processing pipelines for enterprise insights. He is a proven leader with exceptional communication, presentation, and leadership skills, certified as an HRDF trainer with more than 15 years of experience as a computer science instructor both in academia and as a professional data science/engineering trainer in the industry. His academic credentials include a PhD in Computer Science from Universiti Malaya, Malaysia, and he holds certifications from Harvard Business School in Business Analytics. Mohammad specializes in cutting-edge technologies such as Apache Spark, MySQL, PostgreSQL, MongoDB, Snowflake, Redshift, Apache Airflow, API and Microservices, and Amazon Web Services. Currently serving as the Chief Data and Knowledge Officer at Magna.ai since February 2024, Mohammad leads the development of graph databases and data warehouses to support AI-driven law case analysis services. He architects robust API and microservice solutions to enhance system interoperability and scalability while ensuring data security and compliance with legal standards. Prior to this role, he has been contributing his expertise as a Senior Data Engineer at AXIATA Digital Advertising (ADA) since March 2020. Here, he collaborates on designing automated data pipelines using AWS RedShift and Snowflake for storing telco data and implements BI dashboards leveraging Google BigQuery. From June 2018 to February 2020, Mohammad was the Lead Senior Data Scientist Professional Trainer at The Center of Applied Data Science in Kuala Lumpur. He led teams of data scientists and engineers to design professional training programs for prominent clients like CIMB, PETRONAS, SHELL, and TNB. His earlier roles include leading big data engineering teams at RAHA in Iran where he developed large-scale analytics pipelines using Hadoop Ecosystem tools like Hive and Spark. In academia, Mohammad served as a faculty member at Payame Noor University from September 2014 to June 2018 where he supervised graduate research projects and contributed significantly to curriculum development. His tenure also includes leadership positions at Islamic Azad University where he managed departments to achieve high academic standards. With technical proficiencies spanning RDBMS like MySQL and PostgreSQL to programming languages such as Python and C++, Mohammad is adept at web design using HTML/CSS/Bootstrap alongside project management skills including Scrum Master certification. His published works include books on Object-Oriented Programming and Project Management Fundamentals along with numerous journal articles on topics ranging from solar radiation prediction models to machine learning algorithms for intrusion detection systems.

2 Students
56 Courses
18 Years

Minimum Qualification

undergraduate

Target Audience

students
entry level
engineers

Methodologies

lecture
slides
case studies
labs
group discussion
Close menu