Category Archives: Excel Tips

Distinct count using functions in #Excel 365 is so easy

Have your ever wanted to count how many distinct items in a range? Though a common task, there was not build-in functional for it. Perhaps we can make a distinct list using advanced filter first then we count the outcome. … Continue reading

Rate this:

Posted in Excel 365, Excel Tips, Formula | Tagged , , | Leave a comment

Copy values from Status Bar in #Excel 365

You probably knew it… In Excel, when multiple cells are selected, we will see basic statistics of the selected cells in status bar: This is a very handy feature. But did you know… this handy feature has a nice touch … Continue reading

Rate this:

Posted in Excel 365, Excel Tips | Tagged , | Leave a comment

Workbook Statistics in #Excel 365

Whichever version of Excel you are using, you will see a lot of useful information about your worksheet/workbook in the Status Bar. Having said, many users are not aware of the presence of the status bar. Are you one of … Continue reading

Rate this:

Posted in Excel 365, Excel Tips | Tagged | Leave a comment

Unhide multiple sheets with #Excel 365

Photo Hunt time – What are the differences between the two screenshots? Three, Two, One… Answer: Did you see it? The long-awaited feature is finally here in Excel 365. The next question is how?

Rate this:

Posted in Excel 365, Excel Tips | Tagged , | Leave a comment

Unselect selected cells with #Excel 365

First of all, I wish you a happy, healthy, and Excellent new year of 2023! Unselect selected cells Maybe you knew this already … we can select multiple cells/ranges by holding CTRL key. However, there was no way to unselect … Continue reading

Rate this:

Posted in Excel 365, Excel Tips | Tagged , , | Leave a comment

Will Power Query change your life?

Well, it depends! Depends on what? It depends on what you do and how you do it in Excel. 😉 True/False moments Excel is the core software I use for work I use Excel for data analysis I need to … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Quick Tip – Edit #DAX formula in #PowerBI Desktop efficiently

Let me share a quick tip of Power BI today coz I work with Power BI Desktop a lot recently. 😎 What I am going to share in this post is my favorite shortcut key in Power BI Desktop. Honestly, … Continue reading

Rate this:

Posted in Excel Tips | Tagged , , | Leave a comment

Highlight differences in two ranges with Conditional Formatting in #Excel

Happy New Year! Wish you all an Excellent Year of 2022! To kickstart the year, let’s share a trick to solve a common task – highlighting differences in two ranges, with conditional formatting. Common enough, right? The ingredients are simple, … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 1 Comment

Highlight different cells in two lists in #Excel

Finding and highlighting differences should be a common task in Excel. Most of the time, it’s solved by formula or conditional formatting. Either way, we need to construct a simple formula like the one below to compare the cell contents … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Do Not input “-” for zero. Use proper formatting in #Excel

Do you input a hyphen to represent zero? If you do, please stop doing so in the future. The proper way of displaying “-” for zero is to apply relevant cell format to it. E.g. Using Accounting format with no … Continue reading

Rate this:

Posted in Excel Basic, Excel Tips, Format | Tagged , , , | Leave a comment

Convert numbers of different digits into text of fixed digits in #Excel

The situation We have an extensive list of numbers in different digits, say from 10 to 13 digits. The problem is, they are supposed to be numbers in thirteen digits stored as text. (Of course, in our example, we work … Continue reading

Rate this:

Posted in Excel Tips, Formula | Tagged , | Leave a comment

7 Copy and Paste Tricks I wish I knew sooner in #Excel

Regardless of what we do with Excel, Copy and Paste is something we do on daily basis… or even hourly basis. 😁 You may be thinking, every one knows Copy and Paste. Yes, probably. But is every one using Copy … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Protect your cells in #Excel

Think about this… you have spent hours of work building your wonderful Excel template. Needless to say there are lots of formulas that took you hours of thorough thoughts and considerations, on top of the beautiful formats and layouts. You … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

[Video] – Swap cell contents with a simple mouse trick

It is super easy to move cells around by drag and drop. The standard drag and drop action however replaces contents in the destination cells. What if we want to preserve destination cells and just shift them up or right? … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

SUMIF vs. GETPIVOTDATA in terms of performance in #Excel

Did you experience a slow workbook? How slow? Let’s say it takes more than 2 minutes to just open the file. This is actually what a colleague asked me for help. When I opened the workbook, I saw LOTS of … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 3 Comments

The very hidden gem of AutoFilter in #Excel

Don’t get me wrong. I am not talking about the Filter button sitting on the Data Tab of ribbon, although they look almost exactly the same. I am pretty sure that most people who use Excel five days a week … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

The proper way to filter values not equal to zero in #Excel

I didn’t think of blogging about this topic before. I thought that it is so straight-forward. Nevertheless, there is another way of doing so which is even more straight-forward BUT may give you unexpected results later on. And to my … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Reapply Filter in #Excel

Did you notice that there is a “Reapply” button next to Filter on the Data Tab of ribbon? And wondering what it does? 🤔 Indeed, the “Reapply” button is dim until you have applied filter to at least one column. … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Data Cleansing is never easy, even with #Excel Power Query

Don’t make me wrong. I am not complaining Power Query at all. If you have followed me for a while, you should know that I am a big fan of Power Query indeed. It is simply powerful! With Power Query, … Continue reading

Rate this:

Posted in Excel Tips, General, Power Query | Tagged | Leave a comment

Filter: It’s easy and not easy

Applying filter in Excel is a very common task. We used to filter a dataset and focus on a subset of data that we are interested in. It is super easy to filter. The problem is, are you sure you … Continue reading

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment