Visit and subscribe our YouTube Channel: YouTube

Wednesday 14 March 2018

How to link the image based on cell value in Excel - With index and match function

In this video we have explained how to link the image in the excel based on cell value.  we have used index + match function. To Download the Excel sheet click the below link.

Free Tally TDL for Default Godown Selection in Tally Tally Add for Default godown Selection


Tally TDL for Default godown selection for purchase & Sales Vouchers



Sunday 11 March 2018

Free Tally TDL for Month wise item wise Dispatch - Tally Add on Features

With this Tally TDL you can view the Month Wise and Item wise dispatch details, and also you can view party wise item wise dispatch details.  To down this Tall Add on click the Below link

How to Create Macro in Excel and link the image with Macro in Excel

In this video we explained how to create the macro in excel and you can link the image with macro in excel. To Download the Excel Sheet Click below link


Costing Formula in Excel - Markup and markdown costing

In this video we explained about costing method in Excel With Formula, you can find the Purchase cost, sale value and percentage of Gross margin with this Excel Formula.



Saturday 10 March 2018

How to Create Type of Security and use the Security Control in Tally

In this video we explained how to create type of security and usage of Security Control in Tally



How to Activate Remote Access in Tally Erp 9

In this video we explained how to activate remote access in tally Erp 9. To Download the PDF File Click the Below link


How to Create Reset Button in Excel (VBA)

In this video we explained how to create the Reset Button in excel  To download the Excel Sheet click the Below Link.




Friday 9 March 2018

How to Use the Solver Tool To Optimize the Profit by Change the Price

Last video we explained how to use the solver tool to optimize the profit by increase the Quantity.  In this Video we explained how to use the solver tool to optimize the profit by increase the Price.



Free Tally TDL for Day book Columnar Report in Tally


Tally TDL: Day Book Columnar Details



Long Term Capital Gain Calculator for Land or Building or Both for Financial Year 2017-18

Download this Long Term Capital Gain Calculator for Land or Building or Both for Financial Year 2017-18


Thursday 8 March 2018

How to Use Solver Tool in Excel to Optimize the Profit in Trading Business.

In This video we explained how to use Solver Tool in Excel to Optimize the Profit In Trading Business. Step by Step Explanation given.  Watch this video to enhance your experience in Excel. To Download the Excel Worksheet for Solver Tool, Click the Below Link.




Complete Round Function in Excel

In This video we explained complete round function. Round function, Roundup Function, Rounddown Function, Fixed Function, Odd Function, Even Function, Mround Function.





Translate to Any Language from English in Excel

You can use google-translate option in excel.  Watch this video and use Google translate option in excel.



How to Quickly Convert From PDF to Excel

in this video we explained how to convert PDF document to Excel.  Watch video and convert your PDF



How to Quickly Convert the Document from Word to PDF and Excel to PDF

In this video we explained how to convert from Word to PDF and Convert Excel to PDF




Wednesday 7 March 2018

How to Add Zero Before Number in Excel

In This Video We Explained how to add the zero Before Number in Excel



How to Create reminder or notification in Excel

There is three way to Create reminder in Excel,


how to create the group mail in gmail - Gmail Advance Settings

In This video we explained how to create the group mail in gmail. And how to Send the Group mail in Gmail.  Moreover we can share the document to particular group in gmail.




Gmail Settings How to Change the Label colour in Gmail

Watch this video. In Gmail Setting we can create the Label and change the label color.  If You Change the Label Colour you can easily track the incoming mails,


House Rent Allowance Calculator for Financial Year 2017-18 , H R A Calculator for FY 2017-18

Just Enter the Pay slip details & Rent Paid Details.  You Can easily calculate the H R A Exemption as per income tax Section 10 (13a).  To Download this calculator click the below link.

How to Add Indian Rupee Symbol in Word Document and Excel Spreadsheet

In This Video we explained how to Add the Indian Rupee Symbol in Word & Excel Spreadsheet.
Watch the Video and add the Indian Rupee Symbol in your document.