Computerized Accounting and Advanced Excel LMS Video Course
About Course
Accounting software සහ Advanced Excel ඉගෙන ගෙන රැකියා වෙළඳපොලේ ඔබේ ඉල්ලුම වැඩිකර ගන්න.
එකම පාඨමාලවෙන් Digital Accounting skill 04 ක් ලබා ගන්න.
ගණකාධිකාරි වරයකු හෝ මුල්‍ය අංශයේ රැකියාවක් බලාපොරොත්තු වන හෝ දැනට නිරත ඔබ විසින් ලබා ගත යුතුම practical Digital Accounting skill 04 ක් මෙම පාඨමාලාව තුලින් ආවරණය කෙරේ.
Desktop Accounting Software SkillCloud Accounting software SkillAdvance Excel Data analysis skillMs Word and power point skill for accountingCourse content of this course
පාඨමාලා අන්තර්ගතය යටතේ පහත කොටස් ආවරණය කෙරේ .
………………………………………………………………………..
Computerized Accounting systemDigital Bookkeeping for businessMYOB software for AccountingQuick books desktop for AccountingTALLY ERP for AccountingSage 50 for AccountingXero AccountingQuick books online cloud AccountingZoho Books online cloud AccountingFresh books online Cloud AccountingBasic to Advance Excel for AccountingMs advance word for AccountingMs power point for AccountingOut come of this course
මෙම පාඨමාලාව සාර්ථකව නිමකල සිසුන් හට පහත නිපුණතාව ලබා ගත හැකි වේ.
………………………………………………………………………..
Record daily business transactions in Accounting system(එදිනෙදා ආයතනයක ගිණුම් කටයුතු පරිගණක පද්ධතිය ක ගිණුම් ගත කිරීම )Prepare final Accounts using Softwares(මෘදුකාංග මගින් අවසාන ගිණුම් සැකසීම )Reconciliation Accounting(බැංකු සැසදුම් සැකසීම )Set up and operate an intergrated accounting program for business(වියාපාරයක් සදහා ගිණුම් කරන මෘදුකාංග ප්‍රායෝගික යෙදවීම )Advanced excel features for Accounting(Basic and advance excel ගිණුම් කරන කටයුතු වලට යෙදවීම )…………………………………………………………………………
Why you need to learn from LTC academy
ඔබ විසින් අප ආයතනය තෝරා ගත යුත්තේ ඇයි?
…………………………………………………………………………
️Best Accounting software and Advance Excel training institute in srilanka.️Training by industry expert professional who have more than 10 years experience️Individual attention to each students️Small batch size 10-15️100% practical training…………………………………………………………………………
Course certificate
…………………………………………………………………………
පාඨමාලාව අවසානයේ ලබා දෙන Assignment එක complete කර ඉදිරිපත් කරන සිසුන් සදහා සහතික පත් 02 ක් පිරිනැමේ.
Certificate 01: Computerized Accounting and book keeping certificateCertificate 02: Advanced Ms Excel for data Analysis certificate………………………………………………………………………..
පාඨමාලාව හැදෑරීමට මුලික දැනුමක් අවශ්‍ය නොවේ.මුල සිට සරලව ආරම්භ වේ.පාඨමාලා ගාස්තුව වාරික ලෙස ගෙවිය හැකි වේ.Accounting software trail සහ නිබන්දන නොමිලේ ලබා දේ.තමන්ට කැමති වේලාවක ආරම්භ කල හැකි වේ.LMS system එකක් මගින් සියලුම කොටස් video ලෙස life time ලබා දේ.What Will You Learn?
- Computerized Accounting system
- Digital Bookkeeping for business
- MYOB software for Accounting
- Quick books desktop for Accounting
- TALLY ERP for Accounting
- Sage 50 for Accounting
- Xero Accounting
- Quick books online cloud Accounting
- Zoho Books online cloud Accounting
- Fresh books online Cloud Accounting
- Basic to Advance Excel for Accounting
- Ms advance word for Accounting
- Ms power point for Accounting
Course Content
course introduction and Guidelines(Demo Video before you start)
please read carefully and follow the guidelines
-
introduction video
05:22
Practical Tutes For Course(All your Tutes Available here/This is pdf tutes)
-
Computerized Accounting System Tute
00:00 -
Digital Book Keeping Tute
00:00 -
MYOB Tute
00:00 -
Quick Books Tute
00:00 -
TALLY TUTE
00:00 -
SAGE 50 tute
00:00 -
XERO Accounting Tute
00:00 -
QUICK books online Tute
00:00 -
ZOHO books Tute
00:00 -
Fresh Books Tute
00:00 -
Basic Word and Power Point
00:00 -
Excel basic to advanced level Excel work books tute
00:00 -
Excel expert level for Accounting and finance woks books tute
00:00
LEVEL 01: INTRODUCTION OF COMPUTERBASED ACCOUNTING(TOPIC 01)
1. 1 Computerized Accounting system(course start here 1)
-
What is Computerized Accounting?
44:09
1. 2 Digital Book keeping(Course start here 2)
in this topic you can take theory knowledge of Digital book keeping.
-
what is the Digital Book keeping
45:44
LEVEL 02: DESKTOP ACCOUNTING SOFTWARE SKILL(TOPIC 2)
2.1 .MYOB Software for Accounting(Start your 1st software practice)
Learn and master MYOB basic to advanced
-
introduction and Software installation of MYOB Accounting
05:38 -
Company file creation and Trail Balance
39:48 -
Start with currency changes in system and reports
02:02 -
how to re-open your company file next time(must watch)
02:11 -
VAT Account creation
05:48 -
open your system easy set up Assistance
02:05 -
setting up venders accounting system & opening balances
19:17 -
setting up debtors accounting system
24:44 -
stock accounting in MYOB
36:47 -
Accounting for purchasing
49:39 -
payment to creditors
19:36 -
sales transactions in MYOB
43:52 -
Payment to Debtors
15:07 -
purchase return in MYOB
14:49 -
Entering sales return
05:10 -
Accounting for Accruals payments
14:34 -
Accounting for day to day Expensess
16:34 -
accounting for day to day incomes received
10:07 -
Journal entry system in myob
11:12 -
Bank reconciliation in MYOB
44:36 -
Accounting for service revenue in myob
10:26 -
Fund transfer in MYOB
03:09 -
Void checks in MYOB
12:14 -
Bad Debts in MYOB
14:33 -
Petty cash Accounting in MYOB
12:46 -
Re-curing Transactions in MYOB
10:36 -
Year end adjustment in MYOB
04:18 -
Fixed Assets Register
23:26
2.2 Quick Books Desktop Accounting(Start your 2nd software practice)
-
Software Trail Download and Installation-QB Desktop
19:24 -
start and create company file in QB Desktop software
08:49 -
set up company file in quick books desktop
18:35 -
System Requirement and Preferences in QB desktop
07:16 -
Setting up Assets, Liability, Equity Accounts and Trail Balance
38:46 -
Necessary Accounts Creation in qb
03:10 -
setting up venders accounting system & opening balances
23:45 -
setting up debtors accounting system and opening balance
14:36 -
stock accounting System and opening Balances creation
23:33 -
purchasing Transactions
55:14 -
payment to creditors
17:49 -
sales transactions in QB
41:20 -
Entering Receipt From Debtors in QB
13:49 -
purchase return in QB
11:56 -
Sales return in Quick Books
10:33 -
Accounting for Accruals payments
12:59 -
Accounting for day to day Expensess
11:01 -
Journal entry system in QB Desktop
11:51 -
accounting for day to day incomes received
07:58 -
Bank reconciliation in QB desktop
22:24 -
Petty cash Accounting in QB desktop
14:21 -
Bank transfer in QB
05:13 -
How to create service revenue in Quick books Desktop
14:46 -
How to create re-curring transactions
14:11 -
Find Transactions in QB desktop
07:23 -
Multiple entries in quick books desktop
12:41 -
multi currency features in QB desktop
03:30 -
import data in Quick books
25:09 -
Export data in Quick books
25:10 -
creating users and Roles
11:24 -
Manufacturing Accounts in Quick books Desktop
36:28 -
Bad Debts in QB desktop
07:15 -
Branch Accounting In QB Desktop
08:11 -
Fixed Assets Register and Depriciation
27:33 -
Backup in QB
05:14 -
How to re-store backup file
01:36 -
customize the look and color scheme of qb
02:26 -
icon name change in QB
03:01 -
Make deposit in QB
10:08 -
how to analyze Report part in QB
10:16 -
Company SNAPSHOT
05:13
2.3 TALLY ERP Accounting
-
How to download and install TALLY Trail
05:08 -
Company file creation and Trail Balance creation
48:13 -
TALLY necessary accounts creation
05:29 -
stock accounting System and opening Balances creation
38:00 -
purchasing Transactions
45:09 -
sales transactions in TALLY
25:26 -
purchase return system configuration
04:12 -
Accounting for purchasing return
06:30 -
Accounting for Sales return
04:06 -
payment to creditors system configurations
01:37 -
Accounting for payment to cretitors
10:29 -
Accounting for receipt from customers
13:46 -
Accounting for Accruals payments
03:10 -
Accounting for day to day Expensess
06:50 -
accounting for day to day incomes received
09:03 -
journal entry in TALLY
07:31 -
Accounting for Assets Purchasing
04:25 -
petty cash in tally
09:13 -
Bank reconciliation in Tally
21:25 -
Books and Register in TALLY
05:32 -
Recurring Transaction in TALLY
01:59 -
Bill, Invoice customize
07:41 -
Ratio Analysis in TALLY
01:37
2.4 SAGE 50 Accounting
-
Sage software install process video 1
08:31 -
sage software installation video 02
04:01 -
System Changes in Sage 50
02:31 -
sage50 introduction,Trail Balance,Necessary Accounts creation
54:14 -
creditors system, Debtors system and Stock system Creation
01:05:41 -
purchase transactions in Sage 50
28:53 -
how to pay vender bill in sage 50
17:30 -
sales transactions in sage 50
26:55 -
Sales Quotation/convert quotation to sales order/sales order to Invoice
00:00 -
Accounting for Debtors payment for credit sales
12:48 -
purchase return in sage 50
09:35 -
sales return in sage 50
05:22 -
how to pay accruals in sage 50
09:20 -
How to pay day to day expenses by cash or bank
09:14 -
How to enter day to day income received to bank or cash account
11:34 -
Journal entry in SAGE accounting system
10:02 -
Accrued expenses and pre-paid Expenses
20:11 -
Bank reconciliation in SAGE 50 Accounting
24:14 -
How to create Service revenue in SAGE 50
14:20 -
Bank transfer in SAGE Accounting
03:51 -
BAD debt in sage 50 accounting
08:44 -
petty cash transactions in SAGE 50 accounting
16:33 -
Budget creation in SAGE 50 Accounting
00:00 -
company information setting changes
05:45 -
How to create default setting for General Ledger
01:32 -
How to create default setting for Customers
01:31 -
How to create default setting for vendors
01:31 -
How to create default setting for Stocks/Inventory
02:56 -
Create Re-curing Transactions in Sage 50
08:28 -
How to save final Accounting reports in sage 50
03:18
LEVEL 03: CLOUD ACCOUNTING SOFTWARE SKILL(TOPIC 03)
3.1 XERO CLOUD Accounting
-
start Xero Accounting with login creation
12:27 -
Basic setting in Xero Accounting
28:00 -
setting up trail balance in xero accounting
55:31 -
export accounting list in xero Accounting
08:40 -
necessary accounts creation with VAT account
07:05 -
categories in xero Accounting
04:29 -
venders and opening balance creation
31:41 -
venders list import process
05:29 -
Setting up debtors and opening balances
27:44 -
stock system and service items creation
27:02 -
purchasing Transactions in xero accounting
44:55 -
Pay bill(payment to creditors for credit purchase)
35:40 -
purchase return in xero
13:42 -
sales transactions in xero
41:29 -
Entering Receipt From Debtors in xero
25:56 -
Sales return in xero
13:47 -
accounting for accruals in xero
14:57 -
pay day to day expenses in xero
14:41 -
Draft Lesson
00:00 -
Draft Lesson
00:00 -
Bank reconciliation in Xero accounting
28:37 -
Fixed Assets Register and Depriciation
23:51 -
Bank transfer in xero
04:03 -
Petty cash Accounting in xero
16:35
3.2 QUICK BOOKS CLOUD Accounting
-
quick books online trail creation 2025 update*
15:32 -
How to logging to Quick books trail version
05:01 -
main QB Online setting in system
24:11 -
Ledger Accounts, Assets, Liability, Equity creation and Trail Balnce
41:15 -
create necessary accounts in quick books online
05:45 -
VAT Account creation
02:39 -
Ledger Accounts, Assets, Liability, Equity creation and Trail Balnce
22:19 -
Creditors Accounting system
22:19 -
debtors accounting system and opening balance
17:37 -
stock accounting System and opening Balances creation
17:12 -
service stock accounting System creation
24:40 -
Accounting for purchasing
43:47 -
how to pay payments to creditors
24:17 -
sales transactions in QB online
38:40 -
Entering Receipt From Debtors in QB
10:50 -
purchase return in QB online
08:19 -
Sales return in Quick Books
04:56 -
Accounting for Accruals payments
16:05 -
day to day Expensess payment
10:39 -
Journal entry system in QB online
16:11 -
Bank reconciliation in QB online
25:30 -
Petty cash Accounting in QB Online
24:21 -
Bank transfer in QB online
00:00 -
Recurring Transaction in QB online
09:52 -
Fixed Assets Register and Depriciation
22:50 -
Back up in QUICK Books D
05:13 -
How to re-store Back up file
01:36 -
customize the look and color scheme in QB
02:26 -
Icon Name changers
00:00
3.3 ZOHO Books cloud Accounting
-
How to start with zoho books
13:49 -
How to sign up to zoho system
03:10 -
basic setting in zoho accounting
09:21 -
chart of account creation in zoho accounting
26:17 -
setting up venders accounting system & opening balances
19:37 -
setting up debtors accounting system and opening balance
15:37 -
Inventory items(stocks)creation in zoho Books
14:46 -
service Items creation in zoho Books
11:17 -
purchase transactions in Zoho books
26:44 -
payment to venders(credit bills)
31:01 -
purchase return in zoho books
06:41 -
sales transactions in zoho books
33:44 -
Customer/Debtors payment(Receipt) in Zoho Books
22:48 -
Draft Lesson
00:00 -
Accruals payment in zoho books
09:46 -
How to pay day to day expenses in Zoho Accounting
09:20 -
Journal entry in zoho accounting
00:00 -
Bank reconciliation in Zoho books
00:00
3.4 Fresh Books Accounting
-
Fresh books software installation and trail Activation
14:00 -
fresh books dash board and basic setting
16:45 -
Ledger Accounts, Assets, Liability, Equity creation and Trail Balalance part 01
00:00 -
Ledger Accounts, Assets, Liability, Equity creation and Trail Balance part 02
08:20 -
FreshBooks necessary Accounts creation
05:13 -
venders and opening balance creation
22:22 -
import/Export vender list from excel
08:14 -
setting up debtors accounting system
19:32 -
stock (inventory/Service) accounting System creation
15:30 -
purchase transactions in Fresh books
27:33 -
paying vendor bills and reports
11:05 -
purchase return in Fresh Books
00:00 -
Accounting for sales transactions
36:56 -
accounting for customer payament(Receipts in Fresh books)
11:44 -
Sales return in Fresh Books
10:33 -
Accounting for Accruals payments
00:00 -
day to day Expensess payment
16:54
LEVEL 04 : EXCEL FOR ACCOUNTING AND FINANCE(TOPIC 04)
4.1 EXCEL Basic to Advanced Level For Accounting and finance
-
course introduction video
05:44 -
introduction to MS excel
59:45 -
Basic data entry in Accounting and finance practice
10:05 -
Row column and Print Excel
11:54 -
working with work sheet
11:39 -
Excel basic works
11:16 -
Formatting Basic in Accounting
18:37 -
introduction to basic formula- Part 01
17:46 -
introduction to basic formula- Part 02
08:41 -
Basic function practice in Accounting
07:42 -
percentage use in Accounting
17:19 -
Excel work with view
15:45 -
conditional formatting in Accounting
11:15 -
conditional formatting more in Excel
11:53 -
Data Tool in Accounting and finance
30:50 -
How to use ROUND in accounting and finance
07:11 -
Tex to column and Flash fill in Accounting and finance
10:49 -
IF function in excel
28:15 -
IF Statement use in Accounting more
00:00 -
Sum,sumIF,Sumifs use in Accounting and finance
09:41 -
SUMIF,AVARAGE IF Use in Accounting and finance
08:29 -
CountIF and CountIFS use in Accounting and finance
08:51 -
LEFT,RIGHT,MID,Flashfill in Accounting and finance
11:25 -
Named Rangers in Excel
15:25 -
LOOKUP in excel
29:31 -
HLOOKUP AND INDEX in Accounting and finance
16:06 -
SUB TOTAL use in Accounting
02:32 -
QUICK ANALYZE tool use in Accounting and finance
07:14 -
SLICER use in Accounting and finance
00:00 -
TOTAL SHEET AND 3D FORMULLA use in Accounting
04:40 -
PIVOT table use in Accounting
25:50 -
Short and filter in Excel
30:42 -
Reference formula in Excel
10:37 -
Auto fill and customer list
11:59 -
Charts in Excel
35:28 -
FREZER PANES IN accounting and finance
07:54 -
Groups in Accounting
06:38 -
Protect sheets in Accounting
02:48 -
Data cleaning in advanced excel
22:46 -
How to insert Balance sheet column in Accounting
03:07 -
HYPER link in excel
18:15 -
macros in excel
08:35 -
Auditing Tool in excel
11:10 -
Basic table
11:53 -
advanced table
17:36 -
Excel function for Accounting
21:02 -
insert object in excel
06:16 -
Dash bords
00:00 -
short cut key in excel
00:00 -
short cut key to accountant
00:00
4.2 EXCEL Expert level for Accounting and finance
-
introduction Automated finance statements model
04:38 -
Develop chart of account & Posting Transactions in double entry system
31:23 -
Develop chart of account and Genaral ledger
15:46 -
Prepare Trail balance and Income statement in excel
36:38 -
prepare Balance sheet in excel
38:47 -
Finance statement preparation with PIVOT Table in excel
29:13 -
Income statement and balance sheet analyze (vertical/Horizontal)
44:29 -
Building income statement forecasting in excel
25:38 -
Building balance sheet forecasting in Excel
13:54 -
Budget creation in excel
12:52 -
Depreciation and Depreciation methods in Excel
37:31 -
present value(PV) and Future Value in Advanced Excel
39:08 -
What if analyze in excel part 01
23:13 -
What if analyze in excel part 02
11:47 -
What if analyze in excel part 03
02:14 -
What if analyze in excel part 04
06:44 -
Nominal & effective Rate of interest part 01
03:56 -
Nominal & effective Rate of interest part 02
07:53 -
Nominal & effective Rate of interest part 03
02:24 -
Loan and mortgage re-payment part 01
08:59 -
Loan and mortgage re-payment part 02
06:03 -
Loan and mortgage re-payment part 03
09:05 -
Pay back period and NPV and IRR in excel part 01
05:27 -
Pay back period and NPV and IRR in excel part 02
07:17 -
Pay back period and NPV and IRR in excel part 03
11:31 -
Pay back period and NPV and IRR in excel part 04
03:56 -
Pay back period and NPV and IRR in excel part 05
13:50 -
Pay back period and NPV and IRR in excel part 06
09:16 -
Pay back period and NPV and IRR in excel part 07
03:21 -
create account receivable and payable in excel
28:06
LEVEL 05: BASIC IT FOR ACCOUNTING AND FINANCE
5.1 Basic MS word(only for beginners)
-
basic word 1
21:54 -
basic word 2
25:51 -
basic word 3
22:31 -
basic word 4
15:36
5.2 Basic Excel for beginners(only for beginners)
-
basic excel
41:38
5.3 Basic power point for beginners
-
basic power point
22:47
LEVEL 06: ASSIGNMENTS FOR CERTIFICATE(GUIDLINES)
-
Assignment demo video
16:55
Student Ratings & Reviews
No Review Yet