HDI

Bestseller

0 rating

DIPLOMA IN BUSY ACCOUNTING & ADVANCED EXCEL(S-DBA&AE-4624)

Last updated Sep, 2026
Certified Course

₹6,000 ₹7,000

Enquire Now

Course Includes

Duration6 Months
Enrolled0
Lectures60
Videos0
Notes0
CertificateYes

What you'll learn

A Diploma in Busy Accounting & Advanced Excel is a professional certificate program that teaches computerized financial management, enterprise inventory tracking, and data analysis using Microsoft Excel and BUSY Accounting Software

Course Syllabus

BUSY Accounting Syllabus

Company Creation & Setup: Managing features, configurations, security controls, and multi-currency setups.
Master Creation: Setting up ledgers, account groups, item masters, and cost centers.
Inventory Management: Tracking stock groups, categories, units, multi-godown locations, and batch/serial numbers.
Voucher & Order Processing: Recording sales, purchase, payment, receipt, contra, journal entries, debit/credit notes, and purchase/sales orders.
Taxation & GST: Configuring GST, generating tax invoices, e-way bills, and filing GSTR returns.
Payroll & Banking: Managing employee salary structures, TDS, TCS, PF, ESI, and bank reconciliation.
MIS & Financial Reports: Generating trial balance, profit & loss accounts, balance sheets, and custom analytical reports.

Advanced Excel Syllabus

Advanced Formulas & Functions: Using logical, lookup (VLOOKUP, XLOOKUP), index-match, financial, and text formulas.
Data Analysis Tools: Managing data validation, conditional formatting, and multi-level sorting/filtering.
Pivot Tables & Charts: Summarizing large data sets, grouping data, and building interactive pivot charts.
What-If Analysis: Utilizing Goal Seek, Scenario Manager, and Data Tables for forecasting.
Dashboards & Reporting: Designing executive business dashboards and advanced dynamic charts.
Data Security & Macros: Protecting workbooks, auditing formulas, and recording basic automation macros