AMIT, Author at How Paradise

TDS Module under Tally Prime

December 21, 2023AMITLeave a Comment

[docxpresso file=”https://www.howparadise.com/wp-content/uploads/2023/12/TDS-module-under-Tally-Prime.odt” comments=”true” SVG=”true”]

Interest provision under MSME

November 7, 2023July 1, 2024AMITLeave a Comment

[docxpresso file=”https://www.howparadise.com/wp-content/uploads/2023/11/MSME-Interest-Copy.odt” comments=”true” SVG=”true”]

Mastering the Art of Effective Reading

May 26, 2023May 26, 2023AMITLeave a Comment

Introduction In today’s world of fast paced, information is readily available at our fingertips. Skill of Effective reading become more important. Reading is not about only just reading the words on the page but rather about comprehending, analyzing and translating information in a manner to gain valuable knowledge. In this blog, we will explore strategies […]

How to Control Anger? And Why we become angry?

September 4, 2022July 7, 2025AMITLeave a Comment

How to Control Anger? And Why do we become angry? Before knowing, How to control anger. We must understand why we become angry. Why do we become Angry? In any sudden & unavoidable situation, when we are unable to decide the plan of action. we become angry. To avoid such a situation, our body generates excessive […]

Excel Function – SQLFormat | To Import Excel to SQL Database

August 7, 2022July 1, 2024AMITLeave a Comment

If you want to import excel Table into SQL Database. You are at right place. Most of the time we required to import Excel Data into SQL (Like MySQL Database), and conversion is not easy task. We have prepared Customized fuction for you (called User Defined Function (UDP). This function wraps selected range Row into […]

Excel Function – AllConcat | Combine all cells value

August 3, 2022August 3, 2022AMITLeave a Comment

You want to combine all cells value scattered in rows and columns. But you dont want to select each cell seperate by comma, then you are at right place. We have designed a function for you which can combine / concat all value by just selecting range inside the function. =AllConcat(A2:D7) Copy above function inside […]

Excel Function – DisplayValue – Copy Display Value | Format Cell

July 31, 2022August 3, 2022AMITLeave a Comment

If you want to copy Display value in Excel which different from the actual value in Excel. You are at right place. Most of the time with format cell option we can change display of actual value, but there is no option in excel to copy the same value to another cell as original value. […]

Excel Function – Sumifcr – Multiple Criteria

April 16, 2022July 7, 2025AMITLeave a Comment

Excel Function – SUMIF Next version – sumifcr with multiple criteria With this function we can sum with multiple criteria in single cell. It has three variable, ‘a = criteria range TEXT format ‘b = sum range NUMBER format ‘c = criteria, comma separated TEXT format Copy this function use it anywhere in excel file.