Hi, My name is Chandeep!
Since 2013, I have been training, consulting and blogging to help people become quicker and smarter with Excel
Let me get you started by sending you smart ebooks on Excel and Powerpoint!
We all have used the Format Painter once in a while, It is really simple. Lets take a look a 2 simple tricks with the format painterRead More
One of the less known and extremely awesome feature of Pivot Tables is its ability to create calculated fields with in the Pivot TableRead More
If you have been using the Trim function for a while to delete the extra spaces between your text, you may have encountered that sometimes the TRIM Just Doesn’t Work! Here is what you do in that caseRead More
No it is not magic, but a simple macro!
The unhide box (appears when you select unhide from the right click menu on the sheet tab) does not allow you to select multiple sheet names
Sub Unhideallsheets() For Each Wrksheet In ActiveWorkbook.Worksheets Wrksheet.Visible = True Next Wrksheet End Sub
All you need to do is to paste this code in the code window and run it whenever you want to unhide multiple sheets
Recently I was getting a model vetted from my girl friend! She saw a set of pivot tables and asked: How do you turn off the irritating GETPIVOTDATA function?
I traded off the quick tip with some awesome stuff ! 😆 And for you my friend.. it is on the house 😎Read More