I do consulting and training on MS Excel, Business Intelligence Dashboards,
Business Plans / Financial Models and PowerPoint Presentations
I am putting together everything about Excel and PowerPoint Presentations
that I have learnt (and still learning) on this blog
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
I recently worked on a consulting project where I had to deliver a corporate presentation. The client had to impress its peers in Singapore. I thought what better way than creating some interesting animations and one of them was to display the logos in a tray like look 😎Read More
I guess I don’t have to say much to get your interest!! Interested..? Ok lets begin! 🙂Read More