Advanced Excel
- Duration
- Lectures
- Skill level
- 2 Hours
- 15 (Regular)
- Beginner
Original price was: 20,000.00৳.4,000.00৳Current price is: 4,000.00৳.
Advanced Excel
৳ 20000
Advanced Excel users are conversant with most, if not all, of the program’s features. Additionally, an experienced user need to feel at ease instructing others in Excel.
When processing vast amounts of data, most advanced users often employ spreadsheets, graphs, data tables, computations, and automation to generate results. Additionally, Excel spreadsheet models, dashboards, and templates that are useful for basic and intermediate users can be created by advanced users. Some even develop intricate and sophisticated formulas, such formulas that use arrays.
COURSE MODULE
- How to Set Up Company Information
- How to Customize Invoices, Sales Receipts & Estimates
- How to Set Up Invoices, Sales Receipts & Estimates
- How to Set Up Products and Services
- How to Set Up Messages
- How to Set Up Statements
- How to Set Up Expenses
- How to Set Up Advanced Settings
- .How to Import Bank Transactions
- How to Import Credit Card Transactions
- How to Set Up Multiple User
- How to Set Up the Chart of Accounts
- How to Set Up the Products and Services List
- How to Set Up Customers
- How to Set Up Vendors
- How to Create Estimates (Quotes or Bids)
- How to Create and Send Invoices
- How to Receive Payments
- How to Create & Send Sales Receipts
- How to Write & Print Checks
- How to Enter Bills
- How to Pay Bills
- How to Enter Banking Transactions Manually
- How to Manage Downloaded Banking Transactions
- How to Record Bank Deposits
- How to Transfer Funds Between Bank Accounts
- How to Handle Bounced Checks from Customers
- How to Process Bank Reconciliation
- How to Enter Business Credit Card Transactions Manually
- How to Manage Downloaded Business Credit Card Transactions
- .How to Enter a Credit Card Refund
- How to Reconcile Business Credit Card Accounts
- How to Manage Credit Card Sales with QuickBooks Payments
- How to Manage Credit Card Sales with a Third-party Credit Card Processor
- How Set Up and Run Payroll
- How to Manage Payroll Tax
- How to Add Historical Payroll Data
- How to Set Up Automatic Deposits
- How to Print Payroll Checks
- .How to Run Payroll Reports
- How to Reconcile Payroll Liabilities
- How to Run a Profit and Loss Statement
- How to Run a Balance Sheet Report
- How to Run a Statement of Cash Flows
- How to Run an A/R Aging Report
- How to Run an A/P Aging Report
- Use various functions using Xero Accounting Software
- Post the wages journal
- Enter the opening Balances
- Post customer invoices to the sales ledger
- Post supplier bills to the purchase ledger
- Add New Customer & Supplier Details
- Enter the supplier cheques and record the customer receipts
- Prepare the VAT return
- Reconcile the bank
- Post-Petty Cash transactions
- Post adjustments to the accounts and produce the month-end report
Marketplace
- Fiverr
- Upwork
- Freelancer.com