Excel

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

Splitting a Date: Number or Text?

Click here to download Start File   Same occasions require to divide the elements of a date: da...

Combining Two Excel Workbooks Using VLOOKUP Function

INTRODUCTION If you have 2 workbooks which you would like to combine, VLOOKUP function is your best ...

Adding a Different Look To Your Interactive Dashboard

Code for Interactive Dashboard Course This code Changes the Background in 4 different colors Switch ...

Extracting Records from a List Dynamically with Functions

Extracting Records from a List Dynamically with Functions – The # One Task in Excel Hello everybody,...

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

SUBSCRIBE TO OUR EMAILING LIST AND RECEIVE FREE BOOK

Receive my Amazing Textbook “Pivot Tables From Zero To Hero” Totally FREE when you subscribe below to our emailing list.
SUBSCRIBE NOW
close-link