Tally + Advance Excel Combo Course

Learn accounting in Tally ERP 9 + GST (Goods & Services Tax) and Advance Excel the most demanding computer IT skills to become truly job ready. Tally.ERP 9 has advanced integration capabilities in the form of Application programming interfaces to make the software extensible. Tally is the most demanding Accounting ERP software available in the market. The training is based on current industry standards that help students secure placements in their dream jobs. The course content is going to teach students in detail on how to manage account, Inventory and payroll in Tally. If you are going to learn Tally you must get well acquainted with MS Excel. Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications.

img
request

Can’t find a batch you were looking for?

 

Learn accounting in Tally ERP 9 + GST (Goods & Services Tax) and Advance Excel the most demanding computer IT skills to become truly job ready. Tally.ERP 9 has advanced integration capabilities in the form of Application programming interfaces to make the software extensible. Tally is the most demanding Accounting ERP software available in the market. The training is based on current industry standards that help students secure placements in their dream jobs. The course content is going to teach students in detail on how to manage account, Inventory and payroll in Tally. If you are going to learn Tally you must get well acquainted with MS Excel. Microsoft Excel is a spreadsheet application developed by Microsoft Inc for Microsoft Windows and MAC OS X. Its use is to do advanced calculation, graphing tools, pivot tables, and a macro programming language referred to as Visual Basic for Applications.

Course content

 

 

Microsoft Excel Basics

 

The Basics
  • Creating a New Workbook
  • Navigating in Excel
  • Moving the Cell Pointer
  • Using Excel Menus Using Excel Toolbars: Hiding, Displaying, and Moving Toolbars
  • Entering Values in a Worksheet and Selecting a Cell Range
  • Previewing and Printing a Worksheet
  • Getting Help from the Office Assistant
  • Saving a Workbook & Re-opening a saved workbook
Formatting a Worksheet
  • Creating Headers, Footers, and Page Numbers
  • Adjusting Page Margins and Orientation
  • Adding Print Titles and Gridlines, rows to repeat at top of each page
  • Formatting Fonts & Values
  • Adjusting Row Height and Column Width
  • Changing Cell Alignment
  • Adding Borders
  • Applying Colors and Patterns
  • Using the Format Painter
  • Using AutoFormat
  • Merging Cells, Rotating Text, and using AutoFit
  • Using AutoFill
Managing your workbooks
  • Switching Between Sheets in a Workbook
  • Inserting and Deleting Worksheets
  • Renaming and Moving Worksheets
  • Protecting a Workbook
  • Hiding Columns, Rows and Sheets
  • Splitting and Freezing a Window
  • Inserting Page Breaks
  • Advanced Printing Options
Editing a Workbook
  • Entering Date Values and using AutoComplete
  • Editing, Clearing, and Replacing Cell Contents
  • Cutting, Copying, and Pasting Cells
  • Moving and Copying Cells with Drag and Drop
  • Collecting and Pasting Multiple Items
  • Using the Paste Special Command
  • Inserting and Deleting Cells, Rows, and Columns
  • Using Undo, Redo, and Repeat
  • Checking Your Spelling
  • Finding and Replacing Information
  • Inserting Cell Comments
Formulas
  • Creating a basic Formula
  • Calculating Value Totals with AutoSum
  • Editing & Copying Formulas
  • Fixing Errors in Your Formulas
  • Formulas with Several Operators and Cell Ranges
Working with the Forms Menu
  • Sorting, Subtotaling & Filtering Data
  • Copy & Paste Filtered Records
  • Using Data Validation
Creating & Working with Charts
  • Creating a Chart
  • Moving and Resizing a Chart
  • Formatting and Editing Objects in a Chart
  • Changing a Chart’s Source Data
  • Changing a Chart Type and Working with Pie Charts
  • Adding Titles, Gridlines, and a Data Table
  • Formatting a Data Series and Chart Axis
  • Annotating a Chart
  • Working with 3-D Charts
  • Selecting and Saving a Custom Chart
  • Using Fill Effects
  • Mapping Data
  • Modifying a Map
