- Follow wmfexcel on WordPress.com
Top Posts & Pages
- When unhide row doesn't work...
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Advanced vlookup - wildcard characters "?" and "*"
- Advanced vlookup - Text vs. Number
- Copy data from strictly-protected sheet
- 2D SUMIF with two variables – one on column and one on row
- Show number in thousand (k) or in million (M) by using custom format
- SUM vs. SUBTOTAL
Category Archives: Excel Tips
Answer to the 5 little Tips (tests) – Part 5/5 The task: To sort the following dates in descending order. Sound silly but… The first thing you would probably do is to go to Data tab and then click the Sort Z to A icon? … Continue reading
Answer to the 5 little Tips (tests) – Part 4/5 The task: To convert “1” to “Tick” in a table like the following one: Answer: Copy and Paste with a simple trick … What? Not Find and Replace? Yes, you may do it by using … Continue reading
Answer to the 5 little Tips (tests) – Part 3/5 The task: Doing simple calculation (add, subtract, multiply, divide) without formula Answer: Copy and Paste Special…
Answer to the 5 little Tips (tests) – Part 2/5 Fill a series (of sequential numbers) The task: Fill a big series of sequential number, say from 1 to 24567. Answer: You may find the answer to the question in this post: Fill … Continue reading
Answer to the 5 little Tricks posted in the beginning of the year – Part 1/5 Transpose Data – Result is static This is actually a simple trick of using Copy and Paster (Special, Transpose). See? It can be done in a … Continue reading
First of all, Happy New Year of 2017! Wish you all an Excellent year ahead! Let’s start the year with a simple “Game” which I developed for in-house Excel training in my previous company. All participants were expected to have basic Excel knowledge. … Continue reading
This is a simple tip that most secretaries and executive assistants love. 🙂 Did you ever look up someone’s full name in Outlook or email directory? It happens especially if you are working in a multi-national company and you are … Continue reading
A simple trick to align objects neatly. 🙂 Did you move the objects one by one and then realized that it took you forever to have them perfectly aligned? Why not using the “Align” under Drawing Tools?
SUMIF is a handy but helpful function. The syntax is simple: =SUMIF(range,criteria,[sum range] What it does is quite straight forward indeed. In the example above, it instructs Excel to look into the range (A2:A7), look for the matching criteria, which … Continue reading
If you do chart in Excel, you may have encountered this: You clicked on a chart object, tried to move it just a little bit to the right by pressing Right Arrow key a few times… Instead of the chart being moved … Continue reading
I hope you will never run into a situation like this… 🙂
Recently, I’ve been collecting Excel files from colleagues regarding implementation status of some activities in the region. Part of the template looks like the screenshot below: Quite simple and straight forward, right? I expected I would get something like the following in … Continue reading
Did you spend too much time to move cells so that there are no blank cells in each column? Again, a picture tells thousand words. Here’s the task… Would you do it this way? Or this way? What did I do … Continue reading
If you do Pivot Table, the following won’t be a stranger to you as you must do a lot drag and drop to pivot. But did you know that you may insert a field name and / or swap the … Continue reading
Did you know… you can create a list of Month and Day of Week by drag and drop? You probably knew it on the first week of your Excel journey… But did you know that, Excel may also give … Continue reading
Got a question about how to extract the date of birthday (DOB) portion from an ID number like 63102400965, where the first 6 digits represent the DOB, so that we could use the date for other calculation. In this example the DOB … Continue reading
Customized Ribbon and QAT is very common. I believe all serious Excel users will have their own customized Ribbon and QAT according to their own working habits. I rarely share my customization with others and I am not going to … Continue reading