Blog

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

Extracting Records from a List Dynamically with Functions

Extracting Records from a List Dynamically with Functions – The # One Task in Excel Hello everybody, In this post we are going to introduce to you a very important and common task used in Excel which ...

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? I am confident that you will be able to handle COUNT functions after you review the descriptions an...

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

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.