Category Archives: Excel Tips

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 | Leave a 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 , | 2 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 , , , , , , | 1 Comment

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

Get a list of pending tasks and sort by due dates

Posted on December 3, 2017 by

A common task – Get and sort a list of tasks that are not yet due according to due dates Got the following question: Suppose on column A I have entries and on column B i have due dates for … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Repeat all item labels in Pivot Table (aka Fill in the blanks please)

Posted on October 28, 2017 by

Quite a long time ago, I wrote a post Fill in the blanks – quickly to talk about the tip to turn a human-reading-freindly table into an Excel-friendly table, as shown below: Have you ever thought about why we are doing … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 3 Comments

Extract part of text string with delimiter(s)… and more with Text to Columns

Posted on October 14, 2017 by

In the previous post, we talked about the basic of Text to Columns and focused on “Fixed width”.  In this post, we will continue to talk about three magical things that Text to Columns could do with ease: Extract part … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 8 Comments

Extract part of a text string using Text to Columns

Posted on October 7, 2017 by

There are many not-so-easily-understood terms in Excel. “Text to Columns” should be one of them.  Probably due to the name of it, Text to Columns is not a common tool for many Excel users.  But indeed, if you know what … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Data Validation to restrict user from inputting to future days

Posted on September 22, 2017 by

The situation We need to input certain data on a daily basis.  For example, daily sales.  That is supposed to be an easy and routine task for many people.  BUT… it happened that we still have a chance to input … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

The Clipboard can be useful occasionally…

Posted on August 30, 2017 by

According to study (which was conducted in a totally unscientific way with zero level of confidence…, i.e. my gut feeling), 100% of Excel users use Copy and Paste every time they work with Excel. 🙂  However, 99.99999% of them never … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | 2 Comments

Filter a list of items from a long long list

Posted on August 2, 2017 by

A simple but practical tip of using Advanced Filter I came across a blogpost from Jon of Excel Campus (one of my favorite Excel sites) last week.  In his post, he showed how to filter for a list of items using a reverse … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 5 Comments

Interactive Chart is not difficult to make – Part 3/3

Posted on July 26, 2017 by

Using Option Button to display different items on chart So far, we have made an interactive chart with check box to highlight items with negative growth; with scroll bar to see more items in a confined space.  In this post, … Continue reading →

Rate this:

Posted in Chart, Excel Tips | Tagged , , | 1 Comment

Interactive Chart is not difficult to make – Part 2/3

Posted on July 22, 2017 by

Using Scroll Bar to show more This is an extension of the previous post – Using Checkbox to highlight negative growth in a bar chart.  In that post, we had created a chart showing top 10 items, which allowed user … Continue reading →

Rate this:

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

Interactive Chart is not difficult to make – Part 1/3

Posted on July 15, 2017 by

Using Checkbox to highlight negative growth in a bar chart In previous post, we talked about the basic of Form Controls.  I hope you had time to practice it and found useful way of building interactivity to your spreadsheet. In … Continue reading →

Rate this:

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