Excel Camera tool – What, How and Why? – Snap up your spreadsheet skills

Very recently my passion for art is realized in the form of photography. I wanted it but I never knew that it will soon be an addiction and will have a name as well....

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...

30+ Excel Copy & Paste Tricks You Must Know – Mouse Keyboard Autofill Paste...

So here we have the 30+ amazing copy/paste tricks that everyone must know. With these tricks and tips I am hopeful that you will be able to extend your productivity way further than you...

Making Aging Analysis Reports Using Excel – How To

Aging analysis is helping accountants since ages and is one of those reports that are prepared mostly in Excel to track both receivables and payables. So today we are learning how to conduct aging...

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...

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...

Transpose Data in Excel: Shift Columns to Rows or Rows to Columns – 5...

In Excel one can easily convert data columns to rows or multiple data rows to columns which is technically named transpose. https://www.youtube.com/watch?v=sWLAjLbNYkA In Excel switching or rotating columns to rows or rows to columns is called...

Create Edgy To-Do or Checklists 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...

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...

Excel Drop Down List using Data Validation and Excel Tables that updates dynamically –...

Excel drop down lists are one easy way to keep your data error free and other benefit it is that it automates data entry to some extent. Data validation help us make such drop down lists easily. For...