Top 10 Best Practices – Effective email subject lines

One of my clients recently asked if I had any good write-up on best practices on how to write professional & effective email subject lines. I was surprised and I thought who would need a write-up or a guideline on a topic as simple as writing effective email subject lines. I mean, did we ever went...
Read More

If you use ALT + TAB to toggle, read these 6 lines…

We all use Alt  Tab to toggle different windows of applications. Even though we use this key shortcut to do our daily job yet we don’t know this tricks. Alt  Tab ↹ is the common name for a keyboard shortcut that has been in Microsoft Windows since Windows 3.0. This shortcut switches between top-level windows without...
Read More

“God Mode” trick to Unprotect Excel

Open password protected file from this simple excel tips & tricks. Learn how to unprotect excel or remove password from excel. Let me warn you up front – 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 at...
Read More

How to Update and Delete Using Excel VBA Userform ? | VBA Userform

It’s useful for making a task easy in business areas like Banking Record, Personal Finance, Stock Reporting, Recordkeeping, Automate Training room booking, Hotel Room booking, Car Booking, booking IT resources and approval of business expenses such as refreshments, conveyance, stationery etc. This technique will help User access the data in the VBA Userform only and then if he\she...
Read More

Remove Password from Excel Using VBA [Macros] Tutorial

In this blog, we will try to cover how to remove password from Excel using VBA as part of our continued effort to give 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...
Read More

I was recently invited to hold a 1 day workshop on “Excel for Data Analysis”

I was recently invited to hold a One day Excel workshop on “Excel for Data Analysis” in Baroda Chapter of Institute of Chartered Accountants of India (ICAI). Baroda (Vadodara) is the third largest city in the western Indian State of Gujarat. I was almost half asleep while waiting to board a Sunday morning flight (6:35...
Read More

Find that rascal cells asap – IN EXCEL

  How many cells in your Financial Model have been left blank? Which cells have been fraudulently “modified” or hard-coded after you wrote the formula? How do I delete or color all error laden cells – all in one go? E.g. #N/A! How do I play FreeCell Solitaire? FreeCell Solitaire?! Ignore that. It’s a classic...
Read More

Life is full of What Ifs … (So is Excel!)

What If I were a Baseball Superstar… Also what If I could teleport myself from my office to Miami beach… What If I perform Excel What If Analysis with scroll buttons to do a collar-up in office… Price Sensitivity Analysis using Excel What if: We can’t fulfill the first two wishes. However, our latest course...
Read More

What can you do on a date… err… with a date in excel ?

Dates are one category of information that is found in ALMOST ALL Excel reports. You can maneuver with them like a Maverick (Read: Tom Cruise’s starrer movie – Top Gun) These are the things you can do with a date in excel: You can find which day of the week it is (e.g. Sunday, Monday…)...
Read More