Excel Tutorial – Ctrl P is Power in Control (Printing)
Yeah I know even a child with rock bottom skills know how to print. But Excel's print is not just a Ctrl + P....
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...
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...
Automating Data Entry using Data Validation in Excel
This is mainly a data entry tutorial and can be used in other scenarios as well. But as sales and price data is easily...
Resume excel session with Save workspaces feature
In accounting world some work is repetitive and accountants have to open certain set of files almost on daily basis. Opening each file by...
Excel Most Wanted – Selection shortcut keys Mega collection
While working in Excel or any data related job selection is one job in itself. And even in Excel it is not easy when you making...
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...
Hiding Gridlines in Excel – Learn the Right Ways
One of our facebook community member consulted for Excel help and sent me a sample file. In that I noticed in order to hide...
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...
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...