Complete Office Automation Course
In today’s competitive job market, practical skills matter more than just degrees. The Advance Office Automation – Mastery with AI Tools program is a comprehensive, career-focused course designed to make students fully job-ready in office administration, data management, accounting, and professional communication.
This course provides in-depth training in:
-
Microsoft Word (Advanced Documentation & Reporting)
-
Advanced Excel (Data Analysis, Automation & MIS Reporting)
-
Tally ERP with GST & Payroll (Practical Accounting & Compliance)
-
Interview Training & Professional Development
The curriculum is carefully structured to cover everything from basic fundamentals to advanced, industry-level applications. Students learn real office tasks such as report preparation, invoice creation, salary sheets, GST billing, financial statements, data analysis, pivot tables, and automation tools used in modern workplaces.
Demo Session Recording
Course Highlights / Content
Microsoft Word
1️⃣ File Tab
-
New
-
Open
-
Info
-
Save
-
Save As
-
Print
-
Share
-
Export (PDF/XPS)
-
Close
-
Account
-
Options
2️⃣ Home Tab
Clipboard
-
Paste
-
Cut
-
Copy
-
Format Painter
Font
-
Font Style
-
Font Size
-
Increase/Decrease Font
-
Bold
-
Italic
-
Underline
-
Strikethrough
-
Subscript / Superscript
-
Change Case
-
Clear Formatting
-
Text Highlight Color
-
Font Color
Paragraph
-
Bullets
-
Numbering
-
Multilevel List
-
Align Left / Center / Right / Justify
-
Line & Paragraph Spacing
-
Shading
-
Borders
-
Increase / Decrease Indent
-
Sort
-
Show/Hide ¶
Styles
-
Normal
-
Heading 1, 2, 3
-
Title
-
Subtitle
-
Custom Styles
Editing
-
Find
-
Replace
-
Select
3️⃣ Insert Tab
Pages
-
Cover Page
-
Blank Page
-
Page Break
Tables
-
Insert Table
-
Draw Table
-
Convert Text to Table
Illustrations
-
Pictures
-
Online Pictures
-
Shapes
-
Icons
-
SmartArt
-
Chart
-
Screenshot
Links
-
Hyperlink
-
Bookmark
-
Cross-reference
Header & Footer
-
Header
-
Footer
-
Page Number
Text
-
Text Box
-
Quick Parts
-
WordArt
-
Drop Cap
-
Signature Line
-
Date & Time
-
Object
Symbols
-
Equation
-
Symbol
4️⃣ Design Tab
-
Themes
-
Colors
-
Fonts
-
Effects
-
Style Set
-
Paragraph Spacing
-
Watermark
-
Page Color
-
Page Borders
5️⃣ Layout (Page Layout) Tab
Page Setup
-
Margins
-
Orientation
-
Size
-
Columns
-
Breaks
-
Line Numbers
-
Hyphenation
Paragraph
-
Indent (Left/Right)
-
Spacing (Before/After)
Arrange
-
Position
-
Wrap Text
-
Bring Forward
-
Send Backward
-
Align
-
Group
-
Rotate
6️⃣ References Tab
Table of Contents
-
Add Text
-
Update Table
Footnotes
-
Insert Footnote
-
Insert Endnote
-
Next Footnote
Citations & Bibliography
-
Insert Citation
-
Manage Sources
-
Style
-
Bibliography
Captions
-
Insert Caption
-
Table of Figures
-
Cross-reference
Index
-
Mark Entry
-
Insert Index
Table of Authorities
-
Mark Citation
-
Insert Table of Authorities
7️⃣ Mailings Tab
-
Envelopes
-
Labels
-
Start Mail Merge
-
Select Recipients
-
Edit Recipient List
-
Insert Merge Field
-
Preview Results
-
Finish & Merge
8️⃣ Review Tab
-
Spelling & Grammar
-
Thesaurus
-
Word Count
-
Translate
-
Language
-
Comments (New/Delete)
-
Track Changes
-
Accept / Reject
-
Compare
-
Protect Document
9️⃣ View Tab
-
Read Mode
-
Print Layout
-
Web Layout
-
Ruler
-
Gridlines
-
Navigation Pane
-
Zoom
-
One Page / Multiple Pages
-
Window (Split, Side by Side)
-
Macros
🔟 Help Tab
-
Help
-
Contact Support
-
Feedback
Microsoft Excel
🔰 Module 1: Excel Basics (Beginner)
-
Introduction to MS Excel
-
Workbook & Worksheet
-
Rows, Columns, Cells
-
Cell Address & Range
-
Data Types (Text, Number, Date)
-
Save, Save As, Open
-
Excel Interface Overview
📊 Module 2: Data Entry & Formatting
-
Cell Formatting
-
Font, Size, Color
-
Alignment
-
Wrap Text
-
Merge & Center
-
-
Number Formatting
-
Currency
-
Percentage
-
Date & Time
-
-
Conditional Formatting (Basic)
🧮 Module 3: Basic Formulas & Functions
-
Formula Basics
-
Arithmetic Operators (+, -, *, /)
-
AutoSum
-
Basic Functions
-
SUM
-
AVERAGE
-
COUNT
-
MAX
-
MIN
-
📋 Module 4: Data Management
-
-
Sort (Single & Multiple Level)
-
Filter (Auto Filter, Custom Filter)
-
Data Validation
-
Dropdown List
-
-
Remove Duplicates
-
Text to Columns
-
Flash Fill
-
📈 Module 5: Charts & Visualization
-
Column Chart
-
Bar Chart
-
Line Chart
-
Pie Chart
-
Area Chart
-
Chart Formatting
-
Sparklines
🧠 Module 6: Logical & Text Functions
Logical Functions
-
IF
-
AND
-
OR
-
IFERROR
Text Functions
-
LEFT
-
RIGHT
-
MID
-
LEN
-
TRIM
-
UPPER / LOWER / PROPER
-
CONCAT / CONCATENATE
🔍 Module 7: Lookup & Reference Functions
-
-
VLOOKUP
-
HLOOKUP
-
XLOOKUP
-
INDEX
-
MATCH
-
📅 Module 8: Date & Time Functions
-
TODAY
-
NOW
-
DATE
-
DATEDIF
-
DAY / MONTH / YEAR
📑 Module 9: Advanced Excel Tools
-
Conditional Formatting (Advanced)
-
Pivot Table
-
Pivot Chart
-
Slicers & Timelines
-
What-If Analysis
-
Goal Seek
-
Scenario Manager
-
Data Table
-
🔐 Module 10: Workbook Management
-
-
Protect Sheet
-
Protect Workbook
-
Hide / Unhide Rows & Columns
-
Freeze Panes
-
Page Setup
-
Print Titles
-
Print Area
-
⚙️ Module 11: Excel Automation (Optional)
-
Introduction to Macros
-
Record Macro
-
Macro Security
-
Basic VBA Concepts
📂 Module 12: Practical Applications
-
Sales Report
-
Attendance Sheet
-
Salary Sheet
-
Invoice Format
-
Stock Management Sheet
-
MIS Report
🎓 Module 13: Shortcuts & Productivity
-
Common Keyboard Shortcuts
-
Excel Tips & Tricks
-
Error Handling
-
Best Practices
Power Point
1. Introduction to PowerPoint
-
What is Microsoft PowerPoint
-
Uses of PowerPoint
-
Understanding Presentation & Slides
-
PowerPoint Interface (Ribbon, Tabs, Slides Pane)
2. Creating a Presentation
-
Create a New Presentation
-
Using Blank Presentation
-
Using Built-in Templates & Themes
-
Save, Save As, and File Formats
3. Working with Slides
-
Add, Delete, Duplicate Slides
-
Slide Layouts
-
Reorder Slides
-
Slide Sections
4. Text Formatting
-
Text Box & Placeholder
-
Font Style, Size, Color
-
Alignment & Spacing
-
Bullets & Numbering
5. Working with Images & Objects
-
Insert Pictures & Icons
-
Shapes & SmartArt
-
Resize, Crop & Align Objects
-
Group & Ungroup Objects
6. Tables & Charts
-
Insert & Format Tables
-
Insert Charts (Column, Bar, Pie, Line)
-
Edit Chart Data using Excel
7. Design & Formatting
-
Apply Themes & Variants
-
Slide Background Design
-
Slide Master (Basic)
-
Consistent Formatting
8. Transitions & Animations
-
Slide Transitions
-
Animation Types (Entrance, Emphasis, Exit)
-
Animation Pane
-
Timing & Effects
9. Multimedia in PowerPoint
-
Insert Audio & Video
-
Play Options & Trimming
-
Screen Recording (Basic)
10. Slide Show & Presentation Tools
-
Slide Show Modes
-
Presenter View
-
Rehearse Timings
-
Set Up Slide Show
11. Review & Proofing
-
Spelling & Grammar Check
-
Comments & Notes
-
Compare Presentations
12. Printing & Exporting
-
Print Slides, Handouts, Notes Pages
-
Export as PDF & Video
-
Share Presentation
13. Practical Projects
-
Business Presentation
-
Educational / Training Slides
-
Sales or Marketing Presentation
14. Tips for Effective Presentations
-
Slide Design Rules
-
Use of Colors & Fonts
-
Presentation Skills Basics
Tally ERP 9
1. Introduction to Accounting & Tally ERP 9
-
Basics of Accounting
-
Types of Accounts
-
Golden Rules of Accounting
-
Manual Accounting vs Computerized Accounting
-
Introduction to Tally ERP 9
-
Features and Advantages of Tally
2. Company Creation & Configuration
-
Create, Select, Alter, Delete Company
-
Company Features (F11)
-
Configuration Settings (F12)
-
Accounting & Inventory Features
3. Ledger Creation
-
What is Ledger
-
Predefined Ledgers in Tally
-
Create, Alter & Delete Ledgers
-
Group Creation & Alteration
4. Voucher Entry (Accounting Vouchers)
-
Contra Voucher
-
Payment Voucher
-
Receipt Voucher
-
Journal Voucher
-
Sales Voucher
-
Purchase Voucher
-
Credit Note & Debit Note
5. Inventory Management
-
Stock Groups
-
Stock Categories
-
Stock Items
-
Units of Measurement
-
Godowns (Stores)
-
Opening Stock Entry
6. Purchase & Sales Management
-
Purchase Order
-
Sales Order
-
Delivery Note
-
Receipt Note
-
Invoice Generation
-
Bill-wise Details
7. GST (Goods and Services Tax)
-
Introduction to GST
-
GST Registration Details in Tally
-
GST Ledger Creation
-
GST on Sales & Purchase
-
Input Tax Credit (ITC)
-
GST Returns (GSTR-1, GSTR-3B)
-
GST Reports
8. Banking in Tally
-
Bank Ledger Creation
-
Cheque Printing
-
Bank Reconciliation Statement (BRS)
-
Post-dated Cheques
9. Cost Centres & Cost Categories
-
Introduction to Costing
-
Create Cost Centres
-
Cost Category
-
Allocation of Expenses
10. Payroll Management
-
Employee Creation
-
Salary Structure
-
Attendance / Production Types
-
Payroll Vouchers
-
Payroll Reports
11. TDS (Tax Deducted at Source)
-
Introduction to TDS
-
TDS Ledger Creation
-
TDS Deduction Entry
-
TDS Returns & Reports
12. TCS (Tax Collected at Source)
-
Basics of TCS
-
TCS Setup in Tally
-
TCS Transactions
13. Reports in Tally
-
Trial Balance
-
Profit & Loss Account
-
Balance Sheet
-
Stock Summary
-
Outstanding Reports
-
Day Book
-
Cash / Bank Book
14. Final Accounts
-
P&L Account
-
Balance Sheet
-
Adjustments
-
Closing Stock
15. Data Backup & Security
-
Backup & Restore Data
-
User Creation
-
Security Control
-
Password Management
16. Practical & Live Projects
-
Trading Company Accounts
-
Manufacturing Company Accounts
-
Service Company Accounts
-
GST-based Real-life Transactions
17. Career & Job-Oriented Training
-
Accountant Roles & Responsibilities
-
Tally + GST Job Profile
-
Interview Preparation
-
Practical Accounting Practice
Interview Traning
🔹 Module 1: Interview Basics & Mindset (2 Days)
1. What is Interview?
-
HR Interview vs Technical Interview
-
Telephonic vs Face-to-face vs Online Interview
-
Fresher vs Experienced Interview difference
2. Psychology of Interview
-
Employer kya dekh raha hota hai?
-
Communication
-
Confidence
-
Clarity
-
Attitude
-
Basic Skill
-
3. Common Fear Removal Session
-
Stage fear breaking activity
-
1-minute self introduction round (daily practice)
🔹 Module 2: Self Introduction Mastery (3 Days Practice)
Structure Sikhaye:
-
Greeting
-
Name + Education
-
Course/Skill
-
Internship/Project
-
Strength
-
Career Goal
Daily Practice:
-
30 sec version
-
1 minute version
-
2 minute professional version
👉 Har student ka video record karein aur feedback dein.
🔹 Module 3: Communication & Body Language (5 Days)
1. Body Language Training
-
Eye contact
-
Hand position
-
Sitting posture
-
Smile & expression
2. Voice Training
-
Clear pronunciation
-
Slow & confident speaking
-
Filler words remove karna (umm, matlab, actually)
3. Basic English for Interview
-
Common Interview Sentences
-
Office Communication Lines
-
Telephone Etiquette
Daily activity:
-
Pair practice
-
Role play
-
Group discussion
🔹 Module 4: Technical Interview Preparation (Course Based)
Aapke courses:
-
MS Word
-
MS Excel
-
PowerPoint
-
Tally
-
Basic Computer
-
Power BI
Har course ke liye:
-
Top 25 Technical Questions
-
Practical Test Simulation
-
Live Task Practice (10–15 min assignment)
Example (Excel Student):
-
VLOOKUP kya hai?
-
Pivot Table ka use?
-
Basic formulas
-
Real invoice sheet banana
🔹 Module 5: HR Questions Mastery (5 Days)
Top Questions:
-
Tell me about yourself
-
Why should we hire you?
-
Strength & Weakness?
-
Why do you want this job?
-
Expected salary?
-
Where do you see yourself in 5 years?
-
Gap explain kaise karein?
-
Fresher hone ke bawajood aap job ke liye ready kaise ho?
👉 Har question ka structure-based answer likhwayein.
🔹 Module 6: Resume & Documentation Training (2 Days)
-
Professional Resume Format
-
Photo selection
-
Email ID kaise professional banaye
-
Subject line kaise likhe
-
Interview call ka reply kaise kare
🔹 Module 7: Mock Interview System (Compulsory)
Weekly Mock Interview
-
1 HR Round
-
1 Technical Round
Panel system banaye:
-
1 Teacher HR bane
-
1 Technical Expert bane
Marking System:
-
Confidence (10)
-
Communication (10)
-
Technical (20)
-
Body language (10)
Total: 50 marks
50 se kam – Re-training
🔹 Module 8: Real Interview Simulation Day
-
Formal dress compulsory
-
Resume print
-
Waiting room system
-
Interview cabin system
Exactly company jaisa environment banaye.
📅 Suggested Duration
Total Duration: 15–20 Days
Daily 1 Hour Interview Training
🎓 Bonus: Placement Readiness Checklist
Before Sending to Interview:
☑ Resume approved
☑ Self intro ready
☑ 2 Mock clear
☑ Dress code training
☑ Salary expectation clear
1️⃣ File Tab
-
New
-
Open
-
Info
-
Save
-
Save As
-
Print
-
Share
-
Export (PDF/XPS)
-
Close
-
Account
-
Options
2️⃣ Home Tab
Clipboard
-
Paste
-
Cut
-
Copy
-
Format Painter
Font
-
Font Style
-
Font Size
-
Increase/Decrease Font
-
Bold
-
Italic
-
Underline
-
Strikethrough
-
Subscript / Superscript
-
Change Case
-
Clear Formatting
-
Text Highlight Color
-
Font Color
Paragraph
-
Bullets
-
Numbering
-
Multilevel List
-
Align Left / Center / Right / Justify
-
Line & Paragraph Spacing
-
Shading
-
Borders
-
Increase / Decrease Indent
-
Sort
-
Show/Hide ¶
Styles
-
Normal
-
Heading 1, 2, 3
-
Title
-
Subtitle
-
Custom Styles
Editing
-
Find
-
Replace
-
Select
3️⃣ Insert Tab
Pages
-
Cover Page
-
Blank Page
-
Page Break
Tables
-
Insert Table
-
Draw Table
-
Convert Text to Table
Illustrations
-
Pictures
-
Online Pictures
-
Shapes
-
Icons
-
SmartArt
-
Chart
-
Screenshot
Links
-
Hyperlink
-
Bookmark
-
Cross-reference
Header & Footer
-
Header
-
Footer
-
Page Number
Text
-
Text Box
-
Quick Parts
-
WordArt
-
Drop Cap
-
Signature Line
-
Date & Time
-
Object
Symbols
-
Equation
-
Symbol
4️⃣ Design Tab
-
Themes
-
Colors
-
Fonts
-
Effects
-
Style Set
-
Paragraph Spacing
-
Watermark
-
Page Color
-
Page Borders
5️⃣ Layout (Page Layout) Tab
Page Setup
-
Margins
-
Orientation
-
Size
-
Columns
-
Breaks
-
Line Numbers
-
Hyphenation
Paragraph
-
Indent (Left/Right)
-
Spacing (Before/After)
Arrange
-
Position
-
Wrap Text
-
Bring Forward
-
Send Backward
-
Align
-
Group
-
Rotate
6️⃣ References Tab
Table of Contents
-
Add Text
-
Update Table
Footnotes
-
Insert Footnote
-
Insert Endnote
-
Next Footnote
Citations & Bibliography
-
Insert Citation
-
Manage Sources
-
Style
-
Bibliography
Captions
-
Insert Caption
-
Table of Figures
-
Cross-reference
Index
-
Mark Entry
-
Insert Index
Table of Authorities
-
Mark Citation
-
Insert Table of Authorities
7️⃣ Mailings Tab
-
Envelopes
-
Labels
-
Start Mail Merge
-
Select Recipients
-
Edit Recipient List
-
Insert Merge Field
-
Preview Results
-
Finish & Merge
8️⃣ Review Tab
-
Spelling & Grammar
-
Thesaurus
-
Word Count
-
Translate
-
Language
-
Comments (New/Delete)
-
Track Changes
-
Accept / Reject
-
Compare
-
Protect Document
9️⃣ View Tab
-
Read Mode
-
Print Layout
-
Web Layout
-
Ruler
-
Gridlines
-
Navigation Pane
-
Zoom
-
One Page / Multiple Pages
-
Window (Split, Side by Side)
-
Macros
🔟 Help Tab
-
Help
-
Contact Support
-
Feedback
-
New
-
Open
-
Info
-
Save
-
Save As
-
Print
-
Share
-
Export (PDF/XPS)
-
Close
-
Account
-
Options
Clipboard
-
Paste
-
Cut
-
Copy
-
Format Painter
Font
-
Font Style
-
Font Size
-
Increase/Decrease Font
-
Bold
-
Italic
-
Underline
-
Strikethrough
-
Subscript / Superscript
-
Change Case
-
Clear Formatting
-
Text Highlight Color
-
Font Color
Paragraph
-
Bullets
-
Numbering
-
Multilevel List
-
Align Left / Center / Right / Justify
-
Line & Paragraph Spacing
-
Shading
-
Borders
-
Increase / Decrease Indent
-
Sort
-
Show/Hide ¶
Styles
-
Normal
-
Heading 1, 2, 3
-
Title
-
Subtitle
-
Custom Styles
Editing
-
Find
-
Replace
-
Select
Pages
-
Cover Page
-
Blank Page
-
Page Break
Tables
-
Insert Table
-
Draw Table
-
Convert Text to Table
Illustrations
-
Pictures
-
Online Pictures
-
Shapes
-
Icons
-
SmartArt
-
Chart
-
Screenshot
Links
-
Hyperlink
-
Bookmark
-
Cross-reference
Header & Footer
-
Header
-
Footer
-
Page Number
Text
-
Text Box
-
Quick Parts
-
WordArt
-
Drop Cap
-
Signature Line
-
Date & Time
-
Object
Symbols
-
Equation
-
Symbol
-
Themes
-
Colors
-
Fonts
-
Effects
-
Style Set
-
Paragraph Spacing
-
Watermark
-
Page Color
-
Page Borders
Page Setup
-
Margins
-
Orientation
-
Size
-
Columns
-
Breaks
-
Line Numbers
-
Hyphenation
Paragraph
-
Indent (Left/Right)
-
Spacing (Before/After)
Arrange
-
Position
-
Wrap Text
-
Bring Forward
-
Send Backward
-
Align
-
Group
-
Rotate
Table of Contents
-
Add Text
-
Update Table
Footnotes
-
Insert Footnote
-
Insert Endnote
-
Next Footnote
Citations & Bibliography
-
Insert Citation
-
Manage Sources
-
Style
-
Bibliography
Captions
-
Insert Caption
-
Table of Figures
-
Cross-reference
Index
-
Mark Entry
-
Insert Index
Table of Authorities
-
Mark Citation
-
Insert Table of Authorities
-
Envelopes
-
Labels
-
Start Mail Merge
-
Select Recipients
-
Edit Recipient List
-
Insert Merge Field
-
Preview Results
-
Finish & Merge
-
Spelling & Grammar
-
Thesaurus
-
Word Count
-
Translate
-
Language
-
Comments (New/Delete)
-
Track Changes
-
Accept / Reject
-
Compare
-
Protect Document
-
Read Mode
-
Print Layout
-
Web Layout
-
Ruler
-
Gridlines
-
Navigation Pane
-
Zoom
-
One Page / Multiple Pages
-
Window (Split, Side by Side)
-
Macros
-
Help
-
Contact Support
-
Feedback
🔰 Module 1: Excel Basics (Beginner)
-
Introduction to MS Excel
-
Workbook & Worksheet
-
Rows, Columns, Cells
-
Cell Address & Range
-
Data Types (Text, Number, Date)
-
Save, Save As, Open
-
Excel Interface Overview
📊 Module 2: Data Entry & Formatting
-
Cell Formatting
-
Font, Size, Color
-
Alignment
-
Wrap Text
-
Merge & Center
-
-
Number Formatting
-
Currency
-
Percentage
-
Date & Time
-
-
Conditional Formatting (Basic)
🧮 Module 3: Basic Formulas & Functions
-
Formula Basics
-
Arithmetic Operators (+, -, *, /)
-
AutoSum
-
Basic Functions
-
SUM
-
AVERAGE
-
COUNT
-
MAX
-
MIN
-
📋 Module 4: Data Management
-
-
Sort (Single & Multiple Level)
-
Filter (Auto Filter, Custom Filter)
-
Data Validation
-
Dropdown List
-
-
Remove Duplicates
-
Text to Columns
-
Flash Fill
-
📈 Module 5: Charts & Visualization
-
Column Chart
-
Bar Chart
-
Line Chart
-
Pie Chart
-
Area Chart
-
Chart Formatting
-
Sparklines
🧠 Module 6: Logical & Text Functions
Logical Functions
-
IF
-
AND
-
OR
-
IFERROR
Text Functions
-
LEFT
-
RIGHT
-
MID
-
LEN
-
TRIM
-
UPPER / LOWER / PROPER
-
CONCAT / CONCATENATE
🔍 Module 7: Lookup & Reference Functions
-
-
VLOOKUP
-
HLOOKUP
-
XLOOKUP
-
INDEX
-
MATCH
-
📅 Module 8: Date & Time Functions
-
TODAY
-
NOW
-
DATE
-
DATEDIF
-
DAY / MONTH / YEAR
📑 Module 9: Advanced Excel Tools
-
Conditional Formatting (Advanced)
-
Pivot Table
-
Pivot Chart
-
Slicers & Timelines
-
What-If Analysis
-
Goal Seek
-
Scenario Manager
-
Data Table
-
🔐 Module 10: Workbook Management
-
-
Protect Sheet
-
Protect Workbook
-
Hide / Unhide Rows & Columns
-
Freeze Panes
-
Page Setup
-
Print Titles
-
Print Area
-
⚙️ Module 11: Excel Automation (Optional)
-
Introduction to Macros
-
Record Macro
-
Macro Security
-
Basic VBA Concepts
📂 Module 12: Practical Applications
-
Sales Report
-
Attendance Sheet
-
Salary Sheet
-
Invoice Format
-
Stock Management Sheet
-
MIS Report
🎓 Module 13: Shortcuts & Productivity
-
Common Keyboard Shortcuts
-
Excel Tips & Tricks
-
Error Handling
-
Best Practices
-
Introduction to MS Excel
-
Workbook & Worksheet
-
Rows, Columns, Cells
-
Cell Address & Range
-
Data Types (Text, Number, Date)
-
Save, Save As, Open
-
Excel Interface Overview
-
Cell Formatting
-
Font, Size, Color
-
Alignment
-
Wrap Text
-
Merge & Center
-
-
Number Formatting
-
Currency
-
Percentage
-
Date & Time
-
-
Conditional Formatting (Basic)
-
Formula Basics
-
Arithmetic Operators (+, -, *, /)
-
AutoSum
-
Basic Functions
-
SUM
-
AVERAGE
-
COUNT
-
MAX
-
MIN
-
-
-
Sort (Single & Multiple Level)
-
Filter (Auto Filter, Custom Filter)
-
Data Validation
-
Dropdown List
-
-
Remove Duplicates
-
Text to Columns
-
Flash Fill
-
-
Column Chart
-
Bar Chart
-
Line Chart
-
Pie Chart
-
Area Chart
-
Chart Formatting
-
Sparklines
Logical Functions
-
IF
-
AND
-
OR
-
IFERROR
Text Functions
-
LEFT
-
RIGHT
-
MID
-
LEN
-
TRIM
-
UPPER / LOWER / PROPER
-
CONCAT / CONCATENATE
-
-
VLOOKUP
-
HLOOKUP
-
XLOOKUP
-
INDEX
-
MATCH
-
-
TODAY
-
NOW
-
DATE
-
DATEDIF
-
DAY / MONTH / YEAR
-
Conditional Formatting (Advanced)
-
Pivot Table
-
Pivot Chart
-
Slicers & Timelines
-
What-If Analysis
-
Goal Seek
-
Scenario Manager
-
Data Table
-
-
-
Protect Sheet
-
Protect Workbook
-
Hide / Unhide Rows & Columns
-
Freeze Panes
-
Page Setup
-
Print Titles
-
Print Area
-
-
Introduction to Macros
-
Record Macro
-
Macro Security
-
Basic VBA Concepts
-
Sales Report
-
Attendance Sheet
-
Salary Sheet
-
Invoice Format
-
Stock Management Sheet
-
MIS Report
-
Common Keyboard Shortcuts
-
Excel Tips & Tricks
-
Error Handling
-
Best Practices
1. Introduction to PowerPoint
-
What is Microsoft PowerPoint
-
Uses of PowerPoint
-
Understanding Presentation & Slides
-
PowerPoint Interface (Ribbon, Tabs, Slides Pane)
2. Creating a Presentation
-
Create a New Presentation
-
Using Blank Presentation
-
Using Built-in Templates & Themes
-
Save, Save As, and File Formats
3. Working with Slides
-
Add, Delete, Duplicate Slides
-
Slide Layouts
-
Reorder Slides
-
Slide Sections
4. Text Formatting
-
Text Box & Placeholder
-
Font Style, Size, Color
-
Alignment & Spacing
-
Bullets & Numbering
5. Working with Images & Objects
-
Insert Pictures & Icons
-
Shapes & SmartArt
-
Resize, Crop & Align Objects
-
Group & Ungroup Objects
6. Tables & Charts
-
Insert & Format Tables
-
Insert Charts (Column, Bar, Pie, Line)
-
Edit Chart Data using Excel
7. Design & Formatting
-
Apply Themes & Variants
-
Slide Background Design
-
Slide Master (Basic)
-
Consistent Formatting
8. Transitions & Animations
-
Slide Transitions
-
Animation Types (Entrance, Emphasis, Exit)
-
Animation Pane
-
Timing & Effects
9. Multimedia in PowerPoint
-
Insert Audio & Video
-
Play Options & Trimming
-
Screen Recording (Basic)
10. Slide Show & Presentation Tools
-
Slide Show Modes
-
Presenter View
-
Rehearse Timings
-
Set Up Slide Show
11. Review & Proofing
-
Spelling & Grammar Check
-
Comments & Notes
-
Compare Presentations
12. Printing & Exporting
-
Print Slides, Handouts, Notes Pages
-
Export as PDF & Video
-
Share Presentation
13. Practical Projects
-
Business Presentation
-
Educational / Training Slides
-
Sales or Marketing Presentation
14. Tips for Effective Presentations
-
Slide Design Rules
-
Use of Colors & Fonts
-
Presentation Skills Basics
-
What is Microsoft PowerPoint
-
Uses of PowerPoint
-
Understanding Presentation & Slides
-
PowerPoint Interface (Ribbon, Tabs, Slides Pane)
-
Create a New Presentation
-
Using Blank Presentation
-
Using Built-in Templates & Themes
-
Save, Save As, and File Formats
-
Add, Delete, Duplicate Slides
-
Slide Layouts
-
Reorder Slides
-
Slide Sections
-
Text Box & Placeholder
-
Font Style, Size, Color
-
Alignment & Spacing
-
Bullets & Numbering
-
Insert Pictures & Icons
-
Shapes & SmartArt
-
Resize, Crop & Align Objects
-
Group & Ungroup Objects
-
Insert & Format Tables
-
Insert Charts (Column, Bar, Pie, Line)
-
Edit Chart Data using Excel
-
Apply Themes & Variants
-
Slide Background Design
-
Slide Master (Basic)
-
Consistent Formatting
-
Slide Transitions
-
Animation Types (Entrance, Emphasis, Exit)
-
Animation Pane
-
Timing & Effects
-
Insert Audio & Video
-
Play Options & Trimming
-
Screen Recording (Basic)
-
Slide Show Modes
-
Presenter View
-
Rehearse Timings
-
Set Up Slide Show
-
Spelling & Grammar Check
-
Comments & Notes
-
Compare Presentations
-
Print Slides, Handouts, Notes Pages
-
Export as PDF & Video
-
Share Presentation
-
Business Presentation
-
Educational / Training Slides
-
Sales or Marketing Presentation
-
Slide Design Rules
-
Use of Colors & Fonts
-
Presentation Skills Basics
1. Introduction to Accounting & Tally ERP 9
-
Basics of Accounting
-
Types of Accounts
-
Golden Rules of Accounting
-
Manual Accounting vs Computerized Accounting
-
Introduction to Tally ERP 9
-
Features and Advantages of Tally
2. Company Creation & Configuration
-
Create, Select, Alter, Delete Company
-
Company Features (F11)
-
Configuration Settings (F12)
-
Accounting & Inventory Features
3. Ledger Creation
-
What is Ledger
-
Predefined Ledgers in Tally
-
Create, Alter & Delete Ledgers
-
Group Creation & Alteration
4. Voucher Entry (Accounting Vouchers)
-
Contra Voucher
-
Payment Voucher
-
Receipt Voucher
-
Journal Voucher
-
Sales Voucher
-
Purchase Voucher
-
Credit Note & Debit Note
5. Inventory Management
-
Stock Groups
-
Stock Categories
-
Stock Items
-
Units of Measurement
-
Godowns (Stores)
-
Opening Stock Entry
6. Purchase & Sales Management
-
Purchase Order
-
Sales Order
-
Delivery Note
-
Receipt Note
-
Invoice Generation
-
Bill-wise Details
7. GST (Goods and Services Tax)
-
Introduction to GST
-
GST Registration Details in Tally
-
GST Ledger Creation
-
GST on Sales & Purchase
-
Input Tax Credit (ITC)
-
GST Returns (GSTR-1, GSTR-3B)
-
GST Reports
8. Banking in Tally
-
Bank Ledger Creation
-
Cheque Printing
-
Bank Reconciliation Statement (BRS)
-
Post-dated Cheques
9. Cost Centres & Cost Categories
-
Introduction to Costing
-
Create Cost Centres
-
Cost Category
-
Allocation of Expenses
10. Payroll Management
-
Employee Creation
-
Salary Structure
-
Attendance / Production Types
-
Payroll Vouchers
-
Payroll Reports
11. TDS (Tax Deducted at Source)
-
Introduction to TDS
-
TDS Ledger Creation
-
TDS Deduction Entry
-
TDS Returns & Reports
12. TCS (Tax Collected at Source)
-
Basics of TCS
-
TCS Setup in Tally
-
TCS Transactions
13. Reports in Tally
-
Trial Balance
-
Profit & Loss Account
-
Balance Sheet
-
Stock Summary
-
Outstanding Reports
-
Day Book
-
Cash / Bank Book
14. Final Accounts
-
P&L Account
-
Balance Sheet
-
Adjustments
-
Closing Stock
15. Data Backup & Security
-
Backup & Restore Data
-
User Creation
-
Security Control
-
Password Management
16. Practical & Live Projects
-
Trading Company Accounts
-
Manufacturing Company Accounts
-
Service Company Accounts
-
GST-based Real-life Transactions
17. Career & Job-Oriented Training
-
Accountant Roles & Responsibilities
-
Tally + GST Job Profile
-
Interview Preparation
-
Practical Accounting Practice
-
Basics of Accounting
-
Types of Accounts
-
Golden Rules of Accounting
-
Manual Accounting vs Computerized Accounting
-
Introduction to Tally ERP 9
-
Features and Advantages of Tally
-
Create, Select, Alter, Delete Company
-
Company Features (F11)
-
Configuration Settings (F12)
-
Accounting & Inventory Features
-
What is Ledger
-
Predefined Ledgers in Tally
-
Create, Alter & Delete Ledgers
-
Group Creation & Alteration
-
Contra Voucher
-
Payment Voucher
-
Receipt Voucher
-
Journal Voucher
-
Sales Voucher
-
Purchase Voucher
-
Credit Note & Debit Note
-
Stock Groups
-
Stock Categories
-
Stock Items
-
Units of Measurement
-
Godowns (Stores)
-
Opening Stock Entry
-
Purchase Order
-
Sales Order
-
Delivery Note
-
Receipt Note
-
Invoice Generation
-
Bill-wise Details
-
Introduction to GST
-
GST Registration Details in Tally
-
GST Ledger Creation
-
GST on Sales & Purchase
-
Input Tax Credit (ITC)
-
GST Returns (GSTR-1, GSTR-3B)
-
GST Reports
-
Bank Ledger Creation
-
Cheque Printing
-
Bank Reconciliation Statement (BRS)
-
Post-dated Cheques
-
Introduction to Costing
-
Create Cost Centres
-
Cost Category
-
Allocation of Expenses
-
Employee Creation
-
Salary Structure
-
Attendance / Production Types
-
Payroll Vouchers
-
Payroll Reports
-
Introduction to TDS
-
TDS Ledger Creation
-
TDS Deduction Entry
-
TDS Returns & Reports
-
Basics of TCS
-
TCS Setup in Tally
-
TCS Transactions
-
Trial Balance
-
Profit & Loss Account
-
Balance Sheet
-
Stock Summary
-
Outstanding Reports
-
Day Book
-
Cash / Bank Book
-
P&L Account
-
Balance Sheet
-
Adjustments
-
Closing Stock
-
Backup & Restore Data
-
User Creation
-
Security Control
-
Password Management
-
Trading Company Accounts
-
Manufacturing Company Accounts
-
Service Company Accounts
-
GST-based Real-life Transactions
-
Accountant Roles & Responsibilities
-
Tally + GST Job Profile
-
Interview Preparation
-
Practical Accounting Practice
🔹 Module 1: Interview Basics & Mindset (2 Days)
1. What is Interview?
-
HR Interview vs Technical Interview
-
Telephonic vs Face-to-face vs Online Interview
-
Fresher vs Experienced Interview difference
2. Psychology of Interview
-
Employer kya dekh raha hota hai?
-
Communication
-
Confidence
-
Clarity
-
Attitude
-
Basic Skill
-
3. Common Fear Removal Session
-
Stage fear breaking activity
-
1-minute self introduction round (daily practice)
🔹 Module 2: Self Introduction Mastery (3 Days Practice)
Structure Sikhaye:
-
Greeting
-
Name + Education
-
Course/Skill
-
Internship/Project
-
Strength
-
Career Goal
Daily Practice:
-
30 sec version
-
1 minute version
-
2 minute professional version
👉 Har student ka video record karein aur feedback dein.
🔹 Module 3: Communication & Body Language (5 Days)
1. Body Language Training
-
Eye contact
-
Hand position
-
Sitting posture
-
Smile & expression
2. Voice Training
-
Clear pronunciation
-
Slow & confident speaking
-
Filler words remove karna (umm, matlab, actually)
3. Basic English for Interview
-
Common Interview Sentences
-
Office Communication Lines
-
Telephone Etiquette
Daily activity:
-
Pair practice
-
Role play
-
Group discussion
🔹 Module 4: Technical Interview Preparation (Course Based)
Aapke courses:
-
MS Word
-
MS Excel
-
PowerPoint
-
Tally
-
Basic Computer
-
Power BI
Har course ke liye:
-
Top 25 Technical Questions
-
Practical Test Simulation
-
Live Task Practice (10–15 min assignment)
Example (Excel Student):
-
VLOOKUP kya hai?
-
Pivot Table ka use?
-
Basic formulas
-
Real invoice sheet banana
🔹 Module 5: HR Questions Mastery (5 Days)
Top Questions:
-
Tell me about yourself
-
Why should we hire you?
-
Strength & Weakness?
-
Why do you want this job?
-
Expected salary?
-
Where do you see yourself in 5 years?
-
Gap explain kaise karein?
-
Fresher hone ke bawajood aap job ke liye ready kaise ho?
👉 Har question ka structure-based answer likhwayein.
🔹 Module 6: Resume & Documentation Training (2 Days)
-
Professional Resume Format
-
Photo selection
-
Email ID kaise professional banaye
-
Subject line kaise likhe
-
Interview call ka reply kaise kare
🔹 Module 7: Mock Interview System (Compulsory)
Weekly Mock Interview
-
1 HR Round
-
1 Technical Round
Panel system banaye:
-
1 Teacher HR bane
-
1 Technical Expert bane
Marking System:
-
Confidence (10)
-
Communication (10)
-
Technical (20)
-
Body language (10)
Total: 50 marks
50 se kam – Re-training
🔹 Module 8: Real Interview Simulation Day
-
Formal dress compulsory
-
Resume print
-
Waiting room system
-
Interview cabin system
Exactly company jaisa environment banaye.
📅 Suggested Duration
Total Duration: 15–20 Days
Daily 1 Hour Interview Training
🎓 Bonus: Placement Readiness Checklist
Before Sending to Interview:
☑ Resume approved
☑ Self intro ready
☑ 2 Mock clear
☑ Dress code training
☑ Salary expectation clear
Price
1 Year Support
6 Months Support
3 Months Support
Pay Fee
Duration

Every session is divided into three sections.
- Doubt Section (15 min) : Before Session starts, Recap and doubt Sessions
- Learning Section (45 min) : Learning Discussion as per syllabus.
- Practice Section (30 min) : Practice Evaluation once Discussion is over.
Review
