Digital Accounting & AI for accounting and finance LMS Video Course
About Course
Accounting software සහ Advanced Excel ඉගෙන ගෙන රැකියා වෙළඳපොලේ ඔබේ ඉල්ලුම වැඩිකර ගන්න.
එකම පාඨමාලවෙන් Digital Accounting skill 05 ක් ලබා ගන්න.
ගණකාධිකාරි වරයකු හෝ මුල්ය අංශයේ රැකියාවක් බලාපොරොත්තු වන හෝ දැනට නිරත ඔබ විසින් ලබා ගත යුතුම practical Digital Accounting skill 04 ක් මෙම පාඨමාලාව තුලින් ආවරණය කෙරේ.
AI for Accounting and finance SkillDesktop Accounting software skillCloud Accounting software SkillAccounting data Analyze and Visualization 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
Start with course introduction video(Must Watch)
-
Course introduction video
05:50
Practical Tutes For Course(All your Tutes Available here/This is pdf tutes)
-
How to download your tute & Excel works books(Must watch)
03:42 -
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 -
Excel basic to advanced level Excel work books tute
00:00 -
Excel expert level for Accounting and finance woks books tute
00:00
Lesson 01: Introduction to Digital Accounting system(Theory)
-
Lesson PDF tute
-
Introduction
02:21 -
What is Accounting information system(AIS)
05:23 -
Early Accounting History
03:29 -
Accounting Technology Evolution
04:26 -
Manual Accounting system
00:40 -
Computerized Accounting system
10:56 -
Digital Accounting system
12:42 -
AI Accounting system
-
Book keeping VS Digital Book keeping
-
Accounting & System Terms cheat sheet
Lesson 02: How you start your Accounting With Software.(Accounting process with all softwares)
-
Your tute PDF
-
your tute PPT PDF
-
Accounting process with any Accounting software.
10:08
Lesson 03:Quick Books Desktop *2024* New update (Start your Software skill )
-
Your practical Tute here
-
QB desktop software installation part 01
09:28 -
How to start your QB desktop software after instaled.
01:01 -
01.Create company Accounting file in system
09:01 -
02.QB desktop menu overview
05:19 -
03.QB Desktop preferences setting
05:08 -
04.Chart of Account- Introduction
06:50 -
04.1 Chart of Account- Build your Fixed Assets list
12:43 -
04.2 Chart of Account- Build your current Assets list
08:55 -
04.3 Chart of Account- Build your Liability & Equity Account list
10:30 -
04.4 Chart of Account- Managing your Accounts List(Edit,delete,inactive)
08:38 -
04.5 Chart of Account- Must run report(Account list/TB/GL/BS)
08:50 -
04.6 Chart of Account- Necessary Accounts creation (Income & Expensess)
12:17 -
04.7 Chart of Account- VAT account creation(sales Tax)
08:43 -
04.8 Chart of Account- Build your Credit card account
03:25 -
05.Vendor Accounting system- Introduction
06:56 -
05.1 Vendor Accounting system- opening balances
22:39 -
05.2 Vendor Accounting system- Vendors reports
04:56 -
06.Debtors Accounting system- Introduction
02:38 -
06.1 Debtors Accounting system- Crete your debtors system
13:49 -
06.2 Debtors accounting system-Debtors required reports
04:41 -
06.3 Debtors accounting system-Review your Accounts receivable Account
01:08 -
7.Stock Accounting system-Inventory introduction
07:57 -
7.1 Stock Accounting system-Inventory products opening balances
15:35 -
7.2 Stock Accounting system-Inventory reports
05:09 -
7.3 Stock Accounting system- Service Inventory creation
-
7.4 Stock Accounting system-Identify opening balances duplicate amounts
03:25 -
8.Purchase system – introduction
08:04 -
8.1 Purchase system – purchase order system
11:04 -
8.2 Purchase system – purchase order converted to bill
14:45 -
8.3 Purchase system – Cash purchase
06:29 -
8.4 Purchase system – Cheque purchase
03:12 -
8.5 Purchase system – Credit card purchase
07:17 -
8.6 Purchase system – purchase Edit process
04:25 -
8.7 Purchase system – purchase Edit process
04:55 -
9. Purchase system – pay vendor bill
16:54 -
10. Purchase system – purchase Return
06:16 -
11.purchase process- Cheque return-cheque bounced
06:15 -
11.1 Purchase system -Purchase process in one video
08:53 -
12.Sales Accounting system-Introduction
03:36 -
12.1 Sales Accounting system- Sales invoice process without Estimate
11:14 -
12.1 Sales Accounting system-Cash sales VS cheque Sales
09:22 -
12.2 Sales Accounting system-Create Estimate
08:01 -
12.3 Sales Accounting system-Service sales transactions
-
12.4 Sales Accounting system-Sales reports
06:09 -
13.Entering Receipt(Customers payment for sales)
14:37 -
14.Entering bank deposit
06:26 -
15.Entering sales return in QBD
05:17 -
16.How to pay Accruals
12:12 -
17.How to pay Day to Expenses
12:36 -
18.Credit Expenses VS Cash Expensess
-
19.Journel entry Accounting system -Introduction
04:05 -
19.1 Journal entry Accounting system -Month end closing
19:48 -
20.How to enter Day to day Income in QBD
19:01 -
21.Bank Reconciliation in QBD
-
22.Petty cash Agreement in QBD
15:51 -
23.Bank transfer in QBD
05:15 -
24.How to create Service Expenses in QBD
-
25.How to create re-curing Transactions in QBD
13:30
Lesson 03: Quick Books Desktop Accounting- 2018(OLD)
-
importance note
01:03 -
Software Trail Download and Installation-QB Desktop
09:28 -
How to start your QBD software after installed.
01:01 -
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:15 -
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:37 -
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 (cheque*)
13:49 -
Customers payment receipt by -credit card (new*)
13:18 -
customers payment receipt by online banking(new*)
16:18 -
purchase return in QB
11:56 -
Sales return in Quick Books
10:33 -
Accounting for Accruals payments
13:00 -
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:31 -
import data in Quick books
25:10 -
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:13 -
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:07 -
how to analyze Report part in QB
10:16 -
Company SNAPSHOT
05:13 -
How to re-active software after 30 days trail completed
12:37
Lesson 04: MYOB Software for Accounting
Learn and master MYOB basic to advanced
-
MYOB Course Material – Download IT
-
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:12 -
VAT Account creation
05:49 -
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:35 -
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:15 -
Bad Debts in MYOB
14:32 -
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
Lesson 05: 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
Lesson 06: SAGE 50 Accounting
-
Sage software install process video 1
08:32 -
sage software installation video 02
04:02 -
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:42 -
purchase transactions in Sage 50
28:53 -
how to pay vender bill in sage 50
17:29 -
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:36 -
sales return in sage 50
05:23 -
how to pay accruals in sage 50
09:21 -
How to pay day to day expenses by cash or bank
09:15 -
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:45 -
petty cash transactions in SAGE 50 accounting
16:34 -
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:32 -
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:19
Lesson 07:XERO CLOUD Accounting
-
start Xero Accounting with login creation
12:28 -
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:28 -
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:41 -
sales transactions in xero
41:29 -
Entering Receipt From Debtors in xero
25:55 -
Sales return in xero
13:47 -
accounting for accruals in xero
14:56 -
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:34
Lesson 08: 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:16 -
create necessary accounts in quick books online
05:46 -
VAT Account creation
02:38 -
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:11 -
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:22 -
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:14 -
How to re-store Back up file
01:36 -
customize the look and color scheme in QB
02:27 -
Icon Name changers
00:00
Lesson 09: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:18 -
setting up venders accounting system & opening balances
19:37 -
setting up debtors accounting system and opening balance
15:38 -
Inventory items(stocks)creation in zoho Books
14:46 -
service Items creation in zoho Books
11:18 -
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:45 -
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
Lesson 10:Fresh Books Accounting
-
Fresh books software installation and trail Activation
14:01 -
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:21 -
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:55 -
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
Lesson 11: Excel Basic To Advanced Excel for Accounting(2021* new update 15/04/2026 onward)
-
1. Basic Data Entry – Introduction
06:48 -
1.1 Basic Data Entry – Enter your Accounting data
00:00 -
1.2 Basic Data Entry -Alignment
10:21 -
1.3 Basic Data Entry – Select and Edit data
00:00 -
1.4 Basic Data Entry-Basic calculation
00:00 -
1.5 Basic Data Entry-Basic Formatting
00:00 -
1.6 Basic Data Entry-Custom formatting
00:00 -
2.Work book and Work sheet Management
22:30 -
3.Essential formulas in accounting & Finance
20:33 -
4.Referencing in Accounting works
13:40 -
05.Filter and sort in Accounting and finance
12:43 -
06.Table in Accounting and Finance
11:35 -
07.Conditional Formatting lesson 1
11:31 -
7.1 Conditional Formatting-Rule 1
04:01 -
7.2 Conditional Formatting – RULE 02
01:33 -
7.3 Conditional Formatting- Rule 03
01:23 -
08.IF-introduction
04:04 -
8.1 IF-VAT calculation
02:54 -
8.2 IF- Payee Tax calculation
01:50 -
8.3 IF-Bank interest calculation
01:54 -
8.4 IF- Expenses Variables
03:16 -
8.5 IF- Doubtful Debtors
03:54 -
8.6 IF-Audit flag
03:47 -
8.7 IF-AND
02:23 -
8.8 IF-OR
03:19 -
09.-LOOKUP INTRODUCTION
04:03 -
9.1 Lookups- VLOOKUP
28:33 -
9.2 -VLOOKUP in Accounting
10:20 -
9.3 Xlookup in Accounting
05:16 -
10.Date and Time function in Accounting
09:47 -
11.text function-data cleaning
26:23 -
12.1 Conditional Analyze- Sum,sumif,sumifs in Accounting
09:41 -
12.2 Conditional Analyze-Count IF & Count IFs
08:51 -
12.3 Conditional Analyze- Avarage IF & Avarage IFS
08:28 -
13.pivot table
25:50 -
14.Charts for Accounting & Finance
35:04 -
15.Quick Analyze Tool
07:14 -
16.macro In accounting
08:30 -
1.7 Basic Data Entry-Format painter
04:38
Lesson 11: EXCEL Basic to Advanced Level For Accounting and finance(OLD 2016)
-
course introduction video
05:44 -
How to download your Excel workbooks
02:50 -
introduction to MS excel
59:45 -
Basic data entry in Accounting and finance practice
10:06 -
Row column and Print Excel
11:54 -
working with work sheet
11:38 -
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:20 -
Excel work with view
15:45 -
conditional formatting in Accounting -BASIC(with excel work book)
06:41 -
conditional formatting with NEW RULE – 01
04:02 -
conditional formatting with NEW RULE – 02
01:33 -
conditional formatting with NEW RULE – 03
01:23 -
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- Introduction for Accounting Tasks(with excel tute here)
01:31 -
IF- VAT calculation
02:54 -
IF-Bank interest income calculation
01:54 -
IF-Expenses control(Budget variance)
03:16 -
IF-Accounting provision for Doubtful debts
03:54 -
IF- For Audit flags
03:47 -
IF function in excel more- Not compulsory to learn Bonus video
28:16 -
SUM-SUMIF-SUMIFS Use in Accounting- 01
05:18 -
Sum, sumIF, Sumifs use in Accounting and finance- 02
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:30 -
HLOOKUP AND INDEX in Accounting and finance
16:07 -
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:49 -
Short and filter in Excel
30:42 -
Reference formula in Excel
10:38 -
Auto fill and customer list
12:00 -
Charts in Excel
35:29 -
FREZER PANES IN accounting and finance
07:54 -
Groups in Accounting
06:38 -
Protect sheets in Accounting
02:49 -
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:03 -
insert object in excel
06:16 -
Dash bords
00:00 -
short cut key in excel
00:00 -
short cut key to accountant
00:00
Lesson 12: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:24 -
Develop chart of account and Genaral ledger
15:46 -
Prepare Trail balance and Income statement in excel
36:37 -
prepare Balance sheet in excel
38:47 -
Finance statement preparation with PIVOT Table in excel
29:14 -
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:32 -
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:18 -
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:07
Lesson 13:.Power BI for Accounting & Finance(Active now)
-
Power BI Excel works sheet(pls download)
-
How to download Power BI Desktop to Your PC
02:32 -
01.Understanding Accounting Data For Power BI Analyze (GL,chart of Account,date Calender)
07:06 -
02.How to get data in to power BI
13:08 -
03.Analyze sales income using Power BI
09:07 -
04.formatting matrixes
08:46 -
05.Analyze sales by quarter and months
08:29 -
06.Visualizing sales trend with charts
10:31 -
07.Slicer for sales analyze
03:47 -
Download Excel file for income statement(Download pls)
-
08.income statement – Get your data for income statements(P & L) Analyze
07:04 -
09.income statement – Models link for Income statement( P & L ) analyze
13:32 -
10. income statement – Prepare your income statements (P & L )
-
11.income statement – Sub total for your income statement.
01:42 -
12.Income statement – Gross profit creation
07:42 -
13.Income statement – operating profit creation
02:31 -
14.Income statement – PBIT creation
01:38 -
15.Income statement – Net profit creation
01:58 -
16.Income statement – CARD use for Visualization numbers
07:19 -
17.Income statement – KPI visual for income statements
06:42 -
18.Income statement – Adding Basic visuals for income statement
12:52 -
19.Income statement – Slicer for analyze
03:33 -
Income statement : Analyze with DAX method
-
20.Income statement : Visualization VS DAX method
04:07 -
21.Income statement : DAX Introduction
03:09 -
22.Income statement : Difference visualization vs DAX method
02:51 -
23.Income statement : DAX sum for the period
09:43 -
24.Income statement : DAX Gross profit
09:17 -
25.Income statement : DAX net profit
07:44 -
26.Income statement : Dax operating profit
10:24 -
27.Income statement : Dax Sales
05:52 -
28.Income statement : Sales,GP,NP Visualization with DAX
04:05 -
29.Income statement : Adding small multiple charts
02:14 -
30.Income statement : Marketing Expenses VS Sales comparison Visualization
04:51 -
31.Income statement : Marketing Expenses VS Sales Visualization charts
01:57 -
32.Income statement : Gross profit margin and Net profit margin
05:45 -
33.Income statement : Format your visualization
02:54 -
34.Finance position statement: What is Min date & Max date
02:37 -
35.Finance position statement: find Min Date and Max date
07:05 -
36.Finance position statement: Min date across
05:55 -
37.Finance position statement: Min date across
07:00
Lesson 14:Tableau for Accounting and finance(active soon)
Lesson 15: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
Lesson 15:Basic Excel for beginners(only for beginners)
-
basic excel
41:38
Lesson 15:Basic power point for beginners
-
basic power point
22:47
Lesson 16:How to Get Your printed certificate(Final Achivement)
-
Assignment demo video
16:56 -
Assignment word file
-
email address : assingmentltc@gmail.com
Student Ratings & Reviews
No Review Yet