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 […]
Select Entire Rows of Multiple Selected Cells - Calling VBA + Macros in Action
I never imagined that my first article involving VBA will be this short. And I kept myself from diving into VBA and Macros until now so that I stay basic and all my dear readers and followers get to know the basics first. But this time I had to call the real army in! So […]
Conditional COUNT in Excel: Count cells meeting multiple criteria + Data Cleanup Tip
We have been provided with a top secret data of one lab situated at the very center of the earth. A team of vigilant individuals take readings of different parameters to monitor the temperature of facility so that it is kept in the range good for human life. Now we want to count the number […]
Create Edgy To-Do or Check Lists with Check boxes in Excel + Shortfall calculator
The ones who like to plan adores to-do lists as well. And if you are also the one who likes to strike a line or tick or dash or mark then this tutorial is for you. As I teach ACCA and other professional qualification students and at the same time teaching several subjects it is […]
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 […]
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 […]
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 […]
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 […]
