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.6: Performing Basic Calculations and Formulas in Excel

🔹 What is a Formula?

A formula in Excel is an equation that performs calculations on data in your worksheet.

All formulas in Excel start with an equal sign (=).

🔸 Basic Arithmetic Formulas:

Operation Formula Example Meaning
Addition =A1 + B1 Adds values in A1 and B1
Subtraction =A1 - B1 Subtracts B1 from A1
Multiplication =A1 * B1 Multiplies A1 by B1
Division =A1 / B1 Divides A1 by B1

🔹 Basic Functions:

Excel provides ready-made formulas called functions:

Function Syntax Description
SUM =SUM(A1:A5) Adds values from A1 to A5
AVERAGE =AVERAGE(A1:A5) Calculates average
MAX =MAX(A1:A5) Finds the largest number
MIN =MIN(A1:A5) Finds the smallest number

🛠 Formula Bar:

When you enter a formula in a cell, the result appears in the cell, and the actual formula is shown in the formula bar.

📝 Practice Task:

  1. Create a table of 5 products with price and quantity.

  2. In a third column, calculate Total = Price × Quantity using a formula.

  3. Use =SUM() to calculate the grand total of all products.

  4. Try using =AVERAGE() to find the average price.

Previous
Next
Scroll to Top