Excel
Easy way to Get start of week in Excel (Step-by-Step)
Find the beginning or get start of week in excel with the simple method suggested in this article. Read more to learn how to do it Get start of Week in Excel (Sunday or Monday) It is possible to iden...
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...
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...
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...
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...
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...
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...
