- 1,929,205 hits
- Follow wmfexcel on WordPress.com
Want Google to translate this page?
Top Posts & Pages
- When unhide row doesn't work...
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Show number in thousand (k) or in million (M) by using custom format
- How to sort bar chart in descending order?
- Insert a text string into a specific position of another text string in #Excel
- Perform VLOOKUP with 2 lookup values
- Open an embedded Excel file during a slide show in PowerPoint?
- How to lookup an image in #Excel
- Same day last year...
- 2D SUMIF with two variables – one on column and one on row
My YouTube Channel
- My Tweets
Category Archives: Excel Tips
Did you know that there are many nice Excel Templates readily for usage? Next time when you start a New workbook, browse or even search for a template that suits your need. Or you may start from a template. Why re-invent a wheel? Continue reading
The INDIRECT trick of using Structured Reference in Conditional Formatting Is it a feature or a bug? This is an extension of the previous post, in which we discussed the use of INDIRECT trick to deal with Excel Table in Conditional … Continue reading
When setting up conditions for Conditional Formatting in Excel, have you ever tried to set a formula that refers to a Excel Table, but failed?
First of all, why we want to refer to Excel Table in Conditional Formatting? There is one simple answer: To accept new data automatically.
To use Structure Reference in Conditional Formatting, we need an INDIRECT approach which is discussed here. Continue reading
This post is a continuation of the previous one – Highlighting Top X values with Conditional Formatting in #Excel So I will go straight to the point. For background information, please read the previous post. 🙂 To insert Icon Set Select … Continue reading
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
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
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
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
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
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
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
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
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
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
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
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
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