Hiding Gridlines in Excel - Learn the Right Ways
One of our facebook community member consulted for Excel help and sent me a sample file. In that I noticed in order to hide gridlines, that are visible by default, were “forced” to disappear by filling the cells with white fill colour. Yes it does work but its not the right way to do it. […]
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 […]
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 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 […]
How to quickly fill cells with 0 (zero) - Excel Quick Tip
Moments ago an active member of our facebook Excel community Muhammed Bilal Asmat asked this question: Okay for example there is a very large table consists of rows and columns. Some of the cells contains values and some are blanks. So I want to convert cells containing values to zero. The way I am doing […]
Excel Find based on cell formatting - When appearance matters
Most probably you might have not found this little find option in Excel i.e. find by cell formatting. Basically it let you include additional condition to find only such results that hold specific format of the cell. Remember format includes: Text format that includes: Font size, font color, font type, font style, font effects i.e. […]
Randomly Select a Name from a list in Excel - How To
Suppose you have a long long list of customers from which you have to select a random name. Now this is certainly not a problem if you have tens or even few hundreds of names. But imagine if you have over 85,000 names in which case you cannot hand pic one name. Just imagine the […]
Birth Dates Heat Map in Excel - How To
First off whoever has birthday on July the 7th my best wishes to all of them. You people have a very interesting birth date. 7 and 7. Everyone’s birthday is interesting in one or the other. But what if you like to know how the birthdays of employee in an organization are spread over the […]
Spell Checking and Proofing in Excel - Ten things to learn how it works
Although Excel is a spreadsheet but one of things it has borrowed from in-family word processor (Word) is Spell check feature. Excel uses the same kind of framework to find spelling mistakes in the worksheets. However, in excel things are not exactly same as normal word processor. In Excel you have to invoke spell check feature. Calling […]
