Hi All, Dashboard- Dashboard is one platform that helps management in tracking Performance, evaluation and help them to take a decision based on it. A dashboard is often called a report, however, not all reports are in the dashboard. Now that we understand what a dashboard is, let’s dive in and learn how to create a …
Hi, Conditional formatting is the best way to visualize data in a colourway. With conditional formatting, we can do things like highlights data into colours, apply bars, Icons, Flags and formulas. As an Excel user, we usually highlight data into colours however in the practical scenario we are applying colour manually which is a time-consuming …
Hi All, Hope you all are doing great! As an Excel user, we maintain data in different files with different formats and at the end, we want to consolidate these files into excel. First, we need to understand the problem then we will discuss its solution in detail. Problems- Lets suppose if we have a …
Power Query- How to merge multiple workbooks with different file format Read More »
Hi, As an excel user, when we are maintaining data on different tables or on different sheets however we want to pull the information on a single sheet from the tables. If we do type manually or copy and paste it, it will consume more time basically Its time taken process.
As an excel user, you may have come across a problem where you have a big data in excel, in which few rows are hidden or the data is filtered and you wish to copy the visible or filtered data and paste it anywhere, sometimes excel behave weird and paste the complete data instead of …
How to Copy and paste filtered or visible Data only Read More »
Sometimes the data is spread over multiple worksheets and the requirement is to consolidate them in to a single worksheet, usually either we copy and paste data individually for each sheet or consolidate option of Ms-Excel can be used but in both cases either it is time consuming or needed a lot of manual intervention. …
We have been using Sort function for so long in our work but still one of the most unexplored feature of this function is that we can sort data row wise also. This could be useful in some cases, where our data is in horizontal manner. So let’s see how we can do it….. I …
When we paste data on filtered rows it always past it on both visible and hidden rows. And if you are doing this for a huge set of data then I am sure you must be pasting it manually and wasting lot of time and efforts. Don’t worry guys, we have a solution for this …
Ever came across a situation where you need to apply Vlookup on duplicate lookup values?? Like the one below… Note:- Download the Exercise workbook from here. Here we have course ID repeating in “Lookup Table”. If we simply apply Vlookup in result table, where course ID “A1005” is appearing multiple times, it will …
Suppose you apply a formula in a cell and you get an error, the reason could be anything but the problem lies where you don’t want to share a report which contains errors. With the use of IFERROR we can hide any error (e.g. #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) with almost anything. …