Practical Accounting for Accounting Professionals & Freelance Bookkeepers
Category: Pre-Recorded Learn complete accounts set up from scratch, Enhance …
What you'll learn
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
Common accounting terminologies
Business position analysis by using Ratio Analysis
Daily cash register and bank register
Accounting, Inventory and Payroll vouchers
Simple overhead calculation
Simple selling price calculation
Cost of sale/Cost of goods sold
Inventory valuation methods
Trial balance, cash flow statement, receive & payments
Cost center and cost units
Graphical presentation of accounting data/reports
Microsoft Excel Basic to Pro
Category – Live Training Course Course Description Microsoft Excel এর …
What you'll learn
এই Course এ MS Excel এর যে সকল বিষয় শিখবেনঃ
🔹 Getting Started with Microsoft® Excel® 2019
🔹 Excel Workbook Management
🔹 Formatting Data
🔹 Orientation with Excel
🔹 Advance Functions (IF, IFS, VLOOKUP,HLOOKUP)
🔹 Advance Tools & Big Data Management(TABLE,SLICE)
🔹 Data Review & Automation by Excel(Pivot Table, Pivot Chart)
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 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
