Limitation of Vlookup and How to overcome it by Using Index and Match Function (Upskill Tutorial on
Learn how to use Index and Match instead of Vlookup with a very simple Example
Using HTML Colors in Excel
Working with colours in excel sometimes might challenge your creativity. Though the colour palette has millions of colours to choose but...
Excel Demo Video
Please watch a demo on using Excel features to simplify daily activities. Enroll today for excel class. #video
Text Functions - Advance Excel
There are hundreds of formulas in Excel. In this post I would like to cover some of the Text Functions in Excel. Assumption: A1 has a...
Bye Bye Sugar Sync! Hi Bitcasa Backup
Well there are many cloud storage services but most of them require you to upload your files for backup. They overlook the fact that we...
Application Object VBA
Application object contains application-wide settings and options. Below are few commondly used codes to control events using Application...