Working with Other Programs
  • Inserting an Excel Worksheet into a Word Document
  • Modifying an Inserted Excel Worksheet
  • Inserting a Linked Excel Chart in a Word Document
  • Inserting a Graphic into a Worksheet

 

 

Microsoft Excel – Advanced

 

 

Excel Quick Overview
  • Use of Excel, its boundaries & features
Data Formatting & Custom settings
  • Number, Text, Date, Currency, Custom settings
  • Data formatting & cleaning
Conditional Formatting 
  • Once defined, it will automatically change colour of values e.g. up or down, high or low, pass or fail, profit or loss etc.
Filters, Queries & Data Sorting 
  • Drill down your data to your desired
  • Sort data based on your choice e.g. like North, East, West, South rather than alphabetically.
Formula Writing & Fixing Errors 
  • Financial, Logical, Text, Day and Time, Statistical, Mathematical etc Sum, Average, Count, Minimum, Maximum, Absolute, Concatenate, Count, CountA, CountBlank, CountIf, Day, Today, Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power, Rank, Right, Round, Trim etc.
If-Then-Else & Nested If commands 
  • Produce different set of results based on slabs,
Vlookup / Hlookup
  • You have large amount of data placed at different locations & you want to merge it based on common values & it’s relevance.
Graphs & Charts 
  • In this workshop you will learn how to create, modify & update graphs / charts like Column, Line, Pie, Bar, Area, Scatter, 3D
Hyper / Data Linking 
  • Hyper & data linking, within or outside Worksheet / Excel File is an important feature. This helps update data automatically.
Grouping – Ungrouping
  • Sometime data needs to be grouped for summarized results & crisp
  • Grouping & ungrouping feature will help you do
Data Analysis & Pivot Tables 
  • Summarize your data as per your
  • You need to select data in a range & produce consolidated results in user defined reporting formats.
  • Creating a PivotTable
  • Specifying the Data a PivotTable Analyzes
  • Changing a PivotTable’s Calculation
  • Selecting What Appears in a PivotTable
  • Grouping Dates in a PivotTable
  • Updating a PivotTable
  • Formatting and Charting a PivotTable
Macros Recording, use, editing, linking: 
  • Record, edit & use Macros with little or no programming
Security & Protection 
  • It will help you protect your cells, worksheet or an excel file from unauthorized
Data Validation 
  • Prevent wrong data entry in your specified

 

 

Microsoft Excel – Macros

 

 

Creating & Recording a Macro
  • First step towards learning Macros programming is to learn how to create & record This is the 1st step towards macro programming.
Executing Macros through shortcuts and command buttons 
  • This is using such features based on user
Editing recorded syntax
  • How to edit or write your own Macro programs
Modules 
  • Learn about modules which is an excellent feature of VBA
Procedures 
  • Write & practice programming procedures. Understand their
Sub Procedures 
  • Write & practice programming
Functions 
  • There are certain inbuilt or user defined functions. Explore those functions
Objects and collections 
  • An object is a special type of variable that contains both data and codes. A collection is a group of objects of the same class. The most used Excel objects in VBA programming are Workbook, Worksheet, Sheet, and
Workbook and workbook objects 
  • A workbook is the same as an Excel file. The Workbook collection contains all the workbooks that are currently opened. Inside of a workbook contains at least one worksheet.
Range object & cells property
  • Range represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D
Methods & properties 
  • Each object contains its own methods & properties. A Property represents a built-in or user-defined characteristic of
Object variables and arguments 
  • Sometime a method takes more than one argument. For example, the Open method for the Workbook object, takes 12 arguments. To open a workbook with password protection, you would need to write the
If Case, Loop Case & Select Case 
  • Looping, Sub looping, looping through a range, For, Next loop
