Best Seller Icon Bestseller

CERTIFICATE In BASIC COMPUTER(M-BC-4932)

  • Last updated Nov, 2025
  • Certified Course
₹3,800 ₹4,500
  • Duration3 Months
  • Enrolled0
  • Lectures75
  • Videos0
  • Notes0
  • CertificateYes

What you'll learn

Course Description

The Basic Computer Course with Advanced Excel (EIT Skills) is a beginner-friendly, job-focused program covering Computer Basics, MS Office, Internet skills, Typing, and Advanced Excel with 25 formulas. Through daily practical training, students learn documentation, presentations, data entry, email use, reports, invoices, and salary sheets. The course builds confidence and prepares learners for office, admin, and data-entry jobs.


Who This Course Is For

  • Students who want to build a strong computer foundation
  • Job seekers applying for office, admin, and data-entry roles
  • Beginners who have never used a computer before
  • Working professionals who want to improve Excel and documentation skills
  • Business owners who want to manage accounts, data, and reports
  • Housewives or career restarters looking to gain digital confidence
  • Anyone preparing for government or private-sector jobs requiring computer knowledge


Why Choose This Course?

  • Complete beginner-to-advanced coverage
  • Daily practical learning (not just theory)
  • Includes 25 essential Advanced Excel formulas
  • Covers MS Word, Excel, PowerPoint, Internet, and Typing
  • Real office projects: resumes, invoices, presentations, salary sheets
  • Module tests + final practical + viva for certification
  • Improves typing accuracy and speed
  • Includes cyber safety and online productivity tools
  • Bonus practice sessions for revision and mastery
  • Industry-relevant training suitable for office and admin jobs



Show More

Course Syllabus

Module 1: Computer Fundamentals + Typing

• Day 1: Introduction to Computer, Features, Types, Parts of Computer

• Day 2: Booting Process, Input-Output Devices, Computer Generations

• Day 3: Hardware vs Software, Operating Systems (DOS vs Windows)

• Day 4: Storage Devices – HDD, SSD, USB, DVD, Cloud

• Day 5: Practice + Test on Basics

• Day 6: Typing Basics (English Typing Software Introduction)

• Day 7: Home Row Key Practice

• Day 8: Speed Typing Drill + Shortcuts (CTRL, ALT usage)

• Day 9: Practice + Typing Test 1

• Day 10: Revision + Basic Computer Test


Module 2: MS Word (Documentation)

• Day 11: MS Word Interface + Page Setup

• Day 12: Text Formatting, Paragraph Alignment, Bullets/Numbering

• Day 13: Tables, Borders, Shading, Page Borders

• Day 14: Insert – Pictures, Shapes, WordArt, Header/Footer

• Day 15: Mail Merge (Letters/Certificates)

• Day 16: Practice Sheet 1

• Day 17: Practice Sheet 2

• Day 18: Word Module Test


Module 3: MS PowerPoint (Presentations)

• Day 19: Introduction to PowerPoint Interface

• Day 20: Slide Layouts, Design Templates, Transitions

• Day 21: Insert Media: Images, Audio, Video, SmartArt

• Day 22: Animations + Practice Slides

• Day 23: Create a Presentation Project

• Day 24: PowerPoint Practice + Test


Module 4: Internet & Digital Skills

• Day 25: Internet, WWW, Browsers, Search Engines

• Day 26: Email Creation, Sending Attachments

• Day 27: Google Tools – Drive, Docs, Forms (Intro)

• Day 28: Cyber Safety, Online Payments, Cloud Storage

• Day 29: Practice Day

• Day 30: Internet Module Test


Module 5: MS Excel Basics

• Day 31: Excel Interface, Rows/Columns, Data Entry

• Day 32: Cell Formatting, Number/Date/Time Formats

• Day 33: Formulas vs Functions, AutoSum

• Day 34: Practice Sheet 1 + Formatting

• Day 35: Basic Excel Test


Module 6: Advanced Excel + 25 Formulas

• Day 36: Relative vs Absolute Cell References

• Day 37: Formula 1-5: SUM(), AVERAGE(), MIN(), MAX(), COUNT(), ROUND(), PRODUCT(), RANK()

• Day 38: Formula 6-10: SUMIF(), TRANSPOSE(), IF(), AND(), OR(), NOT(), IFERROR()

• Day 39: Formula 11-15: VLOOKUP(), HLOOKUP(), pivot table & chart

• Day 40: Practice Day: Lookup Formulas

• Day 41: Formula 16-20: LEN(), TRIM(), CONCAT(), TEXT(), LEFT()/RIGHT()

• Day 42: Formula 21-25: NOW(), TODAY(), DATEDIF(), ROUND(), INT()

• Day 43: Sorting, Filtering, Data Validation, data consolidation

• Day 44: Charts & Graphs, Salary Sheet

• Day 45: Conditional Formatting, Attendance sheet

• Day 46: Practice Sheet 1

• Day 47: Practice Sheet 2

• Day 48: Excel Practical Test – Formulas

• Day 49: Excel Test + Feedback


Module 7: Final Projects & Assessments

• Day 50: Mini Project – Typing Test + Formatting

• Day 51: Mini Project – Resume in MS Word

• Day 52: Mini Project – Presentation (Topic-based)

• Day 53: Mini Project – Excel Invoice

• Day 54: Practice & Doubt Clearance

• Day 55: Mock Test 1 (Full Syllabus)

• Day 56: Feedback & Corrections


Final Assessment + Certification Preparation

• Day 57: Practice Test on Word + Excel

• Day 58: Practice Test on Internet + PPT

• Day 59: Final Theory Test

• Day 60: Final Practical Test

• Day 61: Viva Exam + Review

• Day 62: Certificate Work + Printing


Bonus Sessions + Practice Days

• Day 63 – 75: Extra practice for Excel formulas, Typing Speed improvement, Backup sessions, Bonus Sessions: Keyboard Shortcuts



Course Fees

Course Fees
:
₹4500/-
Discounted Fees
:
₹ 3800/-
Course Duration
:
3 Months

Review

0.0
Course Rating (0 reviews)
0%
0%
0%
0%
0%