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
Financial Accounting | Tally
Need of Accounting
Trade & Profession
Goods/Inventory
Purchase & Sale
Purchase & Sale Return
Debtor & Creditor
Transaction
Assets / Liabilities
Income / Expense
Playing with Ledgers
Discount / Bad Debt
Drawing / Capital
Expense v/s Loss
Income v/s Profit
Golden Rules
Journal Entries
Tally Prime & Tally.ERP9 Software
Tally Introduction
Tally.ERP v/s Tally Prime
Company Setup
Ledger Creation/Alter
Stock Creation/Alter
Receipt/Payment Voucher
Purchase/Sale/Contra Voucher
Journal/Optional Voucher
Debit and Credit Note
2 Assignments
Features Options
Memorandum Voucher
Posted-Dated Cheque
Godowns & Categories
Stock Journal
Export & Import Data
Financial Reports
Balance Sheet
Profit & Loss A/c
Stock Summary & Ratio
Day Book Report
Sale /Purchase Register
Stock Summary
Dashboard & Cash Flow
Cash Book Report
Exception Reports
TDS Deduction & Many more
Goods & Service Tax (GST)
Why we need GST
Types of GST (CGST, SGST, IGST, UT-GST)
Tax Slabs (0%, 5%, 12%, 18%, 28%)
GST Identification Number (GSTIN)
HSN & SAC Code
Different State Code
GST Enable & Alter Details
Filliing GST Number & Other Details
E-Invoicing Application
Practical with Original Invoices
Final Mini Project in Tally Prime
Payroll Management System
What is Payroll System
Enable Payroll
Employee Groups
Units (Work) Creation
Attendance/Production Type
Pay Heads & Alter Details
Payroll Voucher Type
Employee Creation
Employee Attendance
Salary Creation using Autofill
Salary Slip in Different Format (.pdf, .xls, etc.)
HTML Introduction
HTML Components
HTML Implementation
Heading & Paragraph Tag
<div> / <article> / <aside> Tag
<span> / </br> / </hr> Tag
Image <img> Tag
Links in HTML
Ordered & Un-Ordered Lists
Forms Tag (<input>, <option>, <select>, Etc.)
Tables Tag (<thead>, <tr>, <th>, <td>, Etc.)
<header>, <footer>, <main>, <article>, <video>, Etc.
Character and Symbol
CSS Introduction
CSS Syntax
CSS Styling in HTML
CSS Margin & Padding
CSS Selector
CSS Height & Width
CSS Fonts Family & Size
CSS Backgrounds
Final Mini Project
Google Product & Services (Bonus)
Google Docs
Google Sheets
Google Slides
Google Sites
Google Forms
Tools & Techniques (Bonus)
Canva for Designs
PosterMyWall
Launch your Graphy
