Home
Courses
Microsoft Office Suites
Microsoft Office Course
Diploma Course
ADCA
CCC
Designing cousre
Web Designimg
Video Editing
Editing with Adobe
Digital Marketing
Accountig Courses
Tally
Student Registration
Contact
Privacy Policy
Try for free
Search
ADVANCE EXCEL
Dsd Education
>
Courses
>
Microsoft Office Suites
>
ADVANCE EXCEL
Home
Courses
Microsoft Office Suites
ADVANCE EXCEL
20 Sections
127 Lessons
10 Weeks
Curriculum
20 Sections
127 Lessons
10 Weeks
Expand all sections
Collapse all sections
Unit 1: Introduction to Microsoft Excel
10 Items
1.1
Microsoft Excel kya hai
1.2
Spreadsheet kya hoti hai
1.3
Workbook aur Worksheet
1.4
Rows, Columns aur Cells
1.5
Cell Address
1.6
Data Entry
1.7
Excel Workbook file format
1.8
Formula Bar
1.9
Name Box
1.10
Function Wizard
Unit 2: Functions & Formulas
7 Items
2.1
Insert Function
2.2
Function Wizard
2.3
Functions kya hain
2.4
Operators
2.5
Function Arguments
2.6
Formula ka structure
2.7
Formula kya hai
Unit 3: Cell References
6 Items
3.1
Relative Reference
3.2
Absolute Reference
3.3
Mixed Reference
3.4
$ symbol ka use
3.5
F4 key se reference change karna
3.6
Formulas mein cell references ka use
Unit 4:Named Cells & Ranges
6 Items
4.1
Name kya hai
4.2
Cell/Range ko name dena
4.3
Define Name
4.4
Name Box
4.5
Named Range ka formula mein use
4.6
Named cells/ranges ko manage karna
Unit 5: Basic Excel Practical Theory
10 Items
5.1
Total Marks
5.2
Sorting
5.3
Minimum & Maximum
5.4
Student Report
5.5
Rows/Columns insert aur delete
5.6
Find option
5.7
Worksheets ka use
5.8
Grade
5.9
Percentage
5.10
Result
Unit 6: Fee Calculation
9 Items
6.1
Course Fee
6.2
Admission Fee
6.3
Prospectus Fee
6.4
Examination Fee
6.5
Tax Calculation
6.6
Installment Calculation
6.7
Lump Sum Payment
6.8
Discount Calculation
6.9
SUM ke different methods
Unit 7: Conditional Formatting
5 Items
7.1
Conditional Formatting kya hai
7.2
Conditions ke basis par formatting
7.3
Values ko highlight karna
7.4
Data analysis ke liye conditional formatting
7.5
Practical applications
Unit 8: Paste Special & Data Transformation
7 Items
8.1
Paste Special
8.2
Paste Link
8.3
Values paste karna
8.4
Formulas paste karna
8.5
Formatting paste karna
8.6
Transpose
8.7
Row ko Column aur Column ko Row mein convert karna
Unit 9: Data Analysis Functions
5 Items
9.1
AVERAGE
9.2
MAX
9.3
MIN
9.4
Different data ranges par calculations
9.5
Practical data analysis
Unit 10: Fill Handle & Fill Series
7 Items
10.1
Fill Handle
10.2
Auto Fill
10.3
Fill Series
10.4
Number Series
10.5
Date Series
10.6
Linear Series
10.7
Growth Series
Unit 11: Sorting
5 Items
11.1
Sorting kya hai
11.2
Ascending Order
11.3
Descending Order
11.4
Multiple-column sorting
11.5
Data ko organize karna
Unit 12: Filtering
7 Items
12.1
AutoFilter
12.2
Custom AutoFilter
12.3
Filtering by criteria
12.4
Advanced Filter
12.5
Criteria Range
12.6
AND condition
12.7
OR condition
Unit 13: Data Validation
4 Items
13.1
Data Validation kya hai
13.2
Data entry restrictions
13.3
Criteria based data entry
13.4
Valid data maintain karna
Unit 14: Goal Seek & Scenarios
5 Items
14.1
Scenarios
14.2
Different conditions ke according result analysis
14.3
Goal Seek
14.4
Financial calculations mein Goal Seek
14.5
Target value find karna
Unit 15: Pivot Tables
6 Items
15.1
Pivot Table kya hai
15.2
Pivot Table create karna
15.3
Data summarize karna
15.4
Rows aur Columns mein fields arrange karna
15.5
Values ka calculation
15.6
Pivot Table sorting
Unit 16: Two-Dimensional Pivot Table
5 Items
16.1
Row fields
16.2
Column fields
16.3
Value fields
16.4
Two-dimensional data analysis
16.5
Summary report create karna
Unit 17: Slicers
4 Items
17.1
Slicer kya hai
17.2
Pivot Table ke saath Slicer
17.3
Data filtering through Slicer
17.4
Interactive data analysis
Unit 18: Charts
9 Items
18.1
Chart kya hai
18.2
Charts ka purpose
18.3
Data ko graphical form mein represent karna
18.4
Line Chart
18.5
Column Chart
18.6
Chart data select karna
18.7
Row/Column switch karna
18.8
Legend
18.9
Data Labels
Unit 19: Combination Chart
4 Items
19.1
Combination Chart
19.2
Different chart types ko combine karna
19.3
Data comparison
19.4
Professional reporting
Unit 20: Financial & Business Analysis
6 Items
20.1
Financial Projection
20.2
Salary Analysis
20.3
Sales Analysis
20.4
Discount Calculation
20.5
Payroll Analysis
20.6
Data-based reporting
Payroll Analysis
🔹 Payroll Analysis Kya Hai?
Payroll Analysis ka matlab hai employees ki salary aur payroll-related information ko systematically calculate, verify, compare aur analyze karna.
Isme employee ki Basic Salary, Allowances, Overtime, Bonus, Deductions, Gross Salary aur Net Salary jaise components ka analysis kiya jata hai.
Simple Definition:
Employees ki salary, allowances, deductions aur net payment ko analyze karke payroll ki complete report banana Payroll Analysis kehlata hai.
1. Payroll Kya Hai?
Payroll ek system/process hai jisme company apne employees ko salary calculate aur pay karti hai.
Payroll mein generally ye information hoti hai:
Employee Name
Employee ID
Department
Basic Salary
Allowances
Overtime
Bonus
Deductions
Gross Salary
Net Salary
2. Payroll Analysis Ka Purpose
Payroll Analysis ka main purpose hota hai:
Employee salary calculate karna
Total salary expense find karna
Gross aur Net Salary calculate karna
Overtime aur bonus analyze karna
Deductions verify karna
Department-wise payroll compare karna
Payroll errors identify karna
Salary budget analyze karna
3. Payroll Ke Important Components
Component Meaning
Basic Salary Employee ki fixed/basic salary
HRA House Rent Allowance
DA Dearness Allowance
TA Travel/Transport Allowance
Overtime Extra working hours ka payment
Bonus Additional payment
Gross Salary Deductions se pehle total salary
Deductions Salary se subtract hone wali amounts
Net Salary Deductions ke baad payable salary
4. Gross Salary Calculation
Gross Salary mein basic salary ke saath applicable allowances, overtime aur bonus include kiye ja sakte hain.
Formula:
Gross Salary = Basic Salary + Allowances + Overtime + Bonus
Example:
Basic Salary = ₹30,000
HRA = ₹8,000
TA = ₹2,000
Overtime = ₹1,500
Bonus = ₹2,000
=30000+8000+2000+1500+2000
Gross Salary = ₹43,500
5. Total Deductions
Employee salary se different deductions ho sakti hain.
Example:
PF
Tax
Loan deduction
Other applicable deductions
Formula:
Total Deduction = PF + Tax + Other Deduction
Example:
PF = ₹2,000
Tax = ₹1,500
Other Deduction = ₹500
Total Deduction = ₹4,000
6. Net Salary Calculation
Net Salary employee ko payable amount hoti hai.
Formula:
Net Salary = Gross Salary – Total Deductions
Example:
Gross Salary = ₹43,500
Total Deduction = ₹4,000
Net Salary = ₹39,500
7. Excel Payroll Table
Employee Department Basic Allowance Overtime Gross Deduction Net Salary
Rahul IT ₹30,000 ₹8,000 ₹1,500 ₹41,500 ₹3,500 ₹38,000
Aman Sales ₹28,000 ₹7,000 ₹2,000 ₹37,000 ₹3,000 ₹34,000
Priya HR ₹35,000 ₹9,000 ₹1,000 ₹45,000 ₹4,000 ₹41,000
Is table se employee-wise payroll analyze kiya ja sakta hai.
8. Total Payroll Expense
Company ka total salary expense calculate karne ke liye SUM() function use kiya ja sakta hai.
Agar Net Salary H column mein hai:
=SUM(H2:H20)
Isse selected employees ki total Net Salary calculate ho jayegi.
Similarly Gross Salary ka total:
=SUM(F2:F20)
9. Average Salary
Average employee salary calculate karne ke liye:
=AVERAGE(H2:H20)
Isse company ko employees ki average net salary ka idea mil sakta hai.
10. Highest & Lowest Salary
Highest Salary:
=MAX(H2:H20)
Lowest Salary:
=MIN(H2:H20)
Isse payroll data mein highest aur lowest salary identify ki ja sakti hai.
11. Department-Wise Payroll Analysis
Payroll ko department ke according analyze kiya ja sakta hai.
Example:
Department Employees Total Payroll
IT 10 ₹4,50,000
HR 5 ₹2,00,000
Sales 8 ₹3,20,000
Accounts 6 ₹2,70,000
Pivot Table is type ke analysis ke liye useful hai.
Possible arrangement:
Rows → Department
Values → Sum of Net Salary
12. Overtime Analysis
Employees ke overtime payments ko separately analyze kiya ja sakta hai.
Example:
Employee Overtime Hours Overtime Pay
Rahul 10 ₹1,500
Aman 15 ₹2,250
Priya 5 ₹750
Isse company overtime cost ko monitor kar sakti hai.
13. Payroll Charts
Payroll data ko charts ke through bhi analyze kiya ja sakta hai.
📊 Column Chart
Department-wise salary comparison.
📈 Line Chart
Month-wise total payroll trend.
🥧 Pie Chart
Department-wise payroll share.
📊 Combination Chart
Employee count + payroll expense ko ek report mein compare karna.
14. Payroll Error Checking
Professional Payroll Analysis mein errors identify karna bhi important hai.
Check kiya ja sakta hai:
Missing employee records
Duplicate employee records
Incorrect salary values
Wrong deductions
Incorrect overtime
Incorrect calculations
Missing attendance information
Excel ke Conditional Formatting, Data Validation aur formulas is process mein helpful ho sakte hain.
15. Monthly Payroll Analysis
Payroll ko month-wise compare kiya ja sakta hai.
Month Gross Payroll Deductions Net Payroll
January ₹5,00,000 ₹40,000 ₹4,60,000
February ₹5,20,000 ₹42,000 ₹4,78,000
March ₹5,30,000 ₹43,000 ₹4,87,000
Isse salary expenses ka monthly trend samajhne mein help milti hai.
16. Payroll Analysis Ke Practical Uses
Payroll Analysis ka use:
👨💼 Employee salary management
🏢 Department-wise payroll
💰 Salary budgeting
⏰ Overtime analysis
🎁 Bonus analysis
📊 Monthly payroll reports
📈 Salary expense trends
🧾 Payroll verification
👥 Employee cost analysis
💼 HR reporting
⭐ Benefits
✅ Salary calculation organized hoti hai
✅ Payroll expenses easily track hote hain
✅ Employee-wise comparison possible hota hai
✅ Department-wise salary analysis hoti hai
✅ Overtime aur bonus monitor kiye ja sakte hain
✅ Calculation errors identify karne mein help milti hai
✅ Monthly payroll trends samajh aate hain
✅ Professional HR reports create ki ja sakti hain
Leave a Reply
Cancel reply
Save my name, email, and website in this browser for the next time I comment.
Post Comment
Modal title
Main Content
Leave a Reply