- Follow wmfexcel on WordPress.com
Top Posts & Pages
- When unhide row doesn't work...
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- Copy data from strictly-protected sheet
- Show number in thousand (k) or in million (M) by using custom format
- Advanced vlookup - Text vs. Number
- Advanced vlookup - wildcard characters "?" and "*"
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- 2D SUMIF with two variables – one on column and one on row
- Open an embedded Excel file during a slide show in PowerPoint?
Author Archives: MF
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
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
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
This post is inspired by the previous post Excel Humor #9 – You do not see me Situation Suppose you are going to share an Excel workbook to your colleagues. However there is a worksheet with sensitive data that you don’t want them to … Continue reading
This is a true story with modification… I can’t believe it happened when I first heard it, but then I realize some changes made on Excel 2016 (not sure if also in Excel 2013). Here’s today humor: If you are working … Continue reading
As an Excel user you’ve probably created the occasional report. You may even regularly create Excel Dashboard reports. After all, Dashboards are the most value-adding element for Excel users. However, if you’ve used Excel to build dashboards then you probably … Continue reading
First of all, this blogpost is about Pie Chart, but not about how to make a Pie Chart. Indeed, I am not going to show the steps of making Pie Chart here. Also I am not intended to discuss whether … Continue reading
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
Have you heard about Power BI from Microsoft? Probably yes. However I guess most people are not yet aware of this amazing BI tool from Microsoft that enables you to build stunning interactive dashboards and share them on any device. If you want … Continue reading
Have you ever thought of building an Excel Dashboard in 5 minutes? Yes, only 5 minutes. That’s why it is a Challenge! You may find the details of The 5-minute Excel Challenge at Bacon Bits. Honestly, I haven’t thought … 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…
Hi everyone, Today we celebrate the Chinese New Year🐔. No Excel tips but CNY greetings and blessings. Wish you a prosperous and rewarding new year ahead! Continue to excel. Cheers, MF
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
Dear readers, Merry Christmas!!! Wishing you and your family a healthy, fruitful, rewarding and Happy New Year of 2017! See you next year! p.s. Should you want to play around the Excel Card above, here’s the christmas-tree! Tip: Hold F9 for … 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?