[Affiliate]
Blog Stats
- 3,289,896 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- #Excel Add current selection to filter. What it does?
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Limitation (or bug?) with Filter by Color
- Show number in thousand (k) or in million (M) by using custom format
- Dropdown calendar in Excel
- Contact
- SUM vs. SUBTOTAL
- Create Sequential Numbers in #Excel Easily
- Combine files in a folder with Power Query in #Excel
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
How to calculate number of overlapping days for two periods?
Have you ever encountered a situation that you need to find out how many days in Period 2 fall into Period 1? Is using IF(IF…(IF…(IF…(IF….. the first thing in your mind?
Advantages of having date input correctly in Excel
In previous posts, what do we need to know about inputting date in Excel was discussed.  Suggested solutions for fixing trouble dates were also given.  But WHY having date input correctly in Excel is so important? Why should we care? Answer: It’s … Continue reading
Fixing trouble dates
Different ways to convert dates stored as text or other unrecognized date formats to real dates in Excel. From time to time, we work with dates in Excel files.  Well, if dates were input correctly as serial number, everyone is happy. … Continue reading
What we need to know about inputting Date in Excel?
When you type “1/5/2015” into Excel, do you know whether it is “1st of May, 2015” or “5th of January, 2015”? The answer: It depends! Depends on what? Â
Are you sure you have input a date correctly in Excel?
Although they sound like basic questions, I am quite surprised that many colleagues are not aware of the different ways to input date in Excel “correctly”.  I would like to understand the situation of other Excel users by putting a poll … Continue reading
2D SUMIF with two variables â one on column and one on row
SUMIF is a commonly used function to give you sum of a range that meets a specific criterion.  For the example above, if you want to know the total expense of Department 1 in Jan, you can use SUMIF: The Syntax … Continue reading
Clear or Delete? A hassle-free way to clear everything in a cell
Do you have a habit of right-click a cell and Delete it rather than pressing the “Delete” button on keyboard? If you do have this habit, I guess you possibly are frustrated by the following experience before:
How Excel formula can save your time?
Extract number from a text string This post is about two things: How a poor system set up could drive you crazy? Why being good in Excel could save you lots of time in workplace? Another real work example.  I was … Continue reading
Copy and Paste table while keeping column widths
A simple trick (click) can save you lots of time. Below is a commonly seen scenario in my work life: A user wanted to copy a table to a new worksheet/workbook, what he/she normally did was CRTL C then CTRL V. The … Continue reading
Move cells by Right-click Drag and Drop
How to swap adjacent cell quickly? How to insert new items in the middle of a table? How to move cells more efficiently?… by using mouse… Last week, I learned from Debra Dalgleish to convert formula into value by using mouse.  What … Continue reading
Allow time input at 15-min intervals only – Data Validation
How to limit user to input time at 15-min intervals, i.e. 00:15, 00:30, 00:45, 01:00, etc.? We talked about how to limit user to input Time in the previous post.  Let’s go one step further with Custom Data Validation, where you … Continue reading
Data Validation – TIME
How to limit user to input TIME only? Sometime, actually too many times, users may not input cell content in a way you want them to. Â As a result, the formula you set for calculation may go wrong; and you … Continue reading
Fill Series
Auto Fill is a very handy feature in Excel. Â I believe many users use it every day. Â A simple example is to fill a list of sequential numbers, say from 1 to 18. What you need is to input 1 … Continue reading
Remove gridline
By default, gridline is not printed on paper.  Nevertheless, I would usually remove gridline when I submit my report, or paste part of a spreadsheet into PowerPoint or Word.  Why? Simply for better look and feel. See the screenshots below to … Continue reading
Remove Line Break instantly
Two different ways to replace Line Break with a space QUICKLY If you are trying to build a table of data which is analysis-friendly, DO NOT use line break in your fields and labels. Â Otherwise, you will create unnecessary steps … Continue reading
Input line break in a cell – ALT ENTER
In Word, it is so simple to input a line break by pressing Enter. Â However in Excel, pressing Enter will take you to the cell below. To input line break in Excel requires just a simple key combination. Â What you … Continue reading
Text Alignment – Distributed
Let’s continue the topic of uncommonly used text alignment.  This time, it’s Distributed. Honestly, another format rarely used in my work life.  So what is it about?
Text Alignment – Fill
We talked about examples of using “Text Alignment – Indent” in the previous post. Â In the coming posts, let’s talk about the rest of the less commonly-used text alignments. Â Actually, I find it a bit challenging to cite real-life examples … Continue reading
Text Alignment – Indent
There are different types of (horizontal) text alignment in Excel. Â Most people know about (and use mainly) General, Right, Center, Left. Â But are you aware of Indent, Fill, Justify, Centre Across Section and Distributed? Let’s talk about Indent this week. … Continue reading
OMG – I forgot SAVE…
“I started a new workbook. Â Worked so hard to create a report from scratch. Â Meanwhile I opened many other workbooks to get the data I needed. Â Then I realized that too many workbooks were opened. Â I closed some of them … Continue reading
wmfexcel 