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