Blog

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

Let Your Presentation Stand Out

Would you say your presentations are spectacular or just regular? Do your presentations re ally attract the audience´s attention? The strategy to strike in a lecture, class or other is to offer someth...

Extracting Records with VBA

Extracting Records with VBA Start File One of the most common tasks we do in Excel is to extract records based upon conditions we specify. In this post I show you 2 different methods to extract record...

Excel & Access Team Together

Excel & Access Team Together Start Files: Student Loans.accdb Student Accounts.xlsx Students.xlsx Excel and Access interact perfectly with each other. It’s common to have data spread between the t...

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