[Affiliate]
Blog Stats
- 3,269,259 hits
-
Join 3,244 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Dropdown calendar in Excel
- Perform VLOOKUP with 2 lookup values
- =SUM('???'!C3) Is it a valid formula?? No. It is magical indeed!
- Sequential number for visible rows only
- Advanced vlookup - wildcard characters "?" and "*"
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Copy data from strictly-protected sheet
- The INDIRECT trick of using Structured Reference in Conditional Formatting
- Copy and Paste can do so much...
- Bug with copy and paste in Excel Table
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: Excel Tips
#Excel Flash Fill in action with 16 examples
Flash Fill was introduced in Excel 2013. After 6 years, it is still a hidden gem of modern Excel that most regular Excel users do not even know its existence. Whenever I show to my colleagues what Flash Fill is … Continue reading
Did you know… there are many nice Excel Templates readily available?
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
Posted in Excel Tips, Template
Leave a comment
Hard-coded range expands automatically with #Excel Table
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
The INDIRECT trick of using Structured Reference in Conditional Formatting
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
Highlighting Top X values with Icon Set in #Excel
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
Highlighting Top X values with Conditional Formatting in #Excel
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
Posted in Excel Tips
Tagged Conditional Formatting, Custom Format, Data Validation, LARGE, \
Leave a comment
Customize Alt 1 to 4 to become the favorite #Excel shortcuts of your own
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
Using Skip blanks in Paste Special
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
Dynamic Shrinking Dropdown with Dynamic Arrays in #Excel 365
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
Posted in Excel Tips
Tagged Data Validation, Dynamic Arrays, Dynamic Dropdown, Excel 365, MATCH
Leave a comment
Pinned Folder for #Excel 2016 – A workaround
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
Posted in Excel Tips
7 Comments
Calculating CAGR with Goal Seek in #Excel
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
Adding worksheet background in #Excel
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
Posted in Excel Tips
4 Comments
Same day last year…
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
Creating % of Total, Running Total in a few clicks with #Excel Quick Analysis
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
Save a Read Only copy
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
wmfexcel 