Excel Excel - Numbers in icon format -

To increase the visual impact, turn the % or # format into a picture and catch attention, I use the conditional format...Home .... > Conditional formatting...> Icon sets

Useful, eye catching and visual management...

Read and share ~ Challenge

Like the quotes:

~ When you can't control what is happening around you, challenge yourself to control the way in which you respond...that is your true power lies

~ But at some point you have stop being so angry, you have to stop being so sad, you have to start being gentle with yourself.

~ At some point you have to just let it all go and be happy, you have to spread love instead of being afraid of it.

~ You have to love yourself and everyone around you before it's too late.

~ Don't waste away being unhappy over trivial things.

~ Don't do it, don't do it to yourself and don't let other people do it to you.

Excel Excel - Display a sheet name in a cell -

* While I was organizing a audit file, there are over 55 samples need to group into one file. Want to get Excel to show the sheet name automatically in a cell so avoid to type the sample# for every sheet...*

How to display a sheet name in a cell:

- Location of the cell is B1

- Then the formula:

=MID(CELL("filename",B1),FIND("]",CELL("filename",B1))+1,255)

Excel Excel - Date and Julian Date format -

* Helped a co-worker to solve his questions, and make my own notes *

How to transfer between Date and Julian Date format 


Date: May 1, 2017 (A6)

Julian: 2017121  (B6=YEAR(A6)&TEXT(A6-DATE(YEAR(A6),1,0),"000")

Reversed back  (C6=DATE(LEFT(B6,4),1,RIGHT(B6,3))

Coffee to start ~

最近这几年, 一天的开始通常是一杯黑咖啡, 接着的时间里是绿茶, 再后面就是柠檬水了~

这样, 我可以一整天做事, 不会觉得太疲倦

原来, 和数字有关的工作, 大有乐趣

也是这几年, 觉得自己也可以一整天, 一整天从处理, 分析, 运算中, 感到平静与快乐

很大的改变

Welcome back!

Rabbit told me to continue my blog life ~
"Welcome back!". I like this sentence, since it maybe my boss or one of my co-workers resume to their work after the long and happy vacation. They talk about the funny stories during their journeys and that reminds me a lot, I used to travel different places, but now I've settled down.
Who knows, maybe one day we will go for an adventure somewhere again.

后院的邻居

不知道从什麽时候起， 房东的后院里经常看到邻居们的身影