Data Analyst with Excel Series: Data Project Management with Excel

This course provides a comprehensive exploration of project management and quality control management. Through a structured curriculum, you will gain a deep understanding of the fundamental concepts, components, and tools used in both fields. Whether you are new to project management or seeking to enhance your quality control skills, this course equips you with the knowledge and skills needed for success in diverse industries.

Project Management Essentials:

The course begins by delving into the world of project management. You will learn what project management entails, including its various phases such as initiation, planning, execution, monitoring, and closure. Understanding these stages is crucial for effective project management, as it ensures that projects are delivered on time, within budget, and meet or exceed quality expectations.

Quality Control Management:

Quality control is integral to ensuring the products and services your organization delivers meet or exceed customer expectations. In the quality control management segment of the course, you'll delve into the core principles and components of quality control. You'll discover how quality control management plays a pivotal role in maintaining and improving product and service quality.

Tools for Project and Quality Control Management:

To be successful in both project and quality control management, you need the right set of tools at your disposal. This course provides a comprehensive overview of the tools commonly used in these fields. You'll become proficient in utilizing tools such as Gantt charts, Work Breakdown Structure, RACI matrices, check sheets, and more.

Upon completion of this course, learners will be able to:

1. Understand the core principles of project management, including project initiation, planning, execution, monitoring, and closure.
2. Identify and analyze the key components of quality control management and its significance in ensuring product and service quality.
3. Familiarize yourself with a range of tools commonly used in project and quality control management, enabling effective decision-making.
4. Develop proficiency in utilizing planning and milestone techniques such as Gantt charts, Work Breakdown Structure, RACI, and matrices for project success.
5. Master process flow analysis and monitoring tools like Burndown charts, PERT charts, and critical path analysis to optimize project performance.

1. Entry-level professionals seeking to understand project management and quality control fundamentals.
2. Mid-level managers looking to enhance their skills and improve project outcomes.
3. Quality assurance professionals aiming to deepen their knowledge of quality control techniques.
4. Team leaders interested in optimizing project planning and monitoring.
5. Anyone in a role that involves project management or quality control responsibilities.

Dwight graduated with a degree in Biotechnology (from NUS in 2001), Advanced diploma in Pharmaceutical management (from MDIS in 2007) and Masters in Education (from NTU in 2013). In 2014, Dwight ventured into Data Analytics and Database Management and picked up Statistics/Machine Learning, Big Data analytics, text mining & social media analytics and web applications. His other expertise includes data science programming languages such as R and Python. He is also deeply passionate in deep learning using sequential models and sequence to sequence models using Keras and h2oAI machine & deep learning platforms and libraries. He is also a Senior Data Analyst, where he performs data analytics and create predictive models using healthcare data.