[Affiliate]
Blog Stats
- 3,269,394 hits
-
Join 3,244 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- Advanced vlookup - wildcard characters "?" and "*"
- Sequential number for visible rows only
- =SUM('???'!C3) Is it a valid formula?? No. It is magical indeed!
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Copy data from strictly-protected sheet
- Bug with copy and paste in Excel Table
- #Excel IMAGE function is great, but...
- IF, it is too complicated...
My YouTube Channel
My Facebook page
- My Tweets
Category Archives: Excel Tips
Has Space or NoSpace in worksheet name?
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
The making of an interactive CV in #Excel
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
Posted in Excel Tips
Tagged Custom Lists, Dashboard, Format, INDIRECT, Linked Picture, Pivot Table, Slicer
5 Comments
How to lookup an image in #Excel
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
#Excel Online Survey… Never heard about that!?
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
#,##0, k or #,##0.0, k ? Why not both?
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
Get a list of pending tasks and sort by due dates
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
Repeat all item labels in Pivot Table (aka Fill in the blanks please)
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
Extract part of text string with delimiter(s)… and more with Text to Columns
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
Extract part of a text string using Text to Columns
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
Data Validation to restrict user from inputting to future days
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
The Clipboard can be useful occasionally…
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
Filter a list of items from a long long list
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
Interactive Chart is not difficult to make – Part 3/3
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
Interactive Chart is not difficult to make – Part 2/3
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
Interactive Chart is not difficult to make – Part 1/3
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
Posted in Chart, Excel Tips
Tagged Form Controls, IF, Interactive chart, Option Button
Leave a comment
The basic of Form Controls
Want to work like an Excel Pro? Learn more about Form Controls. Have you seen someone using Check box, Option Buttons, Scroll Bars on their worksheets and be impressed? You may wonder how they made it and think that is … Continue reading
Sort Warning?!
Sorting is one of the basic features in Excel. I believe most Excel users, if not all, know how to sort in Excel. Without any scientific research, I think most users would click the “Sort A to Z” (ascending order) … Continue reading
Adding bullet to each line in cell
Does it sound familiar to you? Are you using Excel as word processing tool? If you have experienced the task shown above, you should know how tedious and time-consuming it could be as you cannot convert each line into bullet … Continue reading
Quick Tip: Undo the “Undo”
Undo the “Undo”? This sounds silly, I know. But silly things happen (frequently). 🙂 If you undo a step, you cannot undo the undo by applying another undo. (Because Excel allows 16 undos by default, although you can modify this … Continue reading
Remove hidden sheets with “Inspect Document” or VBA
This post is an extension of the previous one – we talked about hiding worksheets is not a good way to prevent others from seeing the data on hidden sheets. Since you have read that post, you decided to remove all … Continue reading
wmfexcel 