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.
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• Day 63 – 75: Extra practice for Excel formulas, Typing Speed improvement, Backup sessions, Bonus Sessions: Keyboard Shortcuts
No reviews yet. Be the first to review this course!
Enroll in your desired course
Copyright © 2025 DITRP INDIA. All Rights Reserved