Blog

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 how to use the new XLOOKUP function to create a dynamic chart in Excel that switches data depending...

Powerful Pivot Tables Hacks

A Common Pivot Table Problem The basic concept which led to today’s Pivot Tables, was invented by the American engineer Pito Salas in 1987. Since they were introduced into Excel 1993, Pivot Tables bec...

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 Any Month. Although, there is no an specific function for returning the first day, this Tutorial will ...

My First Dashboard

My First Dashboard from a List You can Download the exercise file from Here Introduction An Excel dashboard is one pager (mostly, but not always necessary) that helps managers and business leaders in ...

Have Fun with Comments

Comments are a useful tool when editing in Excel, especially if more than one user is working on the same worksheet. Comments help communicate ideas, questions, problems, and answers. Comments provide...

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

Be The Boss in Presentations

  Do you know what is most important in presentations? To conquer your audience’s attention and the best path to achieve this is to:   Figure 1   The beginning of a presentation is extr...

Visualize Excel Data & Build Dynamic Dashboard

Click Here to Download Start Files   In this project: We need to consolidate multiple Excel Files then analyze and visualize the data. On each file we have the same table. The sheet name is a Sta...