[Affiliate]
Blog Stats
- 3,289,835 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"
- Limitation (or bug?) with Filter by Color
- Rename column names in a dynamic way with #Excel #PowerQuery
- Calculating CAGR with Goal Seek in #Excel
- Show number in thousand (k) or in million (M) by using custom format
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- #Excel Add current selection to filter. What it does?
- F7 - It is about word
- #,##0, k or #,##0.0, k ? Why not both?
- Learn how to build effective #Excel Dashboard from Mynda Treacy
My YouTube Channel
My Facebook page
- My Tweets
Author Archives: MF
Fill so good…
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
Transpose Data (Static and Linked)
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
Posted in Excel Tips, Formula
Tagged Array formula, Copy and Paste, Find and Replace, Paste Special, TRANSPOSE
2 Comments
5 Little Excel Tips (tests)
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
Posted in Excel Tips
Tagged Copy and Paste, Date, Fill, Find and Replace, Paste Special
Leave a comment
Merry Christmas
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
A tip of using AutoCorret to input names quickly
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
Are we aligned?
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?
Posted in Excel Tips
Leave a comment
Turn boring Excel reports into Business Intelligence – Excel Dashboard
Last week I told you about the awesome Excel Dashboard Webinar  was back.  I hope you had a chance to watch it and get something already.  If not, it’s not too late.  But hurry seats and sessions are limited with … Continue reading
Free Excel Dashboard Webinars by MYNDA TREACY is back
If you have been following my blog for more than three months, you should have read this before. Â If you wonder why I am reposting it again and again (Yes, this is the 3rd time I write about Mynda’s Excel … Continue reading
Be cautious when using SUMIF(s)
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
Posted in Excel Tips, Formula
6 Comments
Move a chart object with arrow keys
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
The powerful Power Query and the interesting TechNet Virtual Labs
As you may be aware of, I haven’t written a real blogpost recently.  I was super busy at work in the past month.  No surprise.  There are moments Excel won’t help me much at work, especially when bosses like PowerPoint (and PDF) … Continue reading
Excel Humor #8 – iLOOKUP, the ultimate function in using Excel
Have you ever used “i”LOOKUP? Â I do it almost every day… Â đ Â
Excel Humor #7 – Interactive Report
I hope you will never run into a situation like this… đ
What is a “Container Chart”?
First of all, I would like to thank Chandoo for suggesting this name for the chart I submitted to him for a charting contest a few months ago.  What’s more surprising to me is I was one of the winners of … Continue reading
Insert “tick in a box” in Excel
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
Three years of Excel Blogging – A quick review
Note: This is not an Excel post… I totally forgot that today is the 3rd Anniversary of my Excel blog. Â Time really flies. Â Thanks WordPress for sending this 3rd Anniversary notification to me. Â What’s a pleasant surprise! đ Did you … Continue reading
Posted in General
4 Comments
Move cells with data to the top
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
Excel Humor #6 – Probably the shortest and the best Excel Proficiency Test
Definition of Advanced Excel user varies according to expectation. Â Someone thinks advanced users should know all the VBA, Pivot Tables and be able to write super long formula. Â Someone considers oneself “Advanced” for knowing the basic of VLOOKUP. Â On … Continue reading
Insert or move a field into Pivot table without drag and drop
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
Writing a long formula in steps
Writing a long formula is not easy, even for an advanced Excel user.  What I mean long is  a formula with many nested FUNCTIONS within a single formula.  The difficulty I am talking about is not related to whether you understand the … Continue reading
wmfexcel 