Fee - NRs. 2400/- Only NRs. 1200/- Registration Link 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 Time Day 1 Introduction to Data Cleaning, Clean data using Excel Functions, Formulas, and Options 1 Hour Day 2 Introduction to Power Query for Data TransformationImporting and connecting data from various sources 1 Hour Day 3 Transforming and cleaning data using Power Query 1 Hour Day 4 Combining and merging data tables 1 Hour Day 5 Data Modeling, Power Pivot, Pivot Table, Charts, and Pivot Charts 1 Hour Day 6 Classwork 1 Hour Day 7 Dashboard - 1 1 Hour Day 8 Introduction to Power BI and its components 1 Hour Day 9 Implementing data visualizations (charts, graphs, tables) in Power BICreating interactive dashboards and reports 1 Hour Day 10 Dashboard - 3 1 Hour Day 11 Dashboard - 4 1 Hour Day 12 Classwork 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. Registration Link
