Importance of Advance Excel for Students / Office People / Company Owner

Excel is exceptionally advantageous for students. They will learn by doing practices in Excel how to perform calculations quicker. Financial planning can be easily designed. It is always easy to understand data using visualizations. Students will know why filtration is important when we deal with information and data. Objective progressive can be easily learned through … Read more

AUTOMATIC-GST Tax Calculation by Excel in Tax Invoice (CGST/SGST/IGST)

In this video, as I have given below, you will learn that how can you create own tax calculation system in excel sheet that will help you to calculate CGST, SGST, IGST automatically in Sales Invoice. Below 4 Query has been Resolved in this video:- Data Validation Command. Automatic GST Calculation in Excel Tax Invoice. … Read more

Detailed Balance Sheet and P&L TDL for Tally ERP 9

Here is the Preview of this TDL file How to Install the TDL File in Tally Step 1. Go to Gateway of Tally. Step 2. Then Press Ctrl+Alt+T button Step 3. Now Press F4 Button or Click on “Manage Local TDL” button Step 4. Now do “Yes” to “Loan TDL Files on Startup” option Step … Read more

Group Credit Control TDL for Tally ERP 9

Here is the Preview of this TDL file How to Install the TDL File in Tally Step 1. Go to Gateway of Tally. Step 2. Then Press Ctrl+Alt+T button Step 3. Now Press F4 Button or Click on “Manage Local TDL” button Step 4. Now do “Yes” to “Loan TDL Files on Startup” option Step … Read more

Dynamic GST Invoice TDL for Tally ERP 9

With the Help of this TDL, You can Customize your Invoice in Tally ERP9. Here is the Preview of this TDL file How to Install the TDL File in Tally Step 1. Go to Gateway of Tally. Step 2. Then Press Ctrl+Alt+T button Step 3. Now Press F4 Button or Click on “Manage Local TDL” button Step … Read more

MACRO in Advanced Excel (Powerful Function) in Hindi

Here below I have given Top Example of Macro in Excel to get faster work, So below is the video of the example sheet that you can download from below given download button. Formulas Explained:-  (1).  Macro with Example. (2). Record New Macro. (3). CountA ( ) Function in Excel Sheet. Watch This Video to Learn … Read more

Top 6: Advanced Excel Tips in Hindi

Here below I have given Top 6 Advance Excel tips to get faster work in MS Excel, So below is the video of the example sheet that you can download from below given download button. Formulas Explained:-  Hide Formula and lock cell in MS Excel Group Total And Sub Total in MS Excel SumIf ( … Read more

Negative Stock Control TDL for Tally ERP 9

With the Help of this TDL you can Control Your Negative Stock in Tally ERP9. Here is the Preview of this TDL file How to Install the TDL File in Tally Step 1. Go to Gateway of Tally. Step 2. Then Press Ctrl+Alt+T button Step 3. Now Press F4 Button or Click on “Manage Local … Read more

Time Calculator TDL for Tally ERP 9

With the Help of this TDL you can calculate the Time difference in Tally ERP9. Here is the Preview of this TDL file   How to Install the TDL File in Tally Step 1. Go to Gateway of Tally. Step 2. Then Press Ctrl+Alt+T button Step 3. Now Press F4 Button or Click on “Manage … Read more

Crazy Colour TDL for Tally ERP 9

With the Help of this TDL you can change the color of your Tally ERP 9 Software. Here is the Preview of this TDL file How to Install the TDL File in Tally Step 1. Go to Gateway of Tally. Step 2. Then Press Ctrl+Alt+T button Step 3. Now Press F4 Button or Click on … Read more

Notification TDL in Sales and Purchase for Tally ERP 9

This TDL will allow you to show your own notification in Sales and Purchase Voucher as you need. Here is the Preview of this TDL file How to Install the TDL File in Tally Step 1. Go to Gateway of Tally. Step 2. Then Press Ctrl+Alt+T button Step 3. Now Press F4 Button or Click on … Read more

Extraordinary Data Formatting with Advance Excel (Hindi)

Here i am teaching that how can we make our Excel Data Sheet attractive. watch the below video and learn. Watch This Video to Learn Download More Excel Files