Monthly Archives: March 2017

Simple trick to look (hack) into hidden sheet

Posted on March 18, 2017 by

This post is inspired by the previous post Excel Humor #9 – You do not see me Situation Suppose you are going to share an Excel workbook to your colleagues.  However there is a worksheet with sensitive data that you don’t want them to … Continue reading →

Rate this:

Posted in General | Tagged | 19 Comments

Excel Humor #9 – You do not see me

Posted on March 11, 2017 by

This is a true story with modification… I can’t believe it happened when I first heard it, but then I realize some changes made on Excel 2016 (not sure if also in Excel 2013). Here’s today humor: If you are working … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment

Interactive Chart with navigation panel [NO VBA]

Posted on March 4, 2017 by

Isn’t it nice?  Don’t think that this is difficult.  No VBA is required.  Indeed you only need to know a few Excel skills in order to create an interactive chart  with navigation panel like this. The skills required: Conditional formatting … Continue reading →

Rate this:

Posted in Chart | Tagged , , , , , | 3 Comments