Courses

We found 2 courses available for you
See

Microsoft Excel Basic to Pro

5 Lessons
2.3 hours
Intermediate

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)
Featured

Excel for Financial Reporting: Preparation of Financial Statements

1 Lesson
2 hours
Beginner

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
Compare