![How to Highlight Blank Cells in Excel using Conditional Formatting [Quick Tip]](../../wp-content/uploads/2013/04/1-minute-excel-tutorial-150x150.png)
How to Highlight Blank Cells in Excel using Conditional Formatting [Quick Tip]
With huge data pinpointing blank cells is near to impossible. Sometimes back we learnt how to fill blank cells with zero using Go-To special feature in Excel. But what if we only want to highlight the cell? This can easily be done in the blink of an eye using Excel’s conditional formatting. Step 1: Select […]
![Creating Timelines in Excel [How To]](../../wp-content/uploads/2014/08/timeline1-150x150.png)
Creating Timelines in Excel [How To]
Just recently I upgraded the office suit to 2013. And the first thing I did is to see how Excel looks. Its even better. Sublime, simple, to the point and just like the way bean counters like it. Great job developers. The obvious next stop was to see the templates and the first template that […]
![Making Interactive Charts in Excel [How To]](../../wp-content/uploads/2013/05/excel-tips-and-tricks-150x150.png)
Making Interactive Charts in Excel [How To]
Graphs and charts are amazing tools to understand the information in the blink of an eye. It not only saves you from reading at all levels. That is why charts and Excel is one combination not to miss when you are learning Microsoft Excel application. But sometimes even the charts are so laborious that you wish […]
Creating and Working with Dynamic Charts in Excel
Title should be “making charts dance to your command in Excel” but lets keep it technical OK let me be very quick at it as I learnt about this almost by chance. I used to thought that when you create a chart the selected range is locked tight so show graph therefore if the data […]
Dealing with Telephone numbers in Excel - Dialing in the correct format
Many have the impression that Excel is a tool to do maths. But the ones who are using it on daily basis know that Excel is way beyond just calculation and helps you maintain information and later extract it they way you like. However, when it comes to number, there are situations where Excel stops […]
Comparing two columns to highlight Duplicates in the same row - Excel Conditional Formatting
Back to Excel after a long time. But now starting to relax a little as course is concluded for many subjects I teach. I really missed my Excel community and I really want to thank each and everyone of them that they have not given up on me. Love you all! During my break from […]
Adding specific Prefix to All cells or Specific cells in Excel - 3 Methods Explained
A dear friend of mine contacted me early in the morning and the length of his message was evident that he has tried his best to get his head round the problem but in vain. The reason was an excel file with over 25,000 contact numbers with or without area codes before actual contact number. […]
Formatting Numbers in Excel - Conditional Formatting Vs Custom Number Formatting
Accountants are always dealing with numbers. And its not always about highlighting positives. In some cases we have to make negative numbers standout and having a negative sign is just not enough. Similarly to show zero results as “Nill” or simply leave that field blank or being filled with a dash to replace boring “0” […]
Making Aging Analysis Reports Using Excel - How To
Aging analysis is helping accountants since ages and beyond doubt this is one the those reports that are prepared almost every period to track both receivables and payables. If you want to learn more about aging or ageing analysis do read my explanation: What is age, aged, ageing or aging analysis? If you are new to […]
Changing numbers Sign in Excel - From Negative to Positive and Vice versa
Another question to answer and very interesting one indeed. Again this question came from our vibrant facebook community. The requirement is to change number signs that is change negative numbers to positive and positive to negatives. Although this is hardly the case in many situations that you really want an additive inverse for each and […]
