Accounts & Banking

Learn the Fundamentals of Accounting & Banking

Gain in-depth knowledge of accounting and banking with our industry-relevant and practical training program.

Basic Excel

Excel Introduction

  • Workbook, Worksheet, Rows & Columns
  • Cells, Range
  • Data Entry & Editing

Formatting

  • Font, Color, Borders
  • Alignment
  • Number, Currency, Percentage formats
  • Cell Styles

Basic Formulas

  • SUM
  • AVERAGE
  • MIN
  • MAX
  • COUNT
  • COUNTA

Basic Functions

  • IF
  • AND
  • OR
  • NOT

Data Management

  • Sort & Filter
  • Find & Replace
  • Remove Duplicates
  • Data Validation

Charts

  • Column
  • Bar
  • Pie
  • Line
  • Basic chart formatting

Printing & Page Setup

    • Page Layout
    • Print Area
    • Header & Footer
    • PDF/Print settings

ADVANCED EXCEL

Advanced Formulas

  • VLOOKUP
  • HLOOKUP
  • XLOOKUP
  • INDEX + MATCH
  • SUMIF / SUMIFS
  • COUNTIF / COUNTIFS
  • AVERAGEIF / AVERAGEIFS
  • IFERROR
  • Nested IF

Advanced Data Handling

  • Advanced Filter
  • Conditional Formatting
  • Data Validation
  • Text to Columns
  • Flash Fill

Pivot Tables

  • Creating Pivot Tables
  • Grouping Data
  • Filters & Slicers
  • Pivot Charts
  • Reports & Summaries

Advanced Charts & Dashboard

  • Dynamic Charts
  • Interactive Dashboards
  • KPI Cards
  • Slicers
  • Data Visualization

Power Query

  • Importing Data
  • Cleaning Data
  • Combining Multiple Files
  • Merging & Appending Data
  • Data Transformation

What-If Analysis

  • Goal Seek
  • Scenario Manager
  • Data Tables

Automation

    • Macros
    • VBA Basics
    • Recording Macros
    • Basic VBA automation 

Professional Excel

  • MIS Reports
  • Sales Reports
  • Attendance Sheets
  • Financial Reports
  • Inventory Management
  • Automated Reports

BASIC TALLY

Tally Introduction

  • Tally kya hai?
  • Company Create & Alter
  • Company Features & Configuration

Accounting Fundamentals

  • Capital, Assets, Liabilities
  • Income & Expenses
  • Debit & Credit
  • Accounting Rules

Ledger & Groups

  • Ledger Create/Alter
  • Groups
  • Cash & Bank Ledger
  • Customer & Supplier Ledger

Vouchers

  • Payment
  • Receipt
  • Contra
  • Journal
  • Sales
  • Purchase

Inventory

  • Stock Groups
  • Stock Items
  • Units
  • Godown
  • Stock Transactions

Basic Computer

Computer Fundamentals

  • What is Computer?
  • Hardware & Software
  • CPU, RAM, ROM
  • Input & Output Devices
  • Storage Devices

Windows Basics

  • Desktop & Taskbar
  • Files & Folders
  • Copy, Cut, Paste
  • Rename & Delete
  • File Management

Typing

  • English Typing
  • Number/Numeric Typing
  • Basic Typing Practice

MS Word

  • Document Making
  • Formatting
  • Tables
  • Page Setup
  • Printing
  • Applications/Letters making

MS Excel – Basic

    • Data Entry
    • Rows, Columns & Cells
    • Formatting
    • Basic Formulas
    • SUM, AVERAGE, COUNT
    • Sort & Filter
    • Basic Tables

Internet & Email

  • Use of Internet
  • Web Browsing
  • Google Search
  • Email Send/Receive
  • Attachments
  • Download/Upload

Digital Banking Basics

    • Internet Banking ka basic use
    • Mobile Banking ka basic concept
    • UPI ka basic concept
    • ATM ka basic use
    • Online transactions ki basic understanding

Computer Security

  • Strong Password
  • OTP Safety
  • Phishing/Fake Links
  • Basic Cyber Security
  • Personal information ko safe rakhna

MS OFFICE

MS Word Advanced

  • Advanced Mail Merge
  • Styles & Templates
  • Table of Contents
  • Footnotes & Endnotes
  • Section Breaks
  • Advanced Page Layout
  • Track Changes & Comments

MS Excel Advanced

  • VLOOKUP, XLOOKUP
  • INDEX + MATCH
  • IF, IFERROR
  • SUMIF/SUMIFS
  • COUNTIF/COUNTIFS
  • Pivot Table
  • Pivot Chart
  • Conditional Formatting
  • Advanced Data Validation
  • Advanced Charts
  • Dashboard
  • Power Query
  • Basic Macros/VBA

PowerPoint Advanced

  • Advanced Animations
  • Slide Master
  • Custom Templates
  • Advanced Transitions
  • Interactive Presentations
  • Professional Charts & Infographics

Outlook Advanced

  • Email Rules
  • Folders & Categories
  • Calendar Management
  • Meeting Scheduling
  • Professional Email Management
Scroll to Top