PBADAP

Professional Business Accounting & Data Analytics Program (PBADAP)

“From Basic Accounting to Data Analytics – Become Industry Ready”

Why This Course is Powerful

This course combines Accounting + Taxation + Data Analysis Skills which are highly demanded in:

    • CA Firms
    • Accounting Offices
    • Companies
    • Startups
    • GST Consultant Firms
    • Data Analyst Jobs

Students can work as:

    • Accountant
    • GST Executive
    • MIS Executive
    • Accounts Analyst
    • Data Analyst (Junior)

Module 1 – Computer Fundamentals & Office Skills

Duration: 2 Weeks

Topics:

    • Computer Basics
    • Internet & Email Communication
    • File Management
    • Professional Work Environment

Module 2 – Microsoft Excel for Business

Duration: 1 Month

Topics:

    • Excel Basics
    • Formatting & Data Management
    • Formulas & Functions
        • SUM
        • IF
        • VLOOKUP
        • HLOOKUP
        • INDEX MATCH
        • COUNTIF
        • SUMIF
    • Data Validation
    • Conditional Formatting
    • Pivot Tables
    • Charts & Dashboard

Project

Create a Sales & Expense Dashboard

Module 3 – Advanced Excel with Business Automation

Duration: 3 Weeks

Topics:

    • Advanced Formulas
    • Financial Functions
    • Pivot Dashboard
    • MIS Reports
    • Data Cleaning
    • Power Query Introduction

Project

Create Company MIS Report

Module 4 – Accounting Fundamentals

Duration: 1 Month

Topics:

    • Basic Accounting Concepts
    • Accounting Principles
    • Journal Entries
    • Ledger
    • Trial Balance
    • Profit & Loss
    • Balance Sheet

Module 5 – Tally Prime with GST

Duration: 1.5 Months

Topics:

    • Tally Prime Introduction
    • Company Creation
    • Accounting Vouchers
    • Inventory Management
    • GST Setup
    • Purchase & Sales with GST
    • GST Reports
    • Bank Reconciliation
    • Payroll Management

Practical

Full Business Accounting Simulation

Module 6 – GST Practical Training

Duration: 3 Weeks

Topics:

    • GST Concepts
    • GST Registration
    • GST Return Filing
    • GSTR1
    • GSTR3B
    • Input Tax Credit
    • GST Portal Working

Practical

Live GST Return Filing Practice

Module 7 – TDS & Income Tax

Duration: 3 Weeks

Topics:

    • TDS Concepts
    • TDS Calculation
    • TDS Return Filing
    • Income Tax Basics
    • ITR Filing
    • Salary Income Calculation
    • Business Income

Module 8 – Power BI for Data Analytics

Duration: 1 Month

Topics:

    • Data Import
    • Data Cleaning
    • Power Query
    • Data Modeling
    • DAX Basics
    • Interactive Dashboard
    • Business Reports

Project

Create Financial Analytics Dashboard

Module 9 – Practical Office Training

Duration: 2 Weeks

Topics:

    • Real Company Accounting
    • Billing & Invoice
    • Tax Documentation
    • Office Workflow

Module 10 – Professional Skills

Duration: 1 Week

Topics:

    • Resume Building
    • Interview Preparation
    • Communication Skills
    • Job Placement Guidance

Final Capstone Project

Students will create:

    • Complete Company Accounting System
    • GST Filing
    • Financial Dashboard in Power BI

Certification

Certified Business Accountant & Data Analyst

(Genext Computer Certification)

Job Roles After Course

Students can work as:

    • Accountant
    • GST Executive
    • MIS Executive
    • Billing Executive
    • Data Analyst
    • Accounts Assistant