Excel VBA tutorial 
  • VBA tutorial will help you proceed in a step by step approach

 

 

Microsoft Visual Basic for Applications (VBA)

 

 

Your First Visual Basic Program 
  • Welcome To Visual Basic
  • A Simple Project
  • Using the Application Wizard
Adding Controls to Forms
  • Visual Basic Controls
  • Creating and Manipulating New Controls
  • Changing Design Time Control Properties
  • Visual Basic Built-In Controls
  • Control Design Tips
Understanding Events
  • Introducing Events
  • Event Procedures
  • The Form Load Event
  • The Form Resize Event
  • Command Button Click Event
  • Text Box Change Event
  • The Timer Control’s Timer Event
  • GotFocus / LostFocus Events
Working with Forms and Controls
  • Setting Properties at Run Time
  • Setting Form and Control Properties
  • Using ActiveX Controls
  • Adding ActiveX Controls to a Project
  • Using the Monthview ActiveX Control
  • Extra ActiveX Samples
Creating and Using Menus
  • Menus in Visual Basic
  • Using the Menu Editor
  • Working with Menus
  • Manipulating Menus at Run Time
  • Reusing Menus
  • Creating Popup Menus
Compiling and Distributing Applications
  • Finishing Touches
  • Project Properties
  • Native Code vs. p-code
  • Creating Your Executable
  • Using the Package and Deployment Wizard
Working with VBA
  • Creating a Simple Procedure
  • Variables and Parameters
  • Data Types
  • Using Constants
  • Investigating Built-In Functions
  • Branching Structures and Looping Structures
Handling Errors
  • Handling Syntax Errors
  • Handling Run-Time Errors
  • The Error Handling Standard
  • Taking a Closer Look
  • Who Handles Errors?
Debugging Applications
  • Handling Logic Errors
  • Watch Expressions
  • The Call Stack
  • The Debugging Process
More VBA Issues, Form and Control Issues
  • Scope, Lifetime, and Precedence
  • Passing by Value and by Reference
  • Arrays
  • Optional Arguments
  • Using Multiple Forms
  • List Boxes Revisited
  • Control Arrays
Adding Simple Database Support
  • Support for Data Access in Visual Basic 0
  • Using the ADO Data Control
  • Binding Controls to Data
  • Writing Code for the Data Control

 

 

Tally ERP 9 with GST

 

 

Basics of Accounting 
  • Introduction
  • Accounting Principles, Concepts and Convention
  • Double Entry System of Book Keeping
  • Types of Accounts
  • Golden Rules of Accounting
  • Mode of Accounting
  • Financial Statements
  • Recording Transactions of Sample Data
Fundamentals of Tally.ERP 9
  • Introduction
  • Getting Functional with Tally.ERP 9
  • Creation / Setting up of Company in Tally.ERP 9
  • Company Features
  • Configurations
Creating Accounting Masters in Tally.ERP 9
  • Chart of Accounts
  • Groups
  • Ledgers
  • Walkthrough for creating Chart of Accounts
  • Practice Exercises
Creating Inventory Masters in Tally.ERP 9
  • Stock Group
  • Stock Categories
  • Units of Measure
  • Godowns
  • Stock Items
  • Voucher Types
  • Walkthrough for creating Inventory Masters
  • Practice Exercises
Voucher Entry in Tally.ERP 9 
  • Accounting Vouchers
  • Walkthrough for recording Accounting Vouchers
  • Inventory Vouchers
  • Walkthrough for recording Inventory Vouchers
  • Invoicing
  • Practice Exercises
Generating Basic Reports in Tally.ERP 9
  • Financial Statements
  • Accounting Books & Registers
  • Inventory Books & Reports
  • Exception Reports
  • Practice Exercises
Multilingual Capabilities
  • Configuring Tally.ERP 9 for Multilingual Capabilities
  • Creating Masters
  • Entering Transactions
  • Transliteration
  • Generating Reports
