
Fee – NRs. 1000/-
के तपाईं Class Join हुन चाहनु हुन्छ ? Registration Link मा touch गरी form fill गरिदिनुहोस ।
Course Overview:
This course is designed for individuals who are new to Microsoft Excel and want to gain foundational skills to confidently navigate and utilize the program. Whether you’re a student, a professional, or someone looking to improve personal productivity, this course will equip you with the essential tools and techniques to get started with Excel.
Course Outline:
Day | Contents | Class Type | Hour |
---|---|---|---|
1 | Introduction to Excel Understanding the Excel interface (ribbons, menus, and toolbars). Creating, saving, and opening workbooks. Navigating between cells, rows, and columns. Basic Excel terminology (workbook, worksheet, cell, range). | Live | 1 Hour |
2 | Entering and Editing Data Entering data into cells (text, numbers, and dates). Editing and clearing data in cells. Using Undo, Redo, and Autofill options. Keyboard shortcuts for navigation. | Live | 1 Hour |
3 | Formatting Basics Formatting cells (font, size, bold, italics, and colors). Adjusting column width and row height. Applying number formats (currency, percentage, date). Using the Format Painter tool. | Live | 1 Hour |
4 | Managing Worksheets Adding, renaming, and deleting worksheets. Moving and copying worksheets. Hiding and unhiding sheets. Freezing panes and splitting windows. | Live | 1 Hour |
5 | Introduction to Formulas Understanding formulas and functions. Performing basic calculations (addition, subtraction, multiplication, division). Introduction to cell references (relative and absolute). Troubleshooting formula errors. | Live | 1 Hour |
6 | Working with Functions Using basic functions: SUM, AVERAGE, MIN, MAX, COUNT. Understanding AutoSum and Quick Analysis tools. Combining multiple functions in one formula. | Live | 1 Hour |
7 | Organizing Data Sorting data (ascending, descending, custom sort). Filtering data using AutoFilter. Introduction to tables and table styles. Removing duplicates in datasets. | Live | 1 Hour |
8 | Formatting Worksheets Applying borders and shading. Merging and centering cells. Adding headers and footers. Setting up page layouts for printing (margins, orientation, scaling). | Live | 1 Hour |
9 | Creating Charts and Visuals Introduction to charts (bar, line, pie). Creating a chart step-by-step. Customizing chart elements (titles, legends, data labels). Using conditional formatting to highlight data. | Live | 1 Hour |
10 | Introduction to data validation (drop-down lists). Using the Text-to-Columns feature. Basic data analysis with Quick Analysis. Understanding simple trends with sparklines. | Live | 1 Hour |
11 | Tips and Tricks for Beginners Common keyboard shortcuts. Using Find and Replace. Grouping and ungrouping rows/columns. Protecting sheets and locking cells. | Live | 1 Hour |
12 | Practical Application and Wrap-Up Completing a mini project (e.g., a personal budget, attendance tracker). Reviewing key topics covered in the course. Best practices for Excel beginners. Q&A and course feedback session. | Live | 1 Hour |
Course Objectives for Excel for Beginners:
By the end of this course, participants will be able to:
- Understand the basics of the Excel interface and its core functionalities.
- Enter, format, and organize data efficiently in worksheets.
- Perform basic calculations using formulas and functions.
- Create, customize, and interpret simple charts and graphs.
- Manage and print worksheets professionally.
Who Should Enroll Excel for Beginners?
This course is ideal for:
- Complete beginners with no prior Excel experience.
- Students and professionals looking to learn the basics of Excel.
- Anyone who wants to improve their data organization and analysis skills.
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 10 students and a maximum of 30 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:
The Excel for Beginners course is the perfect starting point for anyone looking to build a solid foundation in Microsoft Excel. By mastering the basics, you’ll gain the skills to organize, analyze, and present data effectively. This course opens the door to greater productivity, better decision-making, and enhanced confidence in using Excel for both personal and professional tasks. Join us to kickstart your Excel journey and unlock the power of spreadsheets!
About “Excel for Beginners”
Excel for Beginners is an introductory course designed to help individuals learn the fundamentals of Microsoft Excel. It covers essential skills like navigating the interface, entering and organizing data, applying basic formulas and functions, formatting worksheets, and creating simple charts. This course is perfect for students, professionals, and anyone looking to improve their productivity with Excel. Whether you’re managing personal data or preparing for a professional task, “Excel for Beginners” provides the foundational knowledge you need to get started confidently.
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.