Category Archives: Excel Tips

Highlighting Top X values with Conditional Formatting in #Excel

Posted on December 15, 2018 by

Well… think this topic is too simple?  How about doing this with a dropdown menu to make the Top X a dynamic one? with Icon Set? You may download a Sample File to follow along. Let’s start with the basics … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment

Customize Alt 1 to 4 to become the favorite #Excel shortcuts of your own

Posted on December 8, 2018 by

When talking about keyboard shortcuts, there is always discussion on what’s the most time-saving shortcuts, what are the top X shortcuts you should learn, what is the most frequently used shortcuts, etc… Just to name a few, Ctrl+S to save, … Continue reading →

Rate this:

Posted in Excel Tips, Shortcut | Tagged , | Leave a comment

Using Skip blanks in Paste Special

Posted on December 2, 2018 by

What the Skip blanks does? Have you ever had this question?  From my experience, 99.9% users (I work with) have no idea what it is or even are not aware of that option in Paste Special. Are you one of … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Dynamic Shrinking Dropdown with Dynamic Arrays in #Excel 365

Posted on November 14, 2018 by

The recent HOT topics about Excel should be the new Dynamic Arrays!   After watching all the amazing demonstrations about the new Dynamic Arrays, I’ve decided to sign up to the Office Insider (Fast) programme (for Office 365 subscriber only).  … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , | Leave a comment

Pinned Folder for #Excel 2016 – A workaround

Posted on November 8, 2018 by

Dear Excel 2016, you have made so many enhancements that help me a lot in work… but why you took away my favorite Pinned Folder by giving me a half page of white space? My workplace just got upgrade to … Continue reading →

Rate this:

Posted in Excel Tips | 7 Comments

Calculating CAGR with Goal Seek in #Excel

Posted on October 10, 2018 by

when the starting point is a negative number… Calculating CAGR is not difficult, all we need is the starting value, ending value and the number of periods.  Then we use the formula: CAGR = (Ending Value / Beginning Value ) … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Adding worksheet background in #Excel

Posted on October 3, 2018 by

How to add worksheet background in #Excel? If there is a secret recipe for an interesting Excel training, it would probably be starting with something interesting… 🙂 So in a recent in-house training, I’ve prepared a special Sheet1 in the … Continue reading →

Rate this:

Posted in Excel Tips | 4 Comments

Same day last year…

Posted on August 8, 2018 by

Avoid Overthinking Getting same day of last year using Excel formula In retail, it’s very common to compare sales of same day, not same date, of last year.  If you are not in retail sector, you may wonder what is … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Creating % of Total, Running Total in a few clicks with #Excel Quick Analysis

Posted on July 5, 2018 by

This post is about showing you how to perform a common task of adding a column of % of Total Running Total with Quick Analysis in Excel 2013 or later. Latest Excel makes things easier, just that you may not be … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

VBA to make selected sheets “Very Hidden” in #Excel

Posted on April 26, 2018 by

VBA to make selected sheets “Very Hidden”;  all sheets visible Weeks ago, I showed the way to unhide a very hidden sheet in #Excel via Visual Basic editor (VBE).  You may refer to that post HERE.  Technically we could follow … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , | Leave a comment

Save a Read Only copy

Posted on April 19, 2018 by

When we have created a wonderful #Excel template that is to be shared with others, we don’t want users to distort, if not destroy, the template someday.  Nevertheless we would like to leave as much “flexibility” as possible to users … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Hide and Seek – External Links in #Excel

Posted on April 12, 2018 by

The haunted External Links that won’t go away… Have you ever bothered by this never-go-away warning message? You’d searched all worksheets (visible or hidden and very hidden too) in order to locate the external links and remove them.  Somehow, you … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 1 Comment

Hide and Seek – #Excel Worksheet

Posted on April 5, 2018 by

How to unhide a very hidden worksheet? Situation: You see in the formula bar that the cell is referred to a worksheet called “VeryHidden”.  However you don’t see it on the sheet tab. Naturally you right-click on a sheet tab … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 3 Comments

Hide and Seek – #Excel Workbook

Posted on March 29, 2018 by

Have you ever had this experience with #Excel?  Someone sent you a workbook that is empty!  What I mean empty here is not that there is no content in the workbook.  You know that there are lots of data in … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 1 Comment

Hide and Seek – Column A

Posted on March 15, 2018 by

Cannot unhide column A? I know… it sounds another silly thing in #Excel.  But I do believe many novice users have had this experience before.  If you were one of them, you would know how frustrating that would be.  I … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments

Has Space or NoSpace in worksheet name?

Posted on March 1, 2018 by

Have you received workbook from others that carries underscore _ as if a space in their worksheet names?  Did you wonder why people use underscore when we can actually use space in worksheet name? Well… did you know… long long time ago, #Excel … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , | Leave a comment

The making of an interactive CV in #Excel

Posted on January 27, 2018 by

What to do with Linked Picture to create something interesting in #Excel? How about an Interactive CV to show off your Excel skills!? First, why? Once upon a time when I updated my CV, I was thinking… Everyone states something … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , , , , , | 5 Comments

How to lookup an image in #Excel

Posted on January 20, 2018 by

Lookup an image using “Linked Picture” in #Excel Perhaps you have used VLOOKUP to return a value from a table very often.  However you cannot use VLOOKUP to return an image…  So how the above can be done?  You will … Continue reading →

Rate this:

Posted in Excel Tips, Formula | Tagged , , | 8 Comments

#Excel Online Survey… Never heard about that!?

Posted on January 14, 2018 by

How to create an online survey with #Excel? Did you know that we can conduct online survey by using Excel?  Yes, you heard me right.  I said: Excel!  I am not talking about setting up questionnaire in Excel and then … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

#,##0, k or #,##0.0, k ? Why not both?

Posted on December 16, 2017 by

Conditional Custom Formatting in #Excel Got the following question: This gives me £28.8 K (if 28800 is input) and £28.0 K if 28000 is input. I was rather hoping that if there was no decimal after the thousand, ie £28 … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments