Conditional Charts in Excel - Workaround + How To
Last time we learnt how to make simple dial charts. There is so much to be discussed as basics to Excel charting but without little fun and doing out of ordinary is what everyone asks for. So today we will talk about how to do conditional charting in Excel. Making things clear, there is no […]
Create Simple Dial Charts in Excel - How To
Charting or graphing is one of the biggest punch Excel has. Visual presentation of data greatly improves user’s ability to comprehend the information and significantly cuts down the time to take decisions. That is why executives around the world rely on charts and graphs rather than simple reports full of words. Believe me nobody has […]
Excel Dynamic Data Validation Lists - Explained
Data validation lists are one easy way to keep your data error free and other benefit it is that it automates data entry to some extent. For those who are unaware of data validation tool and data validation lists then it is a technique by which you can control the input by providing a drop-down […]
Building a reference to specific Worksheet based on Cell value using Formula
Most of the time businesses are managed using specialized software but when it comes to a final touch in reporting the data is exported to Excel where calculations and everything is done much more easily. However, exporting to excel or importing in excel sometimes create very bizarre situations. For example, imagine a situation that you […]
Count Specific Weekday or Weekdays within Data range containing Dates
Often we have to deal with dates as they form integral part of almost every data set. But what if you want to count specific weekdays within a large range of dates? This is often the case with time sheets or similar kind of data set where dates are involved and you have to count […]
How Excel VLOOKUP Works: How to use it - Explanation with Example
While explaining LOOKUPs in my previous post, I explained how in daily life we apply lookup functions in different situations and to understand better I explained the example of mathematical lookup table to find the rate. If you haven’t read that article yet then I strongly recommend to read that first and then come to […]
Quickly fill Blank cells with the Value in the Cell Above
There are situations when you ask someone to punch data for you and they come up with one lazy idea to leave the cell blank if the same value is repeating in subsequent cells in the same column. Download the tutorial workbook or look at the picture below to understand the situation better. This is definitely […]
Excel Pivot Tables - Grouping Dates by Week Within Months, Quarters or Years - Workaround
Earlier we learned about grouping and ungrouping time related information very easily using excel pivot tables. It saves huge amount of time in preparing summary pivot table reports with different dimensions of time. However, we also learned one limitation of this feature i.e. if we want to group dates by week within a month or […]
Excel Pivot Tables - Grouping Data by Date and Time
Where reporting is about numbers and analysis, the big part of it is also about time. And to best understand the situation you sometime have to want information specific to certain time period or grouped for certain period of time. Excel is good and the best thing happened to Excel is Pivot Tables and one of the […]
Running Totals and Running Balance with Excel Pivot Tables - How To
Last time when I discussed how to do running totals and running balance using Excel many different ways were discussed but one was left for today which is doing running totals and running balance using Pivot Tables in Excel. The reason was by that time we didn’t discussed how to make pivot tables. But as […]
