Monthly Archives: December 2017

Season’s Greetings 2017

Posted on December 23, 2017 by

Ho…Ho…Ho… Merry Christmas! Wish you and your beloved ones a Merry Christmas and a Happy New Year of 2018! The above is made of #Excel of course… You may download a copy Seasons Greetings 2017 if you like it. 🙂 … Continue reading →

Rate this:

Posted in General | Tagged | 2 Comments

#,##0, k or #,##0.0, k ? Why not both?

Posted on December 16, 2017 by

Conditional Custom Formatting in #Excel Got the following question: This gives me £28.8 K (if 28800 is input) and £28.0 K if 28000 is input. I was rather hoping that if there was no decimal after the thousand, ie £28 … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , , | 6 Comments

Get a list of pending tasks and sort by due dates

Posted on December 3, 2017 by

A common task – Get and sort a list of tasks that are not yet due according to due dates Got the following question: Suppose on column A I have entries and on column B i have due dates for … Continue reading →

Rate this:

Posted in Excel Tips | Tagged , | Leave a comment

Learn Excel Dashboard skills before end of 2017

Posted on December 2, 2017 by

Can’t believe it is already December.  Is learning Excel Dashboard one of your 2017 new year resolutions, that has not yet accomplished? If so, here’s a good news for you: Mynda Treacy’s popular FREE Excel Dashboard Webinars are opened for the … Continue reading →

Rate this:

Posted in General | Tagged | Leave a comment