We found 1 course available for you

Excel for Financial Reporting: Preparation of Financial Statements

1 Lesson
2 hours

Financial statements serve as crucial tools for assessing the financial …

What you'll learn
Designing Chart of Accounts in Excel
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
Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar