- About Us
- Introduction
- Srishyla Educational Trust
- G M University
- GMU- Campus
- GMU Logo, Flag and Mascot
- GMU- Anthem
- Vision, Mission, Values, and Objectives
- Leadership
- Statutory Committees
- University Documents
- Organisation Structure
- University Best Practices
- Information and Communication Technology (ICT)
- Learning Management System (LMS)
- Human Resources (HR)
- Collaboration and Cooperation
- Campus life
- Events
- Proctorial System
- Student Placements
- IQAC
- Assessment
- Careers
- Contact Us
- Home About Us
- Introduction
- Srishyla Educational Trust
- G M University
- GMU- Campus
- GMU Logo, Flag and Mascot
- GMU- Anthem
- Vision, Mission, Values, and Objectives
- Leadership
- Statutory Committees
- University Documents
- Organisation Structure
- University Best Practices
- Information and Communication Technology (ICT)
- Learning Management System (LMS)
- Human Resources (HR)
- Collaboration and Cooperation
- Campus life
- Proctorial System
- Student Placements
- Contact Us
- Careers
- Programs
- Admissions
- Academics
- Research
- Skill Development
- Con, Innov.&Entr
- Library
- Grievances
Data Analytics with MS Excel
GMUSD23
Credits: 2.00
Prerequisites : Data Analytics with MS Excel
Course Duration : 30 Hours / 12 Weeks
Start Date : 2024-04-01
End Date : 2024-06-30
Seats Remaining : 60
Aim & Summary
The aim of the "Data Analytics with MS Excel" course for students is to provide a comprehensive introduction to the principles and practices of data analytics using Microsoft Excel. This course aims to equip students with the necessary skills and knowledge to analyze, interpret, and visualize data effectively, leveraging Excel's powerful features. Throughout the course, students will work on hands-on projects and case studies, applying their newfound knowledge and skills to analyze real-world datasets. These projects will allow students to gain practical experience in data analytics and showcase their ability to derive actionable insights from data using Excel. By the end of the course, students will gain proficiency in manipulating data, performing basic and advanced analyses, and creating compelling visualizations to extract meaningful insights from various datasets. Additionally, this course aims to cultivate critical thinking and problem-solving skills in students, preparing them for data-driven decision-making in their academic and professional pursuits.| Week 1 | Introduction to Excel and Data Importing |
| Week 2 | Data Manipulation and Formulas |
| Week 3 | Exploratory Data Analysis |
| Week 4 | Advanced Data Analysis Techniques (Part 1) QUIZ 1 |
QUIZ 1 |
|
| Week 5 | Advanced Data Analysis Techniques (Part 2) |
| Week 6 | Data Visualization |
| Week 7 | Pivot Tables and Pivot Charts |
| Week 8 | Advanced Data Visualization Techniques QUIZ 2 |
QUIZ 2 |
|
| Week 9 | Real-World Applications and Case Studies (Part 1) |
| Week 10 | Real-World Applications and Case Studies (Part 2) |
| Week 11 | Project Refinement and Presentation Preparation |
| Week 12 | Project Presentations and Course Conclusion |
PROJECT REPORT |
|
Course Certification
Certificate will have your name, photograph and the score in the final exam with the breakup. It will have the logos of GMU and company handling the course.