Category Archives: General

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

Last Chance for Power BI and Excel Dashboard courses by Mynda Treacy

  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

Rate this:

Posted in General | Tagged | Leave a comment

Free webinar on Power BI by Mynda Treacy is coming soon

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

Rate this:

Posted in General | Tagged , | Leave a comment

The 5-minute Excel Dashboard Challenge @ Bacon Bits

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

Rate this:

Posted in General | Tagged | 4 Comments

Happy New Year of Rooster

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

Rate this:

Posted in General | 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

Rate this:

Posted in General | Tagged , | 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

Rate this:

Posted in General | Tagged , | Leave a comment

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

Rate this:

Posted in General | Tagged , | Leave a comment

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

Rate this:

Posted in General | Tagged , | Leave a comment

Excel Humor #8 – iLOOKUP, the ultimate function in using Excel

Have you ever used “i”LOOKUP?  I do it almost every day…   🙂  

Rate this:

Posted in General | Tagged | Leave a comment

Excel Humor #7 – Interactive Report

I hope you will never run into a situation like this… 🙂

Rate this:

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

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

Rate this:

Posted in General | 4 Comments

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

Rate this:

Posted in General | Tagged | 2 Comments

Transform boring Excel reports into Business Intelligence 

Dashboard Course by MYNDA TREACY is now open Last week, I shared the news about the free Excel Dashboard Webinars by Mynda.  I hope you did find a time to join the webinars. If you haven’t watched the Webinars and … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Excel Humor #5 – Are you relying on Excel too much?

Are you an Excel Dependency? Do you use Excel even for simple maths?  Sometimes I do. 🙂  

Rate this:

Posted in General | Tagged | Leave a comment

Excel Humor #4 – Excel is the perfect tool for…

Like and/or share this post if you agree it.  🙂

Rate this:

Posted in General | Tagged | 1 Comment

Boost Excel Skill with Pivot Table

I think I must have missed the email from Mynda Treacy regarding the Xtreme PivotTables Course on her site: myOnlineTrainingHub, otherwise you should have read this post earlier. I use Pivot Table a lot and consider it a must-have skill … Continue reading

Rate this:

Posted in General | Tagged | 1 Comment

Lost in colors

Which one of the following charts use better colors? It is not surprising if you prefer the one on the left as the colors used are of high contrast. However, will you change your mind after you read the same … Continue reading

Rate this:

Posted in Excel Tips, General | Leave a comment

Allen Wyatt’s Excel Macros for Beginners course – Registration Ends Thursday

Earlier this month I let you know about Allen Wyatt’s Excel Macros for Beginners course. He only opens the doors to the course a few times each year, and he’s already busy helping those who have signed up for the … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment