E-Accountant & MIS

Module 1: M.I.S (Management Information System)

Advanced Microsoft Word

Getting Started with Microsoft Word
Navigate in Microsoft Word
Create and Save Word Documents
Manage Your Workspace
Edit Documents
Preview and Print Documents
Customize the Word Environment

Formatting Text and Paragraphs

Apply Character Formatting
Control Paragraph Layout
Align Text Using Tabs
Create Bulleted and Numbered Lists
Apply Borders and Shading

Working More Efficiently

Make Repetitive Edits
Apply Repetitive Formatting
Use Styles to Streamline Formatting Tasks

Managing Lists

Sort Lists
Format Lists

Working with Tables

Insert Tables
Modify Tables
Format Tables
Convert Text to Tables

Inserting Graphic Objects

Insert Symbols and Special Characters
Add Images to Documents

Controlling Page Appearance

Apply Page Borders and Colors
Add Headers and Footers
Control Page Layout
Add Watermarks

Advanced Mail Merge

Begin Mail Merge
Use Excel Data Sources
Preview Merge Letters
Select Merge Records
Apply Filters
Use IF-THEN-ELSE Fields
Include Text Fields
Mail Merge to Email

Preparing Documents for Publishing

Check Spelling, Grammar, and Readability
Use Research Tools
Check Accessibility
Save in Different Formats
Macro Recorder
Record Macros
Test Macros
Run Macros
Microsoft Word Keyboard Shortcuts

Professional Microsoft PowerPoint

Create Presentations
Blank and Sample Templates
Add and Format Text Boxes
Edit, Copy, Cut, and Move Text
Add Slides and Change Layouts
Import or Reuse Slides
Arrange Slides
Apply Themes and Backgrounds
Presentation Views
Format Text and Paragraphs
Bulleted and Numbered Lists
Insert Pictures and Graphics
Photo Album
Shapes, WordArt, and SmartArt
Crop, Resize, and Format Objects
Tables and Charts
Slide Master and Custom Themes
Animations and Transitions
Audio and Video
Slide Show Setup
Custom Shows
Hyperlinks and Action Buttons
Packaging Presentations
Document Inspection
SmartArt Graphics
Photo Albums
Advanced Animation
Motion Paths
Presenter View
Record Narration
Rehearse Timings
Collaboration and Comments
OneDrive Co-authoring
Publish to PDF or XPS
Password Protection
Digital Signature
Screen Recording
Closed Caption
Equations and Ink

Professional Microsoft Access (RDBMS)

Database Fundamentals

Understanding Databases
Starting and Opening an Existing Database
Moving Around in Microsoft Access
Understanding Datasheet View and Design View
Using the Mouse Pointer to Navigate
Using the Keyboard to Navigate

Creating Tables

Creating a Database
Creating a Table Using the Wizard
Creating and Modifying a Table
Adding Fields to Tables
Adding and Editing Records
Printing Tables
Moving and Deleting Fields
Deleting Records

Working with Tables

Formatting a Table
Modifying Field Properties
Sorting Records
Finding Records
Using Filters
Establishing Relationships Between Tables
Creating Subdatasheets
Importing Records from an External Source

Designing Forms

Creating a Form Using AutoForm
Creating a Form Using the Form Wizard
Adding Controls to a Form
Modifying Control Properties
Resizing and Moving Controls
Entering Records into a Form
Creating Calculated Controls

Designing Reports

Creating a Report Using AutoReport
Creating a Report Using the Report Wizard
Adding Controls to a Report
Formatting Reports
Resizing and Moving Controls
Creating Calculated Controls

Queries

Creating and Running Queries
Specifying Query Criteria
Using Comparison Operators
Creating Calculated Fields
Creating Multiple-Table Queries
Printing Queries

Automation Using Macros

Creating an AutoKeys Macro
Using Controls to Run Macros
Assigning a Macro to an Event
Assigning a Macro to a Condition
Testing and Debugging Macros

Professional Microsoft Excel (Advanced Excel)

Mathematical & Statistical Functions

SUM
PRODUCT
AVERAGE
CEILING
FLOOR
ROUND
ROUNDUP
ROUNDDOWN
POWER
COUNT
COUNTA
MAXIMUM
MINIMUM
MODE
MEDIAN
LOG
DOLLAR
AVERAGEA
MINA
MAXA
LARGE
SQRT
MOD
ROMAN
RANK
RANK.AVG
RAND
RANDBETWEEN

Logical Functions

IF
Nested IF
SUMIF
SUMIFS
AVERAGEIF
AVERAGEIFS
COUNTIF
COUNTIFS
OR
NOT
AND
IFERROR
MAXIFS
MINIFS

Text Functions

UPPER
LOWER
LEFT
RIGHT
EXACT
LEN
MID
CONCATENATE
PROPER
TRIM
SUBSTITUTE
SEARCH
FIND

Date & Time Functions

DAYS360
DATE
NETWORKDAYS
NOW
TODAY
WEEKDAY
EFFECT
EOMONTH
EDATE
WORKDAY
DATEDIF

Lookup & Reference Functions

INDEX
MATCH
LOOKUP
CHOOSE
OFFSET
OFFSET with MATCH
XLOOKUP
TRANSPOSE
HLOOKUP (Single Worksheet)
VLOOKUP (Single Worksheet)
HLOOKUP & VLOOKUP (Multiple Worksheets)
Find Records using VLOOKUP & HLOOKUP
Approximate Match with VLOOKUP
Exact Match with VLOOKUP
Nesting Lookup Functions
Show Formula
CHOOSE with VLOOKUP
INDIRECT

Financial Functions

PMT
RATE
PPMT
IPMT
FV
PV
COUPDAYS
COUPNUM
ISPMT
SLN
CUMPRINC
CUMIPMT
DDB
DB
RECEIVED

Database Functions

DAVERAGE
DPRODUCT
DMIN
DMAX
DCOUNT
DSUM
DGET

Charts

Create 2D & 3D Charts
Column Charts
Pie Charts
Pareto Charts
Speedometer Charts
Move Charts Between Worksheets
Resize Charts
Change Chart Types
Edit Chart Text
Modify Chart Options
Format Axis Data
Format Data Series
Change Chart Source Data

Cell Formatting

Cell Formatting
Data Bars, Color Scales & Icon Sets
Basic Sorting
Custom List Sorting
Advanced Sorting

Conditional Formatting

Conditional Formatting Rules
Color Scales
Remove Conditional Formatting
Format as Table
Create Custom Styles
Conditional Formatting with Formulas
Conditional Formatting with Form Controls

Data Management

Data Validation
Handle Invalid Data
Group & Outline Data
Data Consolidation
Text to Columns
Custom Views

Data Analysis

Trace Formula Precedents
Trace Cell Dependents
Error Checking

Subtotals & Grouping

Add Subtotals
Nest Subtotals
Group & Outline Ranges
Data Validation
Text to Columns

What-If Analysis

Goal Seek
Data Tables
Scenarios

Sorting & Filtering

Sort Records
AutoFilter
Advanced Filter
Workbook & Worksheet Protection
Lock & Unlock Cells
Shared Workbooks
Track Changes
Password Protection
Merge Workbooks

Collaboration

Web Page Preview
Convert Worksheets to Web Pages
Hyperlinks
Comments

Macros

Create Macros
Edit Macros
Run Macros
Create Custom Menus
Add Commands
Add Toolbar Buttons

Pivot Tables & Pivot Charts

Create Pivot Tables
Rearrange Pivot Tables
Filter Pivot Data
Create Pivot Charts

MIS Reporting

MIS Reports
Profit & Loss Statement
Balance Sheet
Payroll Statement
Cash Flow Statement
Debtors & Creditors Statement
Inventory Statement
BRS Statement
Fixed Assets & Fund Statement
P.F. & E.S.I. Reports

Advanced Excel Features

Paste Special Techniques
Dashboard Creation
External Data Connections
Import Data from Access, Text & Web
Speedometer Dashboard
Print Area & Page Breaks
Print Titles
Worksheet Background

SQL (Structured Query Language)

SQL Overview

Introduction to SQL
What is SQL?
SQL Process
SQL Commands

SQL Operators

Arithmetic Operators
Comparison Operators
Logical Operators
Operator Examples

SQL Expressions

Boolean Expressions
Numeric Expressions
Date Expressions

Database Management

Create Database
Drop/Delete Database
Select Database (USE Statement)

Table Management

Create Table
Create Table from an Existing Table
Drop/Delete Table
Alter Table
Truncate Table

Data Manipulation Language (DML)

INSERT Query
SELECT Query
WHERE Clause
AND & OR Operators
UPDATE Query
DELETE Query
LIKE Clause
TOP, LIMIT & ROWNUM Clause
ORDER BY Clause
GROUP BY Clause
DISTINCT Keyword
Sorting Results

SQL Constraints

NOT NULL Constraint
DEFAULT Constraint
UNIQUE Constraint
PRIMARY KEY
FOREIGN KEY
CHECK Constraint
INDEX Constraint
Dropping Constraints
Integrity Constraints