Technological Advantages of Tally.ERP 9
  • Tally Vault
  • Security Controls
  • Tally Audit
  • Backup and Restore
  • Split Company Data
  • Export and Import of Data
  • ODBC Connectivity
  • Web Enabled, Print Preview and Online Help
  • Printing Reports
Advanced Accounting in Tally.ERP 9 
  • Bill-wise Details
  • Cost Centers and Cost Categories
  • Voucher Classes
  • Cost Centre Class
  • Multiple Currencies
  • Interest Calculation
  • Budgets & Controls
  • Scenario Management
  • Banking
  • Stock Summary
  • Trial Balance
  • Practice Exercises
Advanced Inventory in Tally. ERP 9
  • Order Processing
  • Reorder Levels
  • Tracking Numbers
  • Batch-wise Details
  • Additional Cost Details
  • Bill of Material (BOM)
  • Price Levels and Price Lists
  • Stock Valuation
  • Zero Valued Entries
  • Inventory Ageing Analysis
  • Different Actual and Bill Quantities
Job Costing
  • Configuring Job Costing in Tally.ERP 9
  • Creating Masters for Job Costing
  • Recording Transactions
  • Job Costing Reports
Job Order Processing 
  • Features of Job Order Processing in Tally.ERP 9
  • Configuring Job Order Processing in Tally.ERP 9
  • Job Order Processing
  • Job Order Reports
Tally.NET and Remote Capabilities 
  • Overview of NET
  • Configure Tally.NET Features
  • Connect Company on Tally.NET Features
  • Create Remote Users
  • Authorize Remote Users
  • Remote Access
Application Management and Controls
  • Concept of Control Centre
  • Installing & Activating Tally.ERP 9
  • Logging to Control Centre
  • Managing Accounts using Control Centre
Online Help and Support 
  • Features of Support Centre
  • Accessing the Support Centre
  • Using Support Centre
Value Added Tax (VAT)
  • Basic Concepts in VAT
  • Configuring VAT in Tally.ERP 9
  • Creating Masters
  • Entering Transactions
  • Accounting for Return of Goods
  • Rate Difference in Purchase / Sales
  • Accounting for Interest Transactions
  • Exempt Transaction under VAT
  • Purchase from Unregistered Dealers
  • Claiming ITC on Capital Goods
  • Inter Sate Branch transfers
  • VAT Reports
  • Practice Exercises
  • VAT for Composite Dealers
Central Sales Tax (CST)
  • Basic of Central Sales Tax (CST)
  • Enabling CST in Tally.ERP 9
  • Recording Interstate Transactions in Tally.ERP 9
  • Payment of CST
  • CST Reports
  • Practice Exercises
Tax Deducted at Source
  • Basic concepts of TDS
  • Configuring TDS in Tally.ERP 9
  • Creation of Masters
  • Recording Transactions
  • TDS Reports
Service Tax
  • Basic of Service Tax
  • Configuring Tally.ERP 9 for Service Tax
  • Creating Masters
  • Recording Transactions
  • Accounting for Advance Receipts
  • Accounting for Opening Service Tax Credit
  • Adjustment of Input Service Tax Credit
  • Payment of Service Tax
  • Service Tax Reports
Excise for Dealers
  • Basic Concepts
  • Enabling Dealer Excise in Tally.ERP 9
  • Creating Masters
  • Recording Transactions
  • Excise Repots
  • Accounting for Returns of Goods
Excise For Manufactures
  • Basic Concepts of Excise Duty
  • Configuring Excise in Tally.ERP 9
  • Creation of Masters
  • Recording Transactions
  • Excise Reports
Payroll Accounting and Compliance
  • Configuring Payroll in Tally.ERP 9
  • Creating Payroll Masters
  • Processing Payroll in Tally.ERP 9
  • Accounting for Employer PF Contributions
  • Accounting for Employer ESI Contributions
  • Accounting for Income Tax
  • Payment of Professional Tax
  • Generating Payroll Reports

 

 

