Excel VBA – Convert Numbers to Words in Hindi Language

Here is the UDF to Convert Numbers to Words in Hindi Language. This can be extended for other Languages as well with little modifications, do let me know your thoughts in comments. How to create the function Called SpellNumber() 1) Start Microsoft Excel. 2) Press ALT+F11 to start the Visual Basic Editor. 3) On the […]

Read More

How to Show Full Path in Excel Title Bar?

Problem Statement: Is there a way to display complete path of the document and not just the file name in the Excel title bar ? e.g. I would like to see C:\MyExcelFiles\MonthlyBudget.xlsx in Excel title bar instead of just MonthlyBudget.xlsx In Excel, there is no setting/straight way for us to display the full path in […]

Read More

How to Get Live Data From A Web Page Direct Into Excel

Being able to perform a web query to retrieve text or data from a web page is a really useful feature in Excel. Web pages often contain really useful information that is perfect for further data analysis in Excel. Depending on what you need, you can retrieve data that is refreshable or alternatively you can […]

Read More

How to Crack Locked Microsoft Word Files

Last night, my best friend Ann told me she was so helpless because she just got a read-only password-protected word file from her boss. She has no idea to sidestep the password because her boss gets really mad every time she asks him to unlock the word file or send her an unprotected version? Ahem! […]

Read More

Corrupted Spreadsheets: How to Recover The Data?

On one hand MS  Excel  offers some advanced features. On the other hand, it may create some serious problems like file corruption. This problem becomes big if we do not take a corrective measures to handle the file corruption. There are several factors which are likely to be responsible for spreadsheet corruption: Virus infection and […]

Read More

How to Flag Multiple Matches In Your VLOOKUP Formula?

This article will explore the Excel VLOOKUP Formula and show you how to combine it with an IF statement to flag if there are multiple lookup values matches in your data set. VLOOKUP is really great for pulling in data from a larger table in Excel, but sometimes in a larger data sets there may […]

Read More

How to Add Macro/Custom Button To The Excel Ribbon Tab

In Excel 2010 onwards you can create your own Ribbon Tabs as well as add your own Macros to them!. Let’s learn how really easy this is to do. This is really useful if you have a set of commands you use on a regular basis and want to keep them on a totally separate […]

Read More

Excel Dashboard : PivotTables and Data Modelling

The whole idea of a Dashboard is to provide a graphical interpretation of the most relevant data, such as a balanced scorecard. Moreover, the updating of new data into the dashboard every week or month should be automated as much as possible. This is where the data model becomes crucial if you want to achieve […]

Read More