Excel is a powerful tool that allows you to automate many tasks. With a little creativity, you can use Excel Macros to save a lot of time. A macro is a set of instructions that you can record and then play back. When you record a macro, you tell ...
If you’re using Excel and you’re not using Power Query, you’re missing out! Power Query is a game-changing data transformation and manipulation tool that’s work perfect in all latest Excel versions. With Power Query for Excel, you can easily conn ...
In this blog we will create Check Spelling Instantly tool with Spell Checking Excel VBA Code. There are occasionally spelling errors in the ledgers we produce in Tally or in the many accounts and ledgers we have previously made in Tally. It will a ...
In this blogpost we will see how to Connect Goolge Sheet with Excel in a simple way. Friends when have multiple branches or have offices on different locations, or want to work multiple people on same project or sheet. Then we simply use google she ...
How to get Excel Cell value in Excel Power Query and How to fetch Date from Excel sheet to Excel Power BI let's learn in this blog post. Excel power query is an amazing tool in excel. With Excel Power Query / Excel Power BI we can collect Tally Dat ...
If you want to Connect Tally with Excel to Get GST Summary then follow this simple process. Always required Excel in a business or accounting to maintain books of income, expenses and taxes etc. Excel is most usable software for calculations/presen ...
As per Indian government guidelines 6 Digit HSN Codes are mandatory for Stock Items from 1st April 2021 * HSN/SAC Code turnover Up to rupees five crores - put 4 digits of HSN code * HSN/SAC Code turnover more than rupees five crores- put 6 d ...
Reconcile anything with unlimited rows and columns.With this Reconciliations Utility You can Reconcile any Data within two criteria with multiple amounts and find filtered result in second sheet. Just put your one data in Sheet1 and second data in Sh ...
In Excel all official work is possible that you can think. It's all about your great effort and your hard work with cleverness. Some time excel saves our life. So lets go with this thing.We all normally use excel for reporting and maintain ...
