December 20, 2019

Unprotect Excel | Excel Password Remover Online

Open password-protected the file from this simple excel tips & tricks. Learn how to unprotect excel or remove password from excel. Let me warn you upfront – THE MOMENT you learn applying this trick on How to Unprotect Excel, you’ll JUMP in ecstasy. If you are ready, then read on.   Almost ALL Excel users wish...
Read More

Remove Password from Excel Using VBA [Macros] Tutorial

How to remove password from Excel using VBA as part of our continued effort to give the valuable resource of learning for Excel VBA Macros tutorial students.   If you are following our blogs on a regular basis then probably you have gone through the blog where Rishabh have very clearly shown to us that...
Read More

Keep Duplicate Records in Power Query

Power Query in Power BI allows you to perform a series of steps to transform your data. One of the steps amongst this is to keep duplicate records. Keep Duplicate Records In Power Query We generally take out duplicate lines but if we need to keep and check what the duplicates are, Power Query allows...
Read More

5 Powerful Tricks to Format cells in Excel

In this article, you will learn 5 Excel tricks on how to format cells in Excel. Applying these in excel will make your worksheet or spreadsheets look attractive and easy to read. Almost all Microsoft Excel users know how to change the date format, numbers and text formats using rows and columns. But very few know...
Read More