Category Archives: General

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

Don’t Miss Out on the Early Bird Registration for Allen Wyatt’s Excel Macros for Beginners course

About a week ago I let you know about Allen Wyatt’s Excel Macros for Beginners course. At the time, I invited you to visit Allen’s overview for the course, and I told you that you could register for this excellent … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

An example of using Solver for a causal problem in daily life

This post is intended to give you an example of using Solver in Excel to solve a causal problem in daily life – buying postal stamps.  Don’t consider it a tutorial. 😛 Have you ever heard of Solver in Excel? I think … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Want to learn Macro? Here’s the chance.

If you have been following my blog, you should know that I focus on tricks and tips of “preset” ways in Excel. For some people, using those preset ways is enough, but for others, Excel may be a bit restrictive … Continue reading

Rate this:

Posted in General | Tagged , | Leave a comment

Excel Humor #3 – Advanced User

Happy New Year!!! Wish you a happy, healthy and prosperous year of 2016. In a word, wish you EXCEL in 2016! 🙂 Let’s start the year with FUN!

Rate this:

Posted in General | Tagged | Leave a comment

Excel Humor #2 – Compact view

Rate this:

Image | Posted on by | Tagged | Leave a comment

Excel Humor #1 – Home

I am now having fun somewhere in Tasmania; enjoying my vacation  🙂 So let’s have fun this week and the next.

Rate this:

Posted in General | Tagged | 2 Comments