Fee – NRs. 2400/- Only NRs. 1200/-
Course Title:
“Excel Data Cleaning & Visualization Class”
Course Overview:
This course is designed to equip participants with the skills needed to clean and visualize data effectively using Microsoft Excel, Power Query, and Power BI. Participants will gain hands-on experience in data cleaning techniques, transforming raw data into meaningful insights, and creating compelling visualizations for better decision-making.
Course Outline:
| Day | Description | Class Type | Time |
|---|---|---|---|
| Day 1 | Introduction to Data Cleaning, Clean data using Excel Functions, Formulas, and Options | Recorded | 1 Hour |
| Day 2 | Introduction to Power Query for Data Transformation Importing and connecting data from various sources | Live | 1 Hour |
| Day 3 | Transforming and cleaning data using Power Query | Live | 1 Hour |
| Day 4 | Combining and merging data tables | Live | 1 Hour |
| Day 5 | Data Modeling, Power Pivot, Pivot Table, Charts, and Pivot Charts | Live | 1 Hour |
| Day 6 | Classwork | Live | 1 Hour |
| Day 7 | Excel Dashboard – 1 | Recorded | 1 Hour |
| Day 8 | Excel Dashboard – 2 | Recorded | 1 Hour |
| Day 9 | Introduction to Power BI and its components | Live | 1 Hour |
| Day 10 | Implementing data visualizations (charts, graphs, tables) in Power BI Creating interactive dashboards and reports | Live | 1 Hour |
| Day 11 | DAX Functions with Dashboard – Part 1 | Live | 1 Hour |
| Day 12 | DAX Functions with Dashboard – Part 2 | Live | 1 Hour |
| Day 13 | Classwork | Live | 1 Hour |
| Day 14 | Dashboard | Live | 1 Hour |
Platform:
The Class will be live via Google Meet
Requirements:
- Stable internet connection and a computer device (Laptop, Desktop, Mobile) with Excel installed.
- Basic familiarity with Microsoft Excel
- Access to Microsoft Excel (2016 or later)
- Access to Power BI Desktop (free download from Microsoft)
- Use headphones for better audio quality.
Interaction and Engagement:
Group Size:
Less than 100 students will be in one live class
Q&A Sessions:
Participate students can ask questions during the class.
Assessment and Feedback:
- Every day we will provide one assignment for homework.
- We will receive feedback from students to improve our course structure, contents, and delivery for future classes.
Help and Support:
- Sessions will be recorded for review in case of missed classes.
- We will provide guidelines for troubleshooting common technical issues.
- After completing the course, the instructor will be ready to help with daily life Excel problems.
- We will provide information regularly about any updates, additional resources, or changes to the schedule.
Registration:
Registration Link : The link will be provided via email
Instructor:
Name : Sanjay Kumar Shrestha (Known as Excel with me Nepal)
Experience:
For the past 12 years, I have had the privilege of sharing my knowledge with others. I find immense joy in teaching and empowering individuals to navigate the world of Excel with confidence. My training sessions are designed to cater to all skill levels, from beginners looking to grasp the basics to advanced users seeking to enhance their proficiency.
Conclusion:
Participants will leave the course with a solid understanding of data cleaning techniques in Excel, advanced Excel functions, and the ability to transform and visualize data using Power Query and Power BI. They will be well-equipped to handle real-world data challenges and present insights through compelling visualizations.
Comments are closed.