Author Archives: MF

Interactive Chart is not difficult to make – Part 3/3

Using Option Button to display different items on chart So far, we have made an interactive chart with check box to highlight items with negative growth; with scroll bar to see more items in a confined space.  In this post, … Continue reading

Rate this:

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

Interactive Chart is not difficult to make – Part 2/3

Using Scroll Bar to show more This is an extension of the previous post – Using Checkbox to highlight negative growth in a bar chart.  In that post, we had created a chart showing top 10 items, which allowed user … Continue reading

Rate this:

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

Interactive Chart is not difficult to make – Part 1/3

Using Checkbox to highlight negative growth in a bar chart In previous post, we talked about the basic of Form Controls.  I hope you had time to practice it and found useful way of building interactivity to your spreadsheet. In … Continue reading

Rate this:

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

The awesome Dashboard course by Mynda is closing

Hurry, Last Chance for Free Dashboard Webinars & Course Just a quick reminder that registration for the awesome Excel Dashboard and Power BI courses, by Mynda Treacy closes on Thursday July 13, 8pm in Los Angeles, to be exact. Learn … Continue reading

Rate this:

Posted in General | Tagged | Leave a comment

Excel Humor #11 – CEO

A lazy Sunday in summer… let’s have some Excel humor. 🙂

Rate this:

Posted in General | Tagged | Leave a comment

Are you ready to turn boring Excel reports to Business Intelligence?

Well, I know.  You may have read similar topics before in my blog.   You are now seeing it again because the awesome Excel Dashboard Course by Mynda Treacy is now open.  What’s more exciting?   Mynda puts her popular courses “Excel … Continue reading

Rate this:

Posted in General | Tagged , , | Leave a comment

The basic of Form Controls

Want to work like an Excel Pro?  Learn more about Form Controls. Have you seen someone using Check box, Option Buttons, Scroll Bars on their worksheets and be impressed?  You may wonder how they made it and think that is … Continue reading

Rate this:

Posted in Excel Tips | Tagged | Leave a comment

Excel Humor #10 – WannaCry moments in Excel

      There must been many others.  Please share in comments. 🙂

Rate this:

Posted in General | Tagged | Leave a comment

The amazing SUMPRODUCT

Advanced use of SUMPRODUCT for multi-conditional SUM In the previous posts, we talked about the basic of SUMPRODUCT, the behaviors of logical  values (i.e. TRUE/FALSE) when they are put into basic mathematics operations.  These set the foundation to understand the … Continue reading

Rate this:

Posted in Formula | Tagged , | 2 Comments

The logic gate

Have you heard about Logic Gate?  I learned logic gate in high school physics.  Decades ago… so don’t expect I can remember what it is.  😛 Having said that, I do remember the fundamental concept about AND gate and OR gate, … Continue reading

Rate this:

Posted in Formula | Tagged , | 4 Comments

SUM the PRODUCTs or SUMPRODUCT? That’s the question.

The basic of SUMPRODUCT Suppose we have a column showing retail price of different items; another column showing the units sold (illustrated above).  To get the total sales, most people will deploy a helper column to get the sales of each … Continue reading

Rate this:

Posted in Formula | Tagged | 2 Comments

CrossTab SUM with 3 variables

This post is trying to answer a question by Laura in the post of 2D SUMIF with two variables – one on column and one on row. Here’s part of the question: ……I want to look up the department in the vertical … Continue reading

Rate this:

Posted in Formula | Tagged | 3 Comments

Sort Warning?!

Sorting is one of the basic features in Excel.  I believe most Excel users, if not all, know how to sort in Excel.  Without any scientific research, I think most users would click the “Sort A to Z” (ascending order) … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 1 Comment

[Guest Post] 5 things you should start doing with Power Query

This is a guest post by Puneet Gogia. Power Query is a revolution. It’s a (part of a) complete self-service BI tool which can help you in importing, connecting, shaping, cleaning and sharing your data with little efforts. It has … Continue reading

Rate this:

Posted in Excel Tips | Tagged | 11 Comments

Adding bullet to each line in cell

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

Rate this:

Posted in Excel Tips | Tagged , , | 4 Comments

Quick Tip: Undo the “Undo”

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

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Remove hidden sheets with “Inspect Document” or VBA

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

Rate this:

Posted in Excel Tips | Tagged | 4 Comments

Simple trick to look (hack) into hidden sheet

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

Rate this:

Posted in General | Tagged | 11 Comments

Excel Humor #9 – You do not see me

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

Rate this:

Posted in General | Tagged | Leave a comment

Interactive Chart with navigation panel [NO VBA]

Isn’t it nice?  Don’t think that this is difficult.  No VBA is required.  Indeed you only need to know a few Excel skills in order to create an interactive chart  with navigation panel like this. The skills required: Conditional formatting … Continue reading

Rate this:

Posted in Chart | Tagged , , , , , | Leave a comment