SQL Joins

INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
SELF JOIN
CROSS (Cartesian) JOIN

Set Operations

UNION
UNION ALL
INTERSECT
EXCEPT

Indexes and Aliases

NULL Values
Alias Syntax
Create Index
Drop Index

Views

Create Views
WITH CHECK OPTION
HAVING Clause

Transactions

Properties of Transactions
Transaction Control Commands

Advanced SQL

Wildcard Operators
Date Functions
Temporary Tables
Create and Drop Temporary Tables
Clone Tables

Subqueries

Subqueries with SELECT
Subqueries with INSERT
Subqueries with UPDATE
Subqueries with DELETE

Sequences and Auto Increment

Using Sequences
AUTO_INCREMENT Column
Obtain AUTO_INCREMENT Values

VBA Macros

Introduction to VBA

What is VBA?
How VBA Works with Microsoft Excel
Quick Review of Macros
Introduction to the Visual Basic Editor (VBE)
Uses of Recorded Macros
Understanding and Creating Modules

Programming Concepts

VBA Sub and Function Procedures
Create Message Boxes
InputBox Programming
Select Case Statement
Variables and Data Types
Creating and Using Variables
Working with Range Objects
Saving and Protecting Modules

Decision Making

If...Then...Else Statements
If...Then...ElseIf Statements

Looping Statements

Do While Loop
Do Until Loop
Do Loop While
Do Loop Until
For Each...Next Loop
For...Next Loop

Workbook Objects

Create Single and Multiple Workbooks
Save and Save As Workbooks
Open Single and Multiple Workbooks
Close Workbooks
Activate Workbooks
Open Workbooks from a Specific Path
Retrieve Workbook Name and Path
Hide and Unhide Workbooks
Protect and Unprotect Workbooks

Worksheet Objects

Insert Single and Multiple Worksheets
Delete Worksheets
Count Worksheets
Select Worksheets
Retrieve Worksheet Names
Hide and Unhide Worksheets
Rename Worksheets
Protect and Unprotect Worksheets
Sort and Move Worksheets
Calculate Worksheets
Worksheet Functions with VBA

Cell and Range Objects

Insert Rows, Columns, and Cells
Delete Rows, Columns, and Cells
Get Cell Address and Range
Navigate Between Cells
Select Cells, Rows, Columns, and Ranges
Selection Types and Offset Method
Insert Functions into Cells

Working with Arrays

Defining Arrays
Arrays as Output
Arrays as Input
Arrays as Collections
Array Processing

User Forms and Form Controls

Create and Design User Forms
List Box
Combo Box
Option Button
Check Box
Text Box
Label
Command Button
Toggle Button
User Form Events
Create Dynamic Dashboards Using User Forms
Link Multiple User Forms

VBA Programming Functions

Create SUM Function
Create Multiply Function
Create COUNT Function
Extract Text and Numbers
PROPER Function
VLOOKUP Function
Square Root Function
Public and Private Functions

Advanced VBA Programming

Working with Dynamic Ranges
Protect Worksheets, Cells, and Ranges
Work with Multiple Files
Open and Save Files
Analyze Data Across Multiple Worksheets
Create Summary Sheets
Access Windows Files and Folders
Error Handling in VBA
Create Excel Dashboards
Create Custom Worksheet Functions
Generate Reports Using Excel, Word, and PowerPoint
Record and Interpret Excel Macros

Integration with Microsoft Office

Connect Excel VBA with Microsoft PowerPoint
Connect Excel VBA with Microsoft Outlook
Connect Excel VBA with Microsoft Word

Module 2: Advanced Accounting

Accounting Fundamentals

Accounting Terminology
Activities and Users of Accounting Information
Accounting Assumptions
Accounting Principles
Accounting Cycle
Source Documents
Accounting Equation
Classification of Accounts
Types of Expenditure
Compound Entries

Books of Accounts

Subsidiary Books
Types of Books
Accounting Vouchers
Journal
Cash Book
Ledger
Trial Balance
Objectives of Trial Balance

Accounting Concepts

Rectification of Errors
Provision and Reserve
Inventory and Inventory Valuation Cost
Suspense Account
Bills of Exchange
Depreciation
Bank Reconciliation Statement (BRS)

Company Accounts

Share Capital
Types of Shares
Forfeiture of Shares
Over Subscription
Pro-rata Allotment

Financial Statements

Preparation of Financial Statements
Ratio Analysis
Cash Flow Statement
MIS Reports
Budget and Types of Budgets
Accounting Standards

Module 3: Taxation

Income Tax Fundamentals

Residential Status
Income Tax Slab Rates
Certain Incomes Exempt from Tax

Heads of Income

Income under the Head Salary
Income under the Head House Property
Profits and Gains from Business & Profession
Income under the Head Capital Gains
Income under the Head Other Sources

Computation of Total Income

Clubbing of Income
Set-off and Carry Forward of Losses
Deductions from Gross Total Income
Agricultural Income
Computation of Total Income
Tax Liability Calculation

Assessment and Return Filing

Assessment of Firms
Assessment of Individuals
Return of Income

TDS & TCS

TDS/TCS Forms
Return Filing
Tax Deducted at Source (TDS)
Advance Tax
Interest
Refund
Penalty

Income Tax Return Filing

Preparation of Income Tax Returns
Manual Return Filing
E-Filing of Income Tax Returns
PAN Allotment
TAN Allotment
Advance Tax Compliance
Income Tax Documentation

Goods and Services Tax (GST)

Introduction to GST
GST Legal Documentation

Module 4: BUSY Accounting Software

Introduction to BUSY

General Features
Completely Codeless Environment
Multi-Company Accounting
Context-Sensitive Online Help
Flexible Voucher Numbering
Multiple Voucher Series
Voucher Entry While Viewing Reports
User-Defined Optional Fields
Unlimited Grouping of Accounts, Items, Material Centers & Cost Centers
Add Images and Notes to Account & Item Masters
Draft Mode Printing
Voucher Cancellation
Powerful Query System
SQL Query Executor
Print Preview
Landscape Mode Printing
Bird's Eye View of Accounts

Enterprise Features

Voucher and Master Approval
Message Centre

Financial Accounting

Books of Accounts and Final Results
Balance Sheet with Schedules
Columnar Account Registers
Daily and Monthly Account Summaries
Bill-wise Outstanding with Ageing Analysis
Payment Reminder Letters
Statement of Accounts
Handling Post-Dated Cheques
Broker-wise Reporting
Royalty Calculation
Interest Calculation
Bank Interest Calculation
Bank Reconciliation
Depreciation Chart
Multi-Currency Accounting
Cost Centre-wise Reporting

Inventory Management

Books of Inventory
Multi-Location Stock Status
Sales and Purchase Challans
Columnar Inventory Registers
Stock Valuation Methods
Item-wise Stock Valuation
Item Serial Number Tracking
Stock Ageing Analysis
Allocation of Expenses to Items
Daily and Monthly Inventory Summaries
Automatic Round-off
Primary and Alternate Units
Batch-wise Inventory with Expiry Date
Free Quantity Management
Sales & Purchase Returns
Production and Un-assemble
BOM and Production Planning
Critical Level Reporting
Multiple Price Lists
Multiple Price Structures
Update Item Prices

Sales & Purchase Order Processing

Pending Sales Orders
Pending Purchase Orders
Order Cancellation
Invoice and Challan Generation

User-Configurable Invoicing

Custom Invoice Design
Plain or Pre-Printed Stationery
Fonts, Colors and Logos
Invoice Border and Line Options
Multiple Taxes in a Single Invoice
Tax Inclusive / MRP Billing
Point of Sale (POS) Billing
Manufacturing Excise Invoicing
Trading Excise Invoicing

User-Configurable Documents

Accounting Vouchers
Purchase Invoice
Sales & Purchase Return Invoice
Receipt & Payment Advice
Debit & Credit Notes
Sales & Purchase Orders
Delivery Note
Goods Receipt Note (GRN)
Stock Transfer Memo

GST Reports

GST Computation & Summary
GST Invoicing
GST Returns (State-wise)
GST Registers
Columnar GST Registers
Party-wise GST Summary
Item-wise GST Summary
Sales Reconciliation
GSTR-1
GSTR-2
GSTR-3B

TDS & Service Tax

TDS Calculation
TDS Warning Alarms
TDS Challans
Form 16A
Form 26Q
TDS Audit Report
Input Service Tax Register
Output Service Tax Register
Service Tax Summary
ST-3 Return

MIS Reports

Cash Flow & Funds Flow
Budgets, Targets & Credit Limits
Ratio Analysis
Sales & Purchase Analysis
Issue & Receipt Analysis
Consumption Analysis
Data Checklist
Profitability Reports
Multi-Company Reports

Utilities

Data Freezing
Pop-up Calculator
Notes & Task Manager
User-Defined Access Rights

Module 5: Tally

Introduction to Tally

Introduction to Tally
Company Information
Create a New Company
Current Period and Current Date
Company Creation (Accounts Maintain, Financial Year, Security Control, Tally Vault)

Accounts Information

Groups and Ledgers
Book Keeping
Journal Entries (Debit & Credit)
Using Cash Account in Journal
Debit Note & Credit Note
Voucher Types
Select Company
Shut Company
Alter Company
Delete Company
Group Company
Change Tally Vault

Financial Reports

Balance Sheet
Profit & Loss Account
Ratio Analysis
Fund Management
Trial Balance
Accounts Books
Statement of Accounts
Cash Flow / Fund Flow
Day Book
List of Accounts
Consolidated Ledger Accounts

Invoice & Billing

Invoice Punching
Bill-wise Details
New Reference
Against Reference
Advance & On Account
Bills Payable
Bills Receivable
Outstanding Ledger Reports

Inventory Management

Stock Groups
Stock Items
Units of Measure
Goods In & Goods Out Vouchers
Alternate Units & Standard Rate
Opening Balance
Stock Summary

Purchase & Sales Order Processing

Create Purchase Orders
Alter Purchase Orders
Delete Purchase Orders
Create Sales Orders
Alter Sales Orders
Delete Sales Orders
Rejection Entries
Delivery Note
Receipt Note
Challan Number Entry

Cost Centres & Cost Categories

Create Cost Centres
Alter Cost Centres
Create Cost Categories
Alter Cost Categories

Godown Management

Create Godown / Location
Alter Godown
Copy Companies
Remove Companies

Tax Deducted at Source (TDS)

TDS Masters
TDS Transactions
TDS Ledgers
Payment Voucher
TDS Challan Preparation
TDS Deposit to Government

Tax Collected at Source (TCS)

Understanding TCS
Create TCS Masters
TCS Transactions
TCS Reports & Forms

Goods & Services Tax (GST)

GST Basics
GST Ledgers
GST Transactions
GST Adjustments
GST Payment

Budgets & Controls

Create Budgets
Types of Budgets

Scenarios & Optional Vouchers

Create Scenarios
Alter & Display Scenario Information

Export, Backup & Company Data

Split Company Data
Export Data to Microsoft Excel
Import Data from Excel
Copy Companies
Remove Companies

Printing Reports

Print Balance Sheet
Print Profit & Loss Account
Print Ledgers
Print Sales Invoices
Print Other Reports

Multi-Currency

Create New Currency
Currency Exchange Rate
Price Lists

Point of Sale (POS)

Point of Sale Billing

Payroll Accounting

Payroll Information
Employee Master
Salary Details
Attendance Register
Employee Groups
Attendance Types
Leave Units

Manufacturing & BOM

Bill of Materials (BOM)
Create BOM Items
Manufacturing Vouchers
BOM Transactions
Alter BOM
Excise Duty Ledger
Batch-wise Inventory

Interest & Price Management

Interest Calculations
Credit Limits
Price Levels
Price Groups
Maintain Item-wise Price Lists

Voucher Types & Classes

Voucher Types
Sales Voucher Class
Inclusive Tax Class
Customer Payment Entries
Discount & Freight Charges in Vouchers

Module 6: E-Filing

GST Forms

GSTR-1
GSTR-2
GSTR-3
GSTR-4
GSTR-5
GSTR-6
GSTR-7
GSTR-8

TDS / TCS Forms

TDS/TCS Challan
TDS Form 24Q
TDS Form 26Q
TDS Form 27EQ

Income Tax Return (ITR) Forms

ITR-1
ITR-2
ITR-3
ITR-4
ITR-5

E-Accountant & MIS Training center in West Delhi, Uttam nagar. Best certified computer course curriculum for professional learning institute near Dwarka, Uttam Nagar, Jankapuri, Tilak Nagar, Subhash Nagar, Tagore Garden, Rajouri Garden, Ramesh Nagar, Moti Nagar, Kirti Nagar, Shadipur, Patel Nagar, Rajendra Place, Karol Bagh, Jhandewalan, Ramakrishna Ashram, Connaught Place, vikaspuri, najafgarh, Delhi Cantt, Dhaula Kuan, Palam Colony, Palam Villag, Dabri, Hari Nagar, Fateh Nagar, Raja Garden, Punjabi Bagh, Shivaji Park, Paschim Vihar, Peeragarhi, Inderlok, Netaji Subhash Place, Pitampura, Rohini, Chandni Chowk, New Delhi, East Delhi, North Delhi, West Delhi.