
Fee – NRs. 2200/-
Rules & Regulations:
- क्लासमा सहभागी हुनका लागि फी तिर्नु अनिवार्य छ।
- २२ घण्टाको यो क्लासमा १८ घण्टा लाईभ क्लास हुनेछ र बाँकी ४ घण्टा रेकर्डेड सामग्री उपलब्ध हुनेछ।
- १८ घण्टाको लाईभ क्लासमा ७ घण्टा क्लासवर्कका लागि छुट्याइएको छ, जहाँ विद्यार्थीहरूले आफ्नै स्थानमा बसेर क्लासवर्क गर्नु पर्नेछ।
- केवल नियमित रूपमा क्लासमा उपस्थित हुने विद्यार्थीहरूलाई मात्र लाईभ क्लासको रेकर्ड प्रदान गरिनेछ।
- पुर्व जानकारी बिना क्लासमा अनुपस्थित हुने विद्यार्थीलाई लाईभ क्लासको रेकर्ड उपलब्ध गराइने छैन।
- क्लासवर्क गराइएको दिनको रेकर्ड उपलब्ध हुने छैन।
थप नियमहरू:
- समयमै सहभागीता अनिवार्य: प्रत्येक लाईभ क्लास निर्धारित समयमै सुरु हुनेछ। विद्यार्थीहरूले समयमै उपस्थित हुनुपर्नेछ। 25 मिनेटभन्दा बढी ढिला आउने विद्यार्थीलाई अनुपस्थित मान्न सकिन्छ।
- Classwork को मापदण्ड: क्लासवर्क समयमै पूरा गरेर बुझाउनु अनिवार्य छ। समयसीमाभित्र बुझाइएको क्लासवर्क मात्र मूल्यांकन गरिनेछ।
- Communication अनिवार्य: कुनै पनि समस्या, जस्तै क्लासमा सहभागी हुन नसक्ने वा क्लासवर्कमा समस्या भएमा, अग्रीम रूपमा जानकारी दिनुपर्नेछ।
- Recorded सामग्रीको प्रयोग: रेकर्डेड सामग्री व्यक्तिगत अध्ययनका लागि मात्र हो। यसलाई कसैसँग साझेदारी गर्न वा पुन: सार्वजनिक रूपमा प्रयोग गर्न पूर्ण रूपमा निषेध छ।
- Discipline: क्लासको समयमा अनावश्यक गतिविधि, जस्तै माइक अन गरेर अन्य व्यक्ति डिस्टर्ब गर्ने वा च्याटमा अनावश्यक कुरा गर्ने, स्वीकार्य हुने छैन।
- Final Certification: अन्तिम प्रमाणपत्र प्राप्त गर्न कम्तीमा ८०% लाईभ क्लासमा उपस्थिति, क्लासवर्कको १००% सम्पन्नता, र अन्तिम मूल्यांकन उत्तीर्ण गर्नुपर्नेछ।
के तपाईं Class Join हुन चाहनु हुन्छ ? Registration Link मा touch गरी form fill गरिदिनुहोस ।
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.
The Advanced Excel Group Class is a hands-on training program tailored to help professionals and students master the advanced functionalities of Microsoft Excel. This course focuses on practical applications of Excel to solve real-world problems, improve productivity, and create professional-level reports and dashboards.
Course Outline:
Day | Contents | Class Type | Hour |
---|---|---|---|
1 | Getting to start with Microsoft Excel Introduction to Excel and its interface. Overview of Excel’s key features and tools. Customizing the Excel ribbon and quick access toolbar. Understanding workbooks, worksheets, and cell navigation. | Recorded | 1 Hour |
2 | Auto Fill, Text and Number Formatting, Invoice Designing Using Auto Fill for repetitive data entry and series creation. Applying text and number formatting for professional data presentation. A step-by-step guide to creating an invoice template using Excel. Formatting tables for better readability. | Live | 1 Hour |
3 | Cell Reference, Ledger Account with Excel Table Explanation of absolute, relative, and mixed cell references. Using cell references effectively in formulas. Creating and managing ledger accounts with Excel Tables. Overview of structured references in Excel Tables. | Live | 1 Hour |
4 | Live Classwork Hands-on practice with the concepts from Day 1 – 3. | Live | 1 Hour |
5 | Home Tab Explain, Paste Special, Conditional Formatting, etc. Detailed explanation of the Home tab and its features. Using Paste Special for advanced copying options (e.g., values, formats, operations). Applying Conditional Formatting to highlight data patterns and trends. Introduction to sorting and filtering data. | Live | 1 Hour |
6 | Classwork Hands-on practice with the concepts from Day 5. Real-world examples of using Conditional Formatting and Paste Special. | Live | 1 Hour |
7 | Data Summarizing Functions Introduction to data summarization with functions like SUM, AVERAGE, COUNT, MIN, MAX, SUBTOTAL, AGGREGATE, etc. Using conditional functions such as SUMIF, SUMIFS AVERAGEIF, COUNTIF, and COUNTIFS. Real-world examples for summarizing data sets effectively. | Live | 1 Hour |
8 | Classwork Practice exercises for summarizing data. Scenario-based tasks for data Summarizing functions. | Live | 1 Hour |
9 | Setting Before Print Configuring print settings, including page layout and scaling options. Setting up print areas and titles for large datasets. Adding headers, footers, and page numbers for professional printouts. Previewing and troubleshooting print layouts. | Recorded | 1 Hour |
10 | Logical Functions (Nested IF, IFS, SWITCH) Advanced use of logical functions such as IF, AND, OR, and nested IF. Real-world use cases for applying these functions. | Live | 1 Hour |
11 | Classwork_Nested If Practical application of nested IF functions. Creating multi-condition logical statements. Troubleshooting common errors in nested formulas. | Live | 1 Hour |
12 | Lookup & Reference Functions Understanding lookup functions such as VLOOKUP, HLOOKUP, XLOOKUP and INDEX. Using MATCH for advanced referencing. Combining INDEX and MATCH for flexible lookups. | Live | 1 Hour |
13 | Classwork Exercises on lookup and reference functions. Solving real-world lookup problems, including dynamic lookups. | Live | 1 Hour |
14 | Define Name, Dynamic Range & Validation Rules Defining named ranges for easier formula references. Creating dynamic ranges for datasets that change over time. Setting up data validation rules to restrict or guide input values. | Recorded | 1 Hour |
15 | Advanced Lookup and Dynamic Links Advanced techniques for VLOOKUP, UNIQUE, FILTER, INDIRECT, SORT, and HYPERLINK. Linking data dynamically across multiple workbooks or sheets. Troubleshooting errors in linked files. | Live | 1 Hour |
16 | Date and Time Functions (Total 26 Functions) Working with date and time functions like DATEDIF, WORKDAY.INTL, NETWORKDAYS.INTL, DAY, YEAR, MONTH, DAY, etc. Calculating differences between dates and times. Formatting and analyzing date and time data. | Live | 1 Hour |
17 | Backstage View & File Security, Text Functions (Total 23 Functions) Navigating the Backstage view for file management. Setting file-level security, including password protection. Using text functions like REPLACE, SUBSTITUTE, LEFT, RIGHT, MID, CLEAN, SEARCH, and TRIM. | Live | 1 Hour |
18 | Analyze Data with PivotTable Creating and customizing PivotTables for data analysis. Adding calculated fields and items. Sorting, filtering, and grouping data in PivotTables. Introduction to PivotCharts for data visualization. | Live | 1 Hour |
19 | Classwork_Reports with Pivot Table) Hands-on practice with PivotTables to create summary reports. Generating insights by grouping, filtering, and sorting data. Using calculated fields and items to perform advanced calculations. Creating PivotTable-based reports tailored for business scenarios. | Live | 1 Hour |
20 | Data visualization with Charts, Pivot Charts and Dashboard Designing a data dashboard in Excel. Combining charts, slicers, and PivotTables for interactivity. Step-by-step creation of a basic dashboard for visual reporting. Formatting tips for a clean and professional look. | Live | 1 Hour |
21 | Dashboard Using Function and Options) Leveraging advanced Excel functions (e.g., INDEX, MATCH, INDIRECT) in dashboards. Applying options like conditional formatting and data validation for interactivity. Creating fully functional dashboards with real-world datasets. Finalizing and publishing the dashboard for presentations. | Live | 1 Hour |
22 | Excel Macro & VBA Concept Class Introduction to Macros and their applications in Excel automation. Recording, editing, and running simple Macros. Overview of VBA (Visual Basic for Applications) concepts and interface. Writing basic VBA scripts for automating repetitive tasks. Examples of automating data entry, formatting, and report generation. Understanding the scope and security of Macros and enabling them safely. | Recorded | 1 Hour |
Platform:
- The Class will be live via Google Meet
Requirements:
- A stable internet connection and a computer device (laptop, desktop, mobile) with Excel are installed.
- Use headphones for better audio quality.
Interaction and Engagement:
Group Size:
- A single online live class group will consist of a minimum of 5 students and a maximum of 20 students.
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 regular information 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. 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!
About “Advanced Excel Group Class”
Master Advanced Excel Skills with Our Group Class
Unlock the full potential of Microsoft Excel with our Advanced Excel Group Class, designed for professionals, students, and business enthusiasts. This comprehensive program offers hands-on training in key Excel functionalities, including advanced formulas, data analysis techniques, dashboards, and automation using Macros and VBA.
Why Join Us?
- Expert Instructors: Learn from experienced Excel professionals.
- Interactive Classes: Group discussions and live practice sessions.
- Real-World Applications: Solve practical problems and case studies.
- Comprehensive Resources: Access to course materials, templates, and tools.
Transform the way you work with data. Enroll today to gain skills that will boost your productivity and career prospects!
Comments are closed.