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
This content is protected, please
login
and enroll in the course to view this content!
Content Protected!
The content of this website cannot be copied!
Modal title
Main Content