Computer Introduction
WordPad
MS Paint, 3D Paint
Folder Create/Update
Snipping Tool
RAM, HDD, ODD
Short-Cut Keys
Desktop Options
Basic Mother-Board
Notepad
Etc.
Why We Use MS Word
Text Editing, Formatting
Resume Making
Table Creations
Graphs & Layouts
Shapes & Charts
Pictures Formatting
Screen-shorts & Other
Header & Footer
Format Making - 4
Short-Cut Keys
Print-Options
Links/Cross References
Maths Q/P Design
Word to PDF Creation
Password Protection
Links/Cross References
Design & Watermark
Build in Themes
Page Border & Color
Layout & Page Setup
References & Footnote
Mail Merge Option
Review & View
Advanced Options
Final Mini Project
Why We Use MS Excel
Text Editing, Formatting
Basic Tools & Use
Sheet Options
Basic Operators
Fill Options & Tools
Basic Functions
Format Cell Options
Conditional Formatting
Styles Options
Insert/Delete/Format
Short & Filter/Editing
Pivot Tables Tools
Tables & It's Tools
Excel to PDF Creation
Password Protection
Shapes/Pictures/Icons
Charts & It's Types
Sparklines & It's Tools
Links & Symbols
Attendance Sheet
Office Salary Sheet
School Result Card
Paste Special Tools
Basic IF Function
Nested IF Function
AND/ OR Operators
Page Layouts & Setup
TEXT Functions
Simple VLOOKUP
Simple HLOOKUP
Format Making - 4
Macros & Review
Final Mini Project
Reality of Advanced Excel:
Advanced Excel skills include the ability to turning your ideas into reality in the digital space or Excel Sheet. It is not about functions/formula only, we using excel to easy our work using functions/formula.
Recap of Basic Excel Tools & Practicals
Advanced Date Functions
Stock Management System
Financial Functions (PMT/PPMT/IPMT/Etc)
Consolidate Function
SUMIF & SUMIFS
Advanced VLOOKUP
LOOKUP + MATCH
LOOKUP in Multiple Sheet
Double LOOKUP in Multiple Wookbooks
Advanced Attendance Sheet
Automated Fee Management System
Advanced Pivot Tables & Slicer
Pivot Chart/ Timeline/Graphs
Automated P& L Account
Common Errors in Excel
Automated Salary Sheet
Data Validation & Restrictions
Advanced Paste Special Tool
Data Dashboard (MIS)
Hotel Booking System
Fee Record with Graphs
Automated Certificated
Paste Special Tools
Retail Management System (MIS)
Automated Certificate Generation using Word
MIS Dashboard (Format Making)
2 Final Major Projects
Multiple Employee ID Card Generate using Word
Automated Multiple Report Card Generate for Students & Parents
Use of PowerPoint
Text Editing, Formatting
Slide Option & Tools
SmartArt & Pictures
Shapes & Charts
Making Presentation
Transition & It's Tools
Timing & Sound
Animations & It's Tools
Poster Making
Invitation Card Design
Password Protection
PPT to PDF Conversion
PPT to Video Creation
Slide Show Options
Slide Size & It's Options
Background Format
Recording Slides
Review & View
Final Mini Projects
Why We Use Outlook
Account Creation
Outlook v/s Gmail
Email Management
Office Apps Integration
Calendar Management
Tasks & To-Do List
Contact Management
Outlook Use in Office
Why We Use Publisher
Text Editing, Formatting
Page design & It's Tools
Custom Template
Template Designing
Flex Designing
Certificate Designing
Visiting Card Designing
Page Setup & It's Tools
Mail Merge in Publisher
Party-Invitation Design
Review & View
Final Mini Projects
Internet History
PAN/LAN/MAN/WAN
Remove Background
PDF Editors & Tools
Making QR Code of link
Downloading Software
ChatGPT AI Tool
Gemini AI
Server & Client
Browsers & Websites
Image Editing using AI
Google Product & Services (Bonus)
Google Docs
Google Sheets
Google Slides
Google Sites
Google Forms
