- 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
- Convert an 8-digit number into Excel-recognizable Date
Category Archives: Excel Tips
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
You probably knew it… when we make a direct reference to a cell, i.e. input =A1 in A2, the cell A2 will then follow the number format of A1. Put it in other words, if the number format of A1 is … Continue reading
Which one of the following charts use better colors? It is not surprising if you prefer the one on the left as the colors used are of high contrast. However, will you change your mind after you read the same … Continue reading
This title sounds a bit silly, but I do believe many users must have experienced frustration when they tried to input a fraction number as simple as 1/2 in Excel. When we input something like x/y, Excel assumes that we are … Continue reading
Let’s bring the Excel file from stone age back to modern world. A few years ago, my company switched from Office 2003 to Office 2007. I was one of the very few who felt excited about the change. On the … Continue reading