Excel

Find the Start Day of a Week … For Any Date

Finding the Start of a Week (Sunday or Monday) It is possible to identify the initial date of the week through operations with Weekday Function. This function has dates as argument and returns a numbe...

Consolidate Tens of Sheets in One Step

Consolidate Data from Multiple Sheets into one Consolidation is a common task we perform in Excel. By consolidation I mean, we have multiple worksheets and, in each sheet, we have a certain list with ...

You Can Do Magic With The Name Box

In Excel, the Name Box refers to an input box to the left of the formula bar – In the picture below as the cell A1 is selected, the column and row are represented in the Name Box. The Name Box has thr...

Splitting a Date: Number or Text?

Click here to download Start File   Same occasions require to divide the elements of a date: days, months and years. It is possible to do manually, however this path may be slow and inefficient. ...

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...

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.