Excel

combine data from multiple worksheets in Excel

Simple method to combine data from multiple worksheets in Excel

If you want to combine data from multiple worksheets in excel, you can read through this article to find exactly how to do it. Read to learn more Consolidation is a common task we perform in Excel. By...

name box in excel

Complete Guide to Name box in Excel

You can do many things with the name box in excel. In this article, we have discussed complete functionality of the name box. Read to learn more In Excel, the Name Box refers to an input box to the le...

split date in excel

Splitting a Date: Number or Text?

With the help of functions, you can easily split date in excel. In this article you will learn how to do it in an efficient way Click here to download Start File   Same occasions require to divid...

combine two excel workbook

Simple method to Combine Two Excel Workbooks Using VLOOKUP

INTRODUCTION In this article, we will show you simple and easy method to combine two excel workbook in excel. Read more to find out how If you have 2 workbooks which you would like to combine, VLOOKUP...

create custom dashboard in excel

Design and Create custom dashboard in Excel

In this article, you will learn how to design and create custom dashboard in excel. Let’s dive right in to find out how Code for Interactive Dashboard Course This code Changes the Background in 4 diff...

extract dynamic list based on criteria

Simple Method to extract dynamic list based on criteria in Excel

In this article we will discuss how to extract dynamic list based on criteria using function in excel. Lets dive right in Extracting Records from a List Dynamically with Functions – The # One Task in ...

Easily learn how to use COUNT function in excel

COUNT function in excel is super useful feature. In this article, we will deep dive into the functionalities of COUNT function in Excel. Learn more.. Did you know that COUNT functions are one of the m...

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.