Combining Two Excel Workbooks Using VLOOKUP Function

INTRODUCTION If you have 2 workbooks which you would like to combine, VLOOKUP function is your best friend in this case. Especially, it is extremely useful when one of the lists is not full and simply...

Adding a Different Look To Your Interactive Dashboard

Code for Interactive Dashboard Course This code Changes the Background in 4 different colors Switch to the Visual Basic ALT + F11 Insert a Module ALT >I>M Copy and Paste the codes here below the...

Extracting Records from a List Dynamically with Functions

Extracting Records from a List Dynamically with Functions – The # One Task in Excel Hello everybody, In this post we are going to introduce to you a very important and common task used in Excel which ...

How to use the COUNT functions in Excel

Did you know that COUNT functions are one of the most commonly used functions in our work and lives? I am confident that you will be able to handle COUNT functions after you review the descriptions an...

SUBSCRIBE To Our Emailing List And Receive 3 FREE Gifts...Now

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below
Two Books( Excel Pivot Tables - Dynamic Charts) and The Magical Shortcuts Quick Reference Card Showing 78  easy to remember Shortcuts.