Course Content
Chapter 1: Computer Basics and Typing Skills
This chapter introduces the fundamental concepts of computers and typing. Students will learn what a computer is, its types, essential hardware and software components, and how to manage files and folders using the Windows operating system. It also focuses on the importance of typing in both English and Hindi and provides a basic introduction to typing tools and practices. These are essential skills for any computer operator working in offices, data entry roles, or administrative jobs.
0/8
Lesson 1.1: What is a Computer? Types and Uses
Lesson 1.2: Basic Components of a Computer (Input, Output, Processing)
Lesson 1.3: Difference Between Hardware and Software
Lesson 1.4: Introduction to Operating Systems (Windows)
Lesson 1.5: File and Folder Management
Lesson 1.6: Common Keyboard Shortcuts and Their Uses
Lesson 1.7: Introduction to Typing (English and Hindi)
Lesson 1.8: Typing Tools and Daily Practice Plan
Chapter 2: Office Productivity Tools – MS Word, Excel, PowerPoint
This chapter focuses on the most widely used office software tools – Microsoft Word, Excel, and PowerPoint. These tools are essential for preparing letters, reports, tables, calculations, charts, and presentations in any office environment. By mastering these tools, students will become job-ready for roles like data entry operator, back-office assistant, and admin executive.
0/7
Lesson 2.1: Introduction to MS Word and Its Interface
Lesson 2.2: Typing and Formatting Text in MS Word
Lesson 2.3: Tables, Lists, and Page Setup in Word
Lesson 2.4: Introduction to MS Excel and Its Interface
Lesson 2.5: Entering Data and Formatting Cells in Excel
Lesson 2.6: Performing Basic Calculations and Formulas in Excel
Lesson 2.7: Creating and Formatting Charts in Excel
Chapter 3: Word Processing (Microsoft Word)
This chapter will introduce students to Microsoft Word, a word processing software used for creating, formatting, and editing documents. By the end of this chapter, learners will be able to create professional documents such as resumes, letters, certificates, and reports with proper formatting, layout, and styling. They will also learn useful tools like spell check, bullet points, headers & footers, tables, and how to save or print documents.
0/5
Lesson 3.1: Introduction to Microsoft Word and Its Interface
Lesson 3.2: Typing and Formatting Text in MS Word
Lesson 3.3: Paragraph Formatting and Page Setup
Lesson 3.4: Working with Tables, Images, and Shapes
Lesson 3.5: Saving, Printing, and Sharing Word Documents
Chapter 4: Spreadsheet (Excel) Essentials
This chapter introduces the basics of spreadsheet software like Microsoft Excel or Google Sheets. You will learn how to enter and manage data, perform calculations using formulas, and visually represent data using charts. These skills are essential for tasks like data entry, analysis, reports, and basic accounting.
0/5
Lesson 4.1: Spreadsheet Basics and Cell Operations
Lesson 4.2: Editing and Formatting Cells
Lesson 4.3: Sorting, Filtering, Autofill, and Freezing Panes
Lesson 4.4: Basic Formulas and Functions
Lesson 4.5: Creating Charts (Bar, Pie, Line)
Chapter 5: Creating Presentations (PowerPoint Basics)
This chapter teaches how to create professional-looking presentations using Microsoft PowerPoint or Google Slides. Students will learn to create slides, insert text and multimedia, apply design themes, and set up slide shows. These skills are useful for office meetings, teaching, marketing, and personal projects.
0/5
Lesson 5.1: Creating a Presentation (Template & Blank)
Lesson 5.2: Inserting Slides and Text
Lesson 5.3: Slide Manipulation and Objects
Lesson 5.4: Master Slide and Slide Show Setup
Lesson 5.5: Aesthetics and Printing Handouts
Chapter 6: Internet and Networking Basics
This chapter introduces the foundational concepts of computer networks and the internet. Students will learn what networks are, how devices connect, and how the internet works. It also covers web browsing, search engines, IP addresses, and safe downloading practices—skills essential for any modern office or online work environment.
0/5
Lesson 6.1: Basics of Networks (LAN, WAN, Topologies)
Lesson 6.2: Understanding Internet and Web Browsers
Lesson 6.3: IP Address, ISP, and Connectivity Modes
Lesson 6.4: Web Browsing and Searching
Lesson 6.5: Downloading and Printing Web Pages
Chapter 7: Digital Communication and Office Tools
This chapter explores essential tools for digital communication and day-to-day office work. Students will learn how to send professional emails, manage attachments, use digital calendars, and participate in online meetings. It also covers the use of basic office equipment like printers, scanners, and photocopiers.
0/5
Lesson 7.1: Email Basics – Creating, Sending, and Managing Email
Lesson 7.2: Email Etiquette and Safety Guidelines
Lesson 7.3: Using Calendar, Online Meetings, and Reminders
Lesson 7.4: Using Printers, Scanners, and Photocopiers
Lesson 7.5: Office Record Management (Files, Notes, Digital Tools)
Chapter 8: Workplace Readiness and Soft Skills
This chapter focuses on essential skills and practices that make a person job-ready for any office environment. Alongside computer knowledge, employers also expect communication skills, professional behavior, teamwork, time management, and interview preparation from a computer operator or office assistant. This chapter builds those soft skills to ensure overall employability.
0/10
Lesson 8.1: Office Etiquette and Professional Behaviour
Lesson 8.2: Communication Skills (Verbal and Written)
Lesson 8.3: Time Management and Teamwork
Lesson 8.4: Office Dress Code and Etiquette
Lesson 8.5: Interview Skills and Job Readiness
Lesson 8.6: Freelancing and Online Job Platforms
Lesson 8.7: Creating an Impressive Resume and Cover Letter
Lesson 8.8: Interview Preparation and Workplace Etiquette
Lesson 8.9: Freelancing and Work from Home Opportunities
Career Advice
Final Test – Computer Operator & Office Assistant
This is the final quiz of the course, designed to test everything you’ve learned.
0/1
Final Assessment & Certificate Submission
Computer Operator and Office Assistant – Complete Course (Job Ready Program)

Lesson 2.4: Introduction to MS Excel and Its Interface

🔹 What is Microsoft Excel?

Microsoft Excel is a spreadsheet software used for organizing, analyzing, and storing data in tabular form. It is widely used in offices for data entry, financial records, calculations, and generating reports.

🔸 Excel Window Components:

Part Description
Workbook A file in Excel. It contains one or more worksheets.
Worksheet A single spreadsheet page consisting of rows and columns.
Cell The intersection of a row and column (e.g., A1, B3).
Formula Bar Shows the contents or formula in the selected cell.
Ribbon Contains all the tools (Home, Insert, Page Layout, etc.).
Sheet Tabs Located at the bottom, used to switch between worksheets.
Rows and Columns Columns: A, B, C…; Rows: 1, 2, 3…

🔹 Uses of Excel in Office Work:

  • Data Entry & Storage

  • Daily Work Reports

  • Salary Sheets

  • Inventory Management

  • Attendance Registers

  • Budget Calculations

📝 Practice Task:

  1. Open Excel and explore different tabs: Home, Insert, Page Layout, etc.

  2. Identify the formula bar and ribbon.

  3. Rename the worksheet from Sheet1 to “Data Sheet”.

  4. Move between cells using arrow keys and note the cell address.

Previous
Next
Scroll to Top