Excel Pivot Table Slicers: Old Filters got Overhauled!
First things first, this post is strictly for those who have Excel 2010 or later installed. But is this a warning not to read this post if you have older versions? NO! The intention...
How to convert numbers into words in Excel – VERY QUICK TIP
I have been working on a small piece and I came across one requirement that in letters to customers in addition to amounts reported in numbers it must also include amounts receivable in words....
Replace a formula with the value or final result – Super Easily
Formula and Excel is a bond not meant to break. Although formula do help us get the values we want. But often you find that it will be code that you just get have...
20+ Excel Table tricks to turbo charge your data
In my last article on tables Introduction to Excel Tables - Data beyond just formatting I discussed the basics. If you are new to excel or if you think that tables are meant for just...
40+ Excel navigational shortcuts to make accounting job super efficient
With the advent of user interface we are able to use mouse and other input devices. But when it comes to speed, efficiency and productivity keyboard is still EXCELlent above anything else i.e. K...
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...
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...
Customizing How Excel Saves files and Save settings
Saving is probably the first thing user learns in any application software. Same was the case with me when I stumbled on a software that has mysterious boxes that made no sense to me...
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...
50+ Excel Tricks Accountants Love by Heart! – Episode 1
I often confront a question "what to know in Excel". Answer to this is not easy. To me Excel is like a journey and it never ends unless you stop. Similarly more you use...