Excel for Financial Reporting: Preparation of Financial Statements
Financial statements serve as crucial tools for assessing the financial …
What you'll learn
Designing Chart of Accounts
Table Formatting for Journal Posting
Data Validation for COA List
Understanding Data source
Creating Pivot Table for Ledger Report
Customizing and Designing Pivot Table
Pivot Table Analize
Creating Slicer for Individual Ledger Report automatically
Automate Trial Balance by Pivot Table
Creating Profit and Loss account by using Vlookup
Creating Balance Sheet by using Vlookup
- Accounting Golden rules
- Double entry bookkeeping system (Debit and Credit)
- Ledgers or Chart of Accounts
- Bill, Invoice, Accounts Payable and Accounts Receivable
- Financial reports (P/L accounts and Balance sheet)
- Assets, Depreciation and Liability