The Smart Computer Skills Course by Rashi Sharma is designed for beginners and students who want to gain practical computer proficiency. This course covers basic computer concepts, MS Office applications, internet usage, email communication, and cybersecurity awareness, ensuring learners can confidently use technology for academic, professional, and personal purposes.

The course combines theory and hands-on exercises, with practical examples for each module to strengthen understanding and real-world application.

What Students Will Learn

Module 1: Introduction to Computer (6 Hours)

• Computer kya hai?

• Hardware vs Software

• Input / Output devices

• CPU, RAM, Hard Disk

• Types of Computers

• Practical: Computer on/off, desktop screen understanding

Module 2: Operating System – Windows Basics (8 Hours)

• Windows interface

• File & Folder banana

• Copy, Paste, Delete

• Control Panel basics

• Installing / Uninstalling software

• Practical: Folder structure banana

Module 3: MS Word (10 Hours)

• Typing practice (English + Hindi)

• Formatting (Bold, Italic, Font size)

• Page setup

• Table banana

• Resume banana

• Letter writing

🎯 Practical: Resume + Application letter

Module 4: MS Excel (12 Hours)

• Excel interface

• Data entry

• Basic formulas (Sum, Average, Count)

• Percentage calculation

• Simple charts

🎯 Practical: Marksheet banana

Module 5: MS PowerPoint (6 Hours)

• Slide banana

• Design apply karna

• Animation

• Simple presentation banana

🎯 Practical: 5-slide presentation

Module 6: Internet & Email (8 Hours)

• Browser use karna

• Google search

• Online form filling

• Email ID banana

• Email send/attach file

Module 7: Basic Cyber Security (4 Hours)

• Password safety

• OTP fraud awareness

• Safe browsing

• Social media safety

Teaching Method

This online course is hands-on and interactive, including:

• Live demonstration of all modules

• Practical exercises for MS Office and internet applications

• Step-by-step guidance for real-world usage

• Continuous support for doubts and queries

The focus is on practical skills acquisition, enabling students to immediately apply what they learn in school, college, or workplace environments.

Why This Tutor

Rashi Sharma brings experience in teaching computer fundamentals and MS Office applications, ensuring students gain both theoretical knowledge and practical expertise. Her teaching style emphasizes clarity, practice-based learning, and skill application, making learners confident in their computer abilities.

Benefits / Outcomes

After completing this course, students will be able to:

• Use computers efficiently for academic and professional purposes

• Prepare documents, spreadsheets, and presentations using MS Office

• Navigate the internet and manage email communication confidently

• Apply basic cybersecurity practices for safe online use

• Enhance digital literacy and overall computer proficiency

This course is perfect for beginners, school/college students, and professionals seeking practical computer skills.

The Advanced Excel Course by Rashi Sharma is designed for students, professionals, and data enthusiasts who want to master Microsoft Excel, data analysis, and MIS reporting. This course focuses on advanced formulas, data management, pivot tables, dashboards, and automation, giving learners the practical skills needed to handle real-world data efficiently.

The course is fully online, combining theory, hands-on exercises, and practical projects to ensure students gain confidence in managing, analyzing, and reporting data effectively.

What Students Will Learn

Module 1: Excel Revision & Fundamentals (4 Hours)

• Excel Interface & Shortcuts

• Data Formatting

• Basic Formulas Revision (SUM, AVERAGE, COUNT)

• Relative & Absolute Cell Reference

Module 2: Advanced Formulas & Functions (12 Hours)

• IF, Nested IF

• VLOOKUP & HLOOKUP

• XLOOKUP (Latest Version)

• INDEX & MATCH

• COUNTIF, SUMIF, AVERAGEIF

• TEXT Functions (LEFT, RIGHT, MID, LEN)

• DATE & TIME Functions

• Logical Functions

🎯 Practical: Salary Sheet & Marksheet Automation

Module 3: Data Management Tools (8 Hours)

• Data Validation

• Conditional Formatting

• Remove Duplicates

• Text to Columns

• Sorting & Filtering (Advanced Filter)

Module 4: Pivot Table & Data Analysis (8 Hours)

• Creating Pivot Tables

• Pivot Charts

• Slicers

• Grouping Data

• Dashboard Creation

🎯 Practical: Sales Report Dashboard

Module 5: MIS Reporting (6 Hours)

• Monthly Report Format

• Data Cleaning Techniques

• Chart Creation

• Dynamic Reports

Module 6: Excel Automation & Protection (4 Hours)

• Protect Sheet / Workbook

• Basic Macros Introduction

• Recording Macro

• Print Setup & Page Layout

Teaching Method

This online course is hands-on and project-based, with live guidance from the tutor:

• Step-by-step demonstrations of Excel features

• Real-world exercises and practical projects

• Interactive problem-solving and doubt-clearing sessions

• Focus on professional data handling and reporting skills

Why This Tutor

Rashi Sharma specializes in Excel training for professional and academic applications. She emphasizes practical learning, clarity, and project-based teaching, ensuring students are ready to create dashboards, analyze data, and prepare MIS reports confidently.

Course Outcomes:

After completing this course, students will be able to:
✔ Create professional MIS reports
✔ Handle large data efficiently
✔ Prepare dashboards
✔ Use advanced formulas confidently