Tally ERP9 | Advanced Excel
Tally ERP9 | Advanced Excel
Aurguz Software Training Academy in Chennai provides 100% placement assured specialized training in Company Accounts, GST, Tally and Taxation for the accounts professionals. We provide practical training for accounts and taxation with Tally ERP9 and Advanced Excel. Attend our Tally ERP9 and Advanced Excel Classes to get practical knowledge of various accounting system.
Along with the course, we will train you on communication skill development, personality development and stage presentation. We will prepare your resume by industry experts to the corporate standard to easily crack the interview. We will arrange several Mock Interviews by the HR professionals from Multi-National firm to reduce the common interview fear for the freshers.
Course Syllabus
Features of Tally ERP9
Simple accounting management
One stop solution for compliance
Support for banking transactions
Faster access to business report
Flexible inventory management
Easy application management
Easy to share
Support for manufactures
Multilingual capabilities
Enhanced security
Important Contents
Multiple currencies
Bank reconciliation
Interest calculations
Bill wise details
Batch wise details
Bill of materials
VAT,CST,POS,TDS,TCS,GST
Job costing
Payroll
Tally ERP9
BASIC OF ACCOUNTING
Introduction
Types of Accounts
Accounting Principles or concepts
Mode of Accounting
Rules of Accounting
Double entry system of bookkeeping
FUNDAMENTALS OF TALLY.ERP 9
Introduction to Tally.ERP 9
History of tally
Versions of tally
Company Features
Configuration
Getting functions with Tally.ERP9
Creation / setting up of Company in Tally.ERP9
ACCOUNTING MASTERS IN TALLY.ERP9
Chart of Groups
Groups
Multiple Groups
Ledgers
Multiple Ledgers
INVENTORY MASTERS IN TALLY.ERP9
Stock Groups
Multiple Stock Groups
Stock Categories
Multiple Stock Categories
Units of Measure
Godowns
Stock Items
VOUCHERS ENTRIES IN TALLY.ERP9
Introduction
Types of Vouchers
Chart of Vouchers
Accounting Vouchers
Inventory Vouchers
Invoicing
ADVANCE ACCOUNTING IN TALLY.ERP9
Bill-wise details
Cost centers and Cost Categories
Multiple currencies
Interest calculations
Budget and controls
Scenario management
Bank Reconciliation
ADVANCE INVENTORY IN TALLY.ERP9
Order Processing
Recorder Levels
Batch-wise details
Bill of Materials
Batch-Wise Details
Different Actual and Billed Quantities
Price Lists
Zero-Valued Entries
Additional cost details
POS
TAXES IN TALLY.ERP9
VAT
Vat Reports
CST
Vat Reports
TDS
TDS Reports
TCS
TCS Reports
EXCISE
Excise Reports
ERVICE TAX
Service Tax Reports
TECHNOLOGICAL ADVANTAGES IN TALLY.ERP 9
Tally vault
Security controls
Tally Audit
Backup and restore
Split company data
Import and export of data
Printing Reports and Cheques
Create Company Logo
PAYROLL ACCOUNTING IN TALLY.ERP9
ENERATING REPORTS IN TALLY.ERP9
Financial Statements
Trading Account
Profit & Loss Account
Balance Sheet
Accounts Books and Reports
Inventory Books and Reports
Exception Reports
Statutory Reports
Payroll Reports
Trial balance
Day Book
List of Accounts
Stock Summary
MS Excel | Advanced Excel
MS Excel – Basics
Excel – Introduction
Excel – Basics
Excel – Create & Close Files
Excel – Tabs & Groups
Excel – Editing Data
Excel – Formatting
Excel – Characteristics Of Cell
Excel – Cell Reference
Excel – Speak Cells
Excel – Text to Columns
Excel – Comments
Excel – Filling
Excel – Copying & Filling
Excel – Fill Series
Excel – Advanced Fill PREVIEW
Excel – Flash Fill
Excel – Viewing Worksheets
Excel – Custom View
Excel – Adjusting Worksheet
Excel – Working with Worksheets
Excel – Compare Two Sheets PREVIEW
Excel – View Files Side By Side
MS Excel – Filling
Excel – Logical Test
Excel – IF Function
Excel – Nested if
Excel – AND Function
Excel – IfError
Excel – Auditing Tools
MS Excel – Logical Functions
MS Excel – Functions & Formulas
Excel – Text Functions
Excel – Date Functions Part 1
Excel – Date Functions Part 2
Excel – Date Functions Part 3
Excel – Name Range
Excel – Name Range with Formulas
Excel – Basic Formulas
Excel – Count Functions
Excel – Statistical Functions
Excel – Maths & Trigonometry
MS Excel – Lookup
Excel – VLookup With Exact Match
Excel – VLookup Approximate Match
Excel – VLookup With Trim
Excel – H-Lookup
Excel – VLookup Rules
Excel – Lookup Function
Excel – Lookup Full Record
Excel – Index Function
Excel – Match Function
MS Excel – Protection
Excel – Protect Cells
Excel – Protect Sheet
Excel – Protect File
Excel – Protect Workbook
MS Excel – Hyperlink
Excel – Hyperlink to Sheet
Excel – Hyperlink to File
Excel – Hyperlink to Webpage
Excel – Hyperlink to Update
MS Excel – Page Setup
Excel – Print Page Setup
Excel – Header & Footer
MS Excel – Sort & Filters
Excel – Data Sorting
Excel – Advanced Filters
Excel – Filtering Data
MS Excel – Tables & Subtotal
Excel – Basic Table
Excel – Advanced Table
Excel – Subtotal
MS Excel – Charts
Excel – Column Chart
Excel – Design A Column Chart Part:1
Excel – Design A Column Chart Part:2
Excel – Pie, Bar, Column & Line Chart
Excel – XY Chart
Excel – Spark Line Chart
Excel – Pivot Chart
MS Excel – Pivot Tables
Excel – Pivot Table Example 1
Excel – Pivot Table Example 2
Excel – Pivot Table Example 3
Excel – Pivot Table Grouping
Excel – Pivot Table Slice
Excel – Pivot Table Timeline
MS Excel – Consolidate
Excel – Consolidation
Excel – Consolidation Extended
MS Excel – Conditional Formatting
Excel – Conditional Formatting Part 1
Excel – Conditional Formatting Part 2
Excel – Advanced Conditional Formatting
MS Excel – Data Validation
Excel – Data Validation
Excel – Data Validation Error Alert
Excel – Dependent Dropdown List
MS Excel – Importing Data
Excel – Import Live Data From Web
MS Excel – Objects
Excel – Insert Objects
Excel – Create Objects
MS Excel – Shortcuts
Excel – Shortcuts Ctrl+A to Ctrl+Z
Excel – Shortcuts Alt+A to Alt+Z
Excel – Shortcuts Alt + Single Key
Excel – Shortcuts F1 To F12
Excel – Shortcuts Single Key
Excel – Shortcuts Shift+F1 To Shift+F12
Excel – Shortcuts Shift+Single Key
Excel – Shortcuts Ctrl+F1 To Ctrl+F12
Excel – Shortcuts Ctrl + Special Characters
Excel – Shortcuts Ctrl+Single Key
Shortcuts Ctrl+Shift+A to Ctrl+Shift+Z
Shortcuts Ctrl + Shift + Special Characters
Excel – Shortcuts Ctrl + Shift + Single Key
Shortcuts Ctrl+Shift+F1 To Ctrl+Shift+F12
Excel – Shortcuts Alt+F1 To Alt+F12