Day

July 20, 2017

Selecting Multiple Options in Dependent Drop Down List Box using VBA

In our earlier blog we have already discussed how to create a dependent drop down list box in Excel and as well as in VBA when we are using the list box in VBA. Now in this blog, we will discuss how to select multiple options from the dependent drop down list Box as it...
Read More

Quarterwise Sales Comparison Dashboard with Charts in excel using VBA

Thanks for your feedback on our earlier blogs. We have already covered how to create a summary report quickly via Excel VBA. In this blog, we will cover the charts in excel. If you have not gone through the earlier blog, then please go through this link: Create Summary Reports Quickly via Excel VBA. In this...
Read More

How to Customize PowerPoint Slides Only in 15 Minutes? | PPT Tips

Is your boss constantly nagging on your head to complete the PPT in few minutes? In such cases, use shortcuts to get your work done faster, smoother as well as qualitative. I exhibit five effective PowerPoint Presentation Tips that you wished you would know much before so that you would complete creating your presentation within...
Read More

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

How to Update and Delete Using Excel 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...
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 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 how to...
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
How to use COUNTIF in Excel
January 16, 2018
Tips on Round Up numbers in Excel
January 16, 2018
Things you need to know about Excel VBA Macros
January 5, 2018
How to make Data Table in Excel: One-variable data table and Two-variable data table
January 3, 2018
How to Create a Line Chart in Excel?
December 26, 2017
Tricks to Enable / Disable Scroll Lock in Excel
December 26, 2017
How to use sparklines in Excel: Creating a Miniature Chart in a Cell
December 18, 2017
How to create a Pivot Table in Excel
December 18, 2017
Tricks to create Hyperlink in Excel
December 6, 2017
How to Calculate Profit margin in Excel
December 6, 2017
How to Calculate a Percentage Increase in Excel
November 30, 2017
How to add Error Bars in Excel: Standard Deviation
November 30, 2017
How to convert invalid date formats into valid data formats?
November 29, 2017
Converting trailing minus sign into negative numbers. (Text to Column)
November 29, 2017
Text to Columns in Excel | Transfer Single Columnar Data into Multiple Columns.
November 29, 2017
4Excelshorcuts-workingwithformulas
Working with Excel Formula Shortcuts | Excel tips & tricks
September 27, 2017
Top 10 keyboard shortcuts that will help you master Microsoft Excel
September 26, 2017
freeze-panes-excel
Freeze row and column in Excel “How to”
August 26, 2017
How to Copy Text from Image
Copy Text from Image Using Microsoft OneNote
August 17, 2017
Excel VBA Tutorial | What is VBA Macros in Microsoft Excel ?
July 26, 2017