[Affiliate]
Blog Stats
- 3,287,223 hits
-
Join 3,246 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Copy data from strictly-protected sheet
- When unhide row doesn't work...
- Dropdown calendar in Excel
- Bug with copy and paste in Excel Table
- Convert an 8-digit number into Excel-recognizable Date
- Simple trick to look (hack) into hidden sheet
- Sequential number for visible rows only
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- How to lookup an image in #Excel
- Limitation (or bug?) with Filter by Color
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
5 years of blogging
Totally forgot I put my first post here 5 years ago. Time really flies! Thanks for flying with me. 🙂
Posted in General
Leave a comment
[Share] – Threaded Comments in Excel 365
Last week, I told you that my Surface Pro 4 is out of service, and I am waiting for a new laptop for writing my Excel blog… until late September or early October. That was the plan. Although I am … Continue reading
(: Late summer break :)
Today, I am not talking about Excel although I would like to. Why? Because my Surface Pro 4 is out of service… 😦 It has been out of order a few weeks ago… the moment when the warranty period was … Continue reading
Posted in General
Leave a comment
#Excel Humor #15 – Performance Review
Feel free to share this formula to your friend / colleague whom you think applicable… 🙂 He/She knows the answer. 😛
Same day last year…
Avoid Overthinking Getting same day of last year using Excel formula In retail, it’s very common to compare sales of same day, not same date, of last year. If you are not in retail sector, you may wonder what is … Continue reading
Load multiple #Excel Tables as separate #Queries quickly…
To load an Excel Table into Power Query is easy. Just click into any cell of the Excel Table, and then click the From Table/Range button (depends on which version you are using, this button resides in different location on the … Continue reading
Posted in Power Query
4 Comments
Change the first letter to upper case, first word only please #Excel
This is a short story of mine, and an imaginary conversation in my head… How to change the first letter (of first word only) to upper case in Excel? This was a question from a colleague sitting opposite to me. … Continue reading
Creating % of Total, Running Total in a few clicks with #Excel Quick Analysis
This post is about showing you how to perform a common task of adding a column of % of Total Running Total with Quick Analysis in Excel 2013 or later. Latest Excel makes things easier, just that you may not be … Continue reading
No more Copy and Paste to combine tables with #PowerQuery
Basic of Append Query in #PowerQuery With no doubt, combining multiple tables (mostly on different worksheets, or even in different files) into a single “master” table for further analyses is one of the most tedious tasks we deal with Excel … Continue reading
Top 40 Excel Blogs by Feedspot
What an honour and pleasant surprise to be selected as one of the Top 40! Recently I am quite busy (and moody) at work, I mean the real work at office. You must be thinking my works involved using Excel … Continue reading
Posted in General
Leave a comment
#PowerQuery makes advanced VLOOKUP so easy!
Do you use VLOOKUP? If you do, you should know there are limitations to VLOOKUP. Also, there are some cases VLOOKUP is not straightforward and efficient. Consider the following cases: What we want to achieve is to map the corresponding … Continue reading
Display descriptive words instead of numbers with Custom Format in #Excel
Sometimes we want to add a descriptive like “Good Job” for figures above target; “Work Harder” for those below… like the following screenshot: To many people, the top-of-mind solution should be using IF function. =IF(A2>0, “Good Job”, IF(A2=0, “Just Met”,”Work … Continue reading
Maintain a price book in #Excel with #PowerQuery
Feel the Power (Query) This is my first post devoting to my recent love for Excel – Power Query. 🙂 First, let me make myself clear. I am still learning Power Query (indeed I am still learning Excel too). The … Continue reading
Create your own favorite keyboard shortcuts in #Excel without VBA
Make better use of the Quick Access Toolbar (QAT) We all know that shortcuts could save us lots of time when working with Excel. Excel has many built-in shortcuts. Ctrl+C, Ctrl+V should be the most popular and commonly used … Continue reading
#Excel Humor #14 – Insert Table
I am having an incentive trip in Osaka… not sure if this is due to my Excel skills. 😛 So let’s have fun this week. 🙂 What would you say if you were the interviewer? Leave it in comments. … Continue reading
How to remove leading space in #Excel
When TRIM and CLEAN do not work… Is it something bothering you? To fix this problem, we need to understand where is the “leading space” coming come. Before we jump to that, I want to show you two Excel functions … Continue reading
Save a Read Only copy
When we have created a wonderful #Excel template that is to be shared with others, we don’t want users to distort, if not destroy, the template someday. Nevertheless we would like to leave as much “flexibility” as possible to users … Continue reading
wmfexcel 