Excel

XLOOKUP vs INDEX & MATCH for a Dynamic Chart

Xlookup to create a Dynamic Chart First time ever… Chart Title drop List In this tutorial I show you...

Powerful Pivot Tables Hacks

A Common Pivot Table Problem The basic concept which led to today’s Pivot Tables, was invented by th...

Calculate The First or Last Day of The Month for Any Given Date

  Finding the First Day of Any Month It is possible to settle automatically the First Day of An...

My First Dashboard

My First Dashboard from a List You can Download the exercise file from Here Introduction An Excel da...

Have Fun with Comments

Comments are a useful tool when editing in Excel, especially if more than one user is working on the...

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

Consolidate Tens of Sheets in One Step

Consolidate Data from Multiple Sheets into one Consolidation is a common task we perform in Excel. B...

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

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

officeinstructor

Subscribe to our Newsletter

Receive 3 Instant Free Gifts  When Subscribing to our newsletter here below