Goods and Service Tax (GST)

 

1.    Create GST invoices in minutes
  • Create simple or advanced invoices with multi-Item and multi-tax rates
  • Print / export / email your invoices
  • Manage advance receipts, reverse charge, branch transfers, Bill of Supply, Export Invoices, Input tax credit
2.    GST return filing – easy, accurate and quick
  • Use Tally.ERP 9 Release 6.1 to generate GSTR Form -3 B and GSTR-1
  • Detection & Correction of errors helps you in correcting errors before sharing data with Tax consultant for Filing
  • Eventually it will save efforts and time
3.  Generating GSTR – 1 Report
4. File GSTR – 1
5. HSN/SAC Summary
6. Data Captured in GSTR – 1 e – Return
7. Known Problems During GSTR – 1 Returns Filing
8. Map UoM – UQC
9. GST Advance Receipts
10. Tax liability on Advance Receipts
11. GST Reverse Charge: Inward Supply from Unregistered Dealers
12. Purchase from URD – Reverse Charge Liability Report for GST

 

 

To see the full course content Download now

Course Prerequisites

 
  • Need Computer Basics
  • Be able to Listen
  • Be able to Watch
  • Interested on Accounts, Tally, GST, Taxes
  • with/without Commerce Background

Who can attend

 
  • From Commerce Stream
  • Candidate must complete 10+2 equivalent with required aggregate from a recognized college.
  • Should have basic knowledge of Business Management.

Number of Hours: 70hrs

Certification

Tally ERP 9

Key features

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Virtual Live Experience
  • Preparing for Certification

FAQs

DASVM Technologies offers 300+ IT training courses with 10+ years of Experienced Expert level Trainers.

  • One to One Training
  • Online Training
  • Fastrack & Normal Track
  • Resume Modification
  • Mock Interviews
  • Video Tutorials
  • Materials
  • Real Time Projects
  • Materials
  • Preparing for Certification

Call now: +91-99003 49889 and know the exciting offers available for you!

We working and coordinating with the companies exclusively to get placed. We have a placement cell focussing on training and placements in Bangalore. Our placement cell help more than 600+ students per year.

Learn from experts active in their field, not out-of-touch trainers. Leading practitioners who bring current best practices and case studies to sessions that fit into your work schedule. We have a pool of experts and trainers are composed with highly skilled and experienced in supporting you in specific tasks and provide professional support. 24x7 Learning support from mentors and a community of like-minded peers to resolve any conceptual doubts. Our trainers has contributed in the growth of our clients as well as professionals.

All of our highly qualified trainers are industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating continue to train for us.

No worries. DASVM technologies assure that no one misses single lectures topics. We will reschedule the classes as per your convenience within the stipulated course duration with all such possibilities. If required you can even attend that topic with any other batches.

DASVM Technologies provides many suitable modes of training to the students like:

  • Classroom training
  • One to One training
  • Fast track training
  • Live Instructor LED Online training
  • Customized training

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

You will receive DASVM Technologies recognized course completion certification & we will help you to crack global certification with our training.

Yes, DASVM Technologies provides corporate trainings with Course Customization, Learning Analytics, Cloud Labs, Certifications, Real time Projects with 24x7 Support.

Yes, DASVM Technologies provides group discounts for its training programs. Depending on the group size, we offer discounts as per the terms and conditions.

We accept all major kinds of payment options. Cash, Card (Master, Visa, and Maestro, etc), Wallets, Net Banking, Cheques and etc.

DASVM Technologies has a no refund policy. Fees once paid will not be refunded. If the candidate is not able to attend a training batch, he/she is to reschedule for a future batch. Due Date for Balance should be cleared as per date given. If in case trainer got cancelled or unavailable to provide training DASVM will arrange training sessions with other backup trainer.

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Please Contact our course advisor +91-99003 49889. Or you can share your queries through info@dasvmtechnologies.com

like our courses