Curriculum
32 Sections
108 Lessons
27 Weeks
Expand all sections
Collapse all sections
0- Welcome to the E Accounting Diploma Course
2
1.0
Welcome to the E Accounting Diploma Course
1.1
E Accounting Diploma Course Structure
Excel 1- Introduction to excel
7
2.0
Lesson 1.1- What is excel?
2.1
Lesson 1.2- What kind of work excel does?
2.2
Lesson 1.3- What are columns, rows and cells?
2.3
Lesson 1.4- Insert values in a cell
2.4
Lesson 1.5- Basic cell reference & practice
2.5
Lesson 1.6- What are workbook & worksheets
2.6
Lesson 1.7- Tabs & Ribbons
Excel 2- Save workbook
1
3.0
Lesson 2.1- Save workbook
Excel 3- Basic data & formula
1
4.0
Lesson 3.1- Basic data & formula
Excel 4- What is syntax?
1
5.0
Lesson 4.1- What is syntax?
Excel 5- Mathematical Functions Part I
12
6.0
Lesson 5.1- SUM syntax essentials
6.1
Lesson 5.2- SUM syntax practical
6.2
Lesson 5.3- MAX syntax essentials
6.3
Lesson 5.4- MAX syntax practical
6.4
Lesson 5.5- MIN syntax essentials
6.5
Lesson 5.6- MIN syntax practical
6.6
Lesson 5.7- AVERAGE syntax essentials
6.7
Lesson 5.8- AVERAGE syntax practical
6.8
Project 1- Ques: Sales Performance Dashboard
6.9
Project 1- Solution: Sales Performance Dashboard
6.10
Project 2- Ques: Budget Tracker
6.11
Project 2- Solution: Budget Tracker
Excel 6- Mathematical Functions Part II
8
7.0
Lesson 6.1- LARGE syntax essentials
7.1
Lesson 6.2- LARGE syntax practical
7.2
Lesson 6.3- SMALL syntax essentials
7.3
Lesson 6.4- SMALL syntax practical
7.4
Project 1- Ques: Top 5 Sales Performance
7.5
Project 1- Solution: Top 5 Sales Performance
7.6
Project 2 – Ques: Small Inventory Level
7.7
Project 2 – Solution: Small Inventory Level
Excel 7- Mathematical Functions Part III
3
8.0
Lesson 7.1- Basic of RANK syntax
8.1
Lesson 7.2- Create marksheet with RANK syntax
8.2
Lesson 7.3- Absolute & Relative reference [MOST IMPORTANT]
Excel 8- Logical Function Part I
4
9.0
Lesson 8.1- IF syntax essentials & practical
9.1
Lesson 8.2- NESTED IF syntax essentials & practical
9.2
Project 1- Ques: 26 Conditions
9.3
Project 1- Solution: 26 Conditions
Excel 9- Mathematical Functions Part IV
14
10.0
Lesson 9.1- SUMIF syntax essentials
10.1
Lesson 9.2- SUMIF syntax practical
10.2
Project 1- Ques: Sales Performance Analysis
10.3
Project 1- Solution: Sales Performance Analysis
10.4
Lesson 9.3- AVERAGEIF syntax essentials
10.5
Lesson 9.4- AVERAGEIF syntax practical
10.6
Project 2 – Ques: Customer Satisfactions Survey
10.7
Project 2 – Solution: Customer Satisfactions Survey
10.8
Lesson 9.5- COUNT syntax essentials & practical
10.9
Lesson 9.6- COUNTA syntax essentials & practical
10.10
Lesson 9.7- COUNTIF essentials & practical
10.11
Lesson 9.8- COUNTIF practical with name manager
10.12
Project 1- Ques: Customer Segmentation
10.13
Project 1- Solution: Customer Segmentation
Excel 10- Mathematical Functions Part V
10
11.0
Lesson 10.1- SUMIFS syntax essentials & practical
11.1
Lesson 10.2- SUMIFS syntax practical with name manager
11.2
Project 1- Ques: Analyze Financial Performance
11.3
Project 1- Solution: Analyze Financial Performance
11.4
Lesson 10.3- AVERAGEIFS syntax essentials & practical
11.5
Lesson 10.4- AVERAGEIFS syntax practical with name manager
11.6
Project 2- (Ques): Analyze Financial Performance
11.7
Project 2- (Solution): Analyze Financial Performance
11.8
Lesson 10.5- COUNTIFS syntax essentials & practical
11.9
Lesson 10.6- COUNTIFS syntax practical with name manager
Excel 11- Date & Time Function
1
12.0
Lesson 11.1- NOW(), TODAY(), DAYS360 & YEARFRAC() Syntax Essentials & Practical
Welcome To Tally.ERP9 Section
1
13.0
Welcome To Tally.ERP9 Section
Tally.ERP9 - 1. Learn Accounting First
4
14.0
Lesson 1.1- Nature of accounting
14.1
Lesson 1.2- Husband wife relationship
14.2
Lesson 1.3- Modern rules of accounting
14.3
Lesson 1.4- Four steps in accounting
Tally.ERP9 - 2. Basic Accounting Entries
3
15.0
Lesson 2.1- Basic accounting entries
15.1
Lesson 2.2- Basic accounting entries
15.2
Lesson 2.3- Basic accounting entries
Tally.ERP9 - 3. Advance Accounting
1
16.0
Lesson 3.1- Advance accounting concept
Tally.ERP9 - 4. Download Tally ERP9
1
17.0
Lesson 4.1- Download Tally ERP9
Tally.ERP9 - 5. Create Company In Tally ERP9
1
18.0
Lesson 5.1- Create company in Tally.ERP9
Tally.ERP9 - 6. Advance Accounting Concept Part 2
1
19.0
Lesson 6.1- Advance accounting concept part 2
Tally.ERP9- 7. Contra Vouchers
3
20.1
Lesson 7.1- Contra vouchers logics
20.2
Lesson 7.2- Contra vouchers ledgers
20.3
Lesson 7.3- Contra vouchers entries
Tally.ERP9- 8. Payment Vouchers
3
21.1
Lesson 8.1- Payment vouchers logics
21.2
Lesson 8.2- Payment vouchers ledgers
21.3
Lesson 8.3- Payment vouchers entries
Tally.ERP9- 9. Receipt Vouchers
3
22.1
Lesson 9.1- Receipt vouchers logics
22.2
Lesson 9.2- Receipt vouchers Ledgers
22.3
Lesson 9.3- Receipt vouchers Entries
Tally.ERP9- 10. Journal Vouchers
3
23.1
Lesson 10.1- Journal vouchers logics
23.2
Lesson 10.2- Journal vouchers Ledgers
23.3
Lesson 10.3- Journal vouchers Entries
Tally.ERP9- 11. Purchase Vouchers
3
24.1
Lesson 11.1- Purchase Voucher Logics
24.2
Lesson 11.2- Purchase Voucher Ledgers
24.3
Lesson 11.3- Purchase Voucher Entries
Tally.ERP9- 12. Sale Vouchers
3
25.1
Lesson 12.1- Sale voucher logics
25.2
Lesson 12.2- Sale voucher ledgers
25.3
Lesson 12.3- Sale voucher entries
Tally.ERP9- 13. Debit Note Vouchers
2
26.1
Lesson 13.1- Debit note voucher logics
26.2
Lesson 13.2- Debit note vouchers entries
Tally.ERP9- 14. Credit Note Vouchers
2
27.1
Lesson 14.1- Create note voucher logics
27.2
Lesson 14.2- Credit note vouchers entries
Tally.ERP9- 15. Export Balance Sheet In PDF, Image and Excel
1
28.1
Lesson 15.1- Export Balance Sheet
Welcome To The MIS Section
1
29.1
Welcome To The MIS Section
MIS- 1. What is Payhead & Download Files
2
30.1
Lesson 1.1- What are pay heads?
30.2
Lesson 1.2- Download excel payroll files
MIS- 2. Raw Data Section
3
31.1
Lesson 2.1- Understand Payroll Data
31.2
Lesson 2.2- Prepare raw data sheet
31.3
Lesson 2.3- Prepare raw data dashboard
MIS- 3. Payroll sheet & Pay slip
3
32.1
Lesson 3.1- Prepare payroll sheet
32.2
Lesson 3.2- Payroll sheet dashboard
32.3
Lesson 3.3- Pay Slip
E Accounting Diploma Course
Search
E Accounting Diploma Course Structure
https://unitedtechera.com/wp-content/uploads/2025/01/compress-COURSE-STRUCTUCTURE-FINAL-OUTPUT.mp4
Content Protected!
The content of this website cannot be copied!
Modal title
Main Content