Enquiry: 9920294574

(Advanced Excel & Advanced Tally)

Advanced Excel

Module 1 : Overview of the Basics

Working with the Ribbon; Protecting and un-protecting File, Worksheets and Cells; Comments, Transpose, Hyperlinks, Print Titles

Module 2 : Working with Functions

Conditional Expressions (using IF), Logical functions (AND,OR,NOT), Mathematical functions (RANK, SMALL, IF(SMALL), LARGE, COUNTBLANK, COUNTIF, SUMIF, ROUND, ROUNDDOWN), Using Lookup and Reference functions in MIS Reports with multiple Worksheets and Workbooks (VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET-MATCH)

Module 3 : Data Validation

Specifying a valid range of values for a cell, Validation Criteria based on Decimal, List, Date, Time, Text Length, Specifying custom validations based on formula for a cell

Module 4 : Working with Templates

Designing  the structure of template; A typical Template for Invoices

Module 5 : What-IF Analysis

Using Goal Seek, Data Tables; Tables with two variables, Creating and editing Scenario

Module 6 : Data Forms

Using Forms to simplify data manipulation, Specifying criteria for finding records

Module 7 : Workbook Sharing and Auditing

Track changes, Tracing precedents and dependents; Tracing errors, Sharing Workbook

Module 8 : Conditional Formatting, Working with Styles

Conditional formatting: Hide cell contents, Highlight expiry dates, Highlight items in list, Hide errors

Cell Styles, Merge Styles

Custom Formatting

Module 9 : Sorting and Filtering Data

Sorting and filtering lists, Sorting data according to color, Using multiple-level sorting, custom sorting, Using advanced filter options, wild card entry in filter

Module 10 : More Functions

Date and Time Functions, Text Functions, Database Functions, Financial Functions – PPMT, IPMT, PMT

Module 11 : Working with External Data

Using external data sources, Refreshing Data, Querying external Databases, Saving, editing and reusing data queries, Importing text files

Module 12 : Working with Reports (Using Pivot Tables)

Creating Subtotals, Creating and formatting Pivot Tables, Pivot Charts

Calculated Fields and Calculated Items

Analysing Multiple Tables

Consolidating data from multiple sheets and Pivot Tables

Module 13 : Macros

Recording and Running Macros –

Read / Write Cells; Edit Cell Properties like Background, Font, Color, Case; Accessing range of cells; Editing sheets – rename, add, delete; Editing rows and columns – insert, delete, hide, unhide, set width; Searching from a list; Copying matching rows; Lookup

Advanced Tally

Module 1 : Fundamentals of Tally

Company Creation

Select, Edit, Shut and Delete Company

Module 2 : Creating Accounting Masters

Single Ledger – Multiple Ledgers

Group Creation – Multiple Group Creation

Accounting Features & Configurations

Module 3 : Accounting Vouchers 

Voucher Entry

Discount Calculation

Display – Accounts Book, Day Book

Module 4 : Generating MIS Reports

Balance Sheet, Profit & Loss A/C

Income & Expenditure

Module 5 : Creating Inventory Masters

Stock Groups

Stock Items

Units of Measures

Stock Summary

Purchase Bill – Sales Bill

Module 6 : Advanced Accounting

Bill wise Details

Outstanding Reports :- Bills Payable & Bills Receivable

Cost Center

Interest Calculations

Bank Reconciliation Statement

Debit Note, Credit Note

Post-dated Cheques

Standard Rate

Price List Creation

Point of Sale

Discount on Total Bill

Item-wise Discount

Enter HSN Code in Invoice

Module 7 : Technological Advantages

Security Control

Set Tally Vault Password

Backup & Restore

Export Balance Sheet

Export & Import Data

Split Company Data

Module 8 : Taxation

Goods & Service Tax (GST)

        Enable GST

        Set GST Rate

        Generate GST Report

Tax Deducted at Source (TDS)

        TDS Setup

        Creation of Masters

        Processing Transactions

        TDS Report

Module 9 : Inventory Management

Purchase & Sales Order Processing

        Purchase Order

                Receipt Note

                Rejections Out

                Purchase Voucher

                Payment Voucher

        Sales Order

                Delivery Note

                Rejections In

                Recording Sales

                Receipt Voucher

Inventory Vouchers

Godown Management

        Godown Creation

        Godown Status

        Multiple Godowns

        Transfer of Materials

Stock Ageing Analysis

Physical Stock

Batch-wise Details

Reorder Level Monitoring

Bills of Materials

Category of Stock

---

Duration : 4 Months

Fees :  Rs.9400/-

---