Fee – NRs. 2000/-

के तपाईं Class Join हुन चाहनु हुन्छ ? Registration Link मा touch गरी form fill गरिदिनुहोस ।

Registration Link

Course Title:

“Microsoft Excel Advanced Online Group Class”

Course Overview:

This course is designed to equip students with the essential skills and knowledge needed to excel in Microsoft Excel. Whether you’re a beginner or looking to enhance your existing skills, this class will cover a wide range of topics to make you proficient in spreadsheet management, data analysis, and reporting.

Course Outline:

Day	Contents	Class Type	Hour
1	Getting to start with Microsoft Excel Screen Elements and its features Customization of user Interface	Recorded	1 Hour
2	Formula & Functions Concept and Operators Formatting tools and their proper use most popular and useful functions with Examples Download and Install add-ins for number conversions.	Live	1 Hour
3	Project (Data Entry Format & Inventory Management) Some useful Functions Cell References with Examples	Live	1 Hour
4	Classwork	Live	1 Hour
5	Home tab explains, Excel Table and Table Design Tools Paste Special, Conditional Formatting, Find & Select	Live	1 Hour
6	Logical & Information Functions If, Nested if and Ifs Function with lots of Examples	Live	1 Hour
7	Classwork	Live	1 Hour
8	Insert Tab and Page Layout tab All Setting Before Print	Recorded	1 Hour
9	Data Summarizing Functions with Examples Sort and Filter, Advanced Filter	Live	1 Hour
10	Classwork	Live	1 Hour
11	Lookup & Reference Functions (Part -1) With Examples	Live	1 Hour
12	Classwork	Live	1 Hour
13	Dynamic Name Range Data Validation, Error handling Drop-down list, dependable & searchable Drop-down list.	Recorded	1 Hour
14	Advanced Lookup and dynamic links (Project Work)	Live	1 Hour
15	Analyze data with PivotTable	Live	1 Hour
16	Classwork Reports with pivot table	Live	1 Hour
17	Data Modelling with Power Pivot (Report with Multiple Table)	Live	1 Hour
18	Date & Time Functions (All) With Examples	Live	1 Hour
19	Backstage View, File Security, Text Functions with Examples	Live	1 Hour
20	Data visualization with Charts, Pivot Charts and Dashboard	Live	1 Hour
21	Elements and Controls for Interactive Dashboard	Live	1 Hour
22	Macro & VBA Concept Class	Recorded	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.
• 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:

Class Join Link           : The link will be provided via email

Instructor:

Name   : Sanjay K. Shrestha

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:

Join us on a journey to master Microsoft Excel and enhance your spreadsheet skills. Whether you’re a student, professional, or someone looking to boost your Excel proficiency, this class is tailored for you. Don’t miss out on this opportunity to become an Excel expert!