Blog

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

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

Start your presentation with a BANG!

At least once in your lifetime, you will have to perform a presentation or already had, either for academic or business purposes.  It may be a great experience or a nightmare. Do you know what differe...

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