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 […]
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 […]
ACCA Online Classes December 2013 Announcement and Quick Excel Tip on Duplicating Excel Worksheets
This time around the post is a mix plate. Some of you were worried that how come key strokes are silent on Excel for more than 24 hours. So here you have the confession and also your Excel tip for which you wait everyday. So again fulfilling the promise to make you excel at Excel […]
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 […]
How to make a basic Tax calculator in Excel
Business and Taxation go hand in hand. However, taxation calculations are most of the time tedious and if you need to make a small change you might have to punch millions of calculator keys again to get the tax liability calculated. But we have a rescue pack for you in the name of Excel! Many […]
Using SUMIF with Dates in Excel
I was in the middle of making an accounting project where I had to use SUMIF. This wonderful function that everyone must know especially accountants. In many instances SUMIF can be used as an alternative to VLOOKUP function and it is much easier to use as well. However, using this formula with dates is a […]
How to change currency format in Excel? How to have Pakistani Rupees (Rs) currency sign in excel?
In almost every office of the world when it comes to money accountants come to excel. Although excel can handle money matters but when it comes to currency by default we have Dollar ($) as currency and not every country have this currency nor have the same currency sign. Accountants who are new often struggle […]
One minute Excel Tutorial - Watch Window
Accountants and analysts around the world does one amazing job and that is they give the meaning to mammoth data by processing it using their skills and the same information is then used by managers to make decisions. Everyone wishes to be an analyst or a consultant that people seek for advice. However, as we […]
