Awaiting New Year - 2011

I'm already stressed out this year. Already awaiting new year and started to count down. For all who are already exhausted like me, I created a file that counts down days, hours minutes and seconds to step into new year.

Just a preview of the file I created.

What are you waiting for? Go ahead click here and download the New Year Count Down file. I created this in Excel 2007. So, you can open thisin Excel 2007 and above. But if you are in Excel 2003 and you have a translator you can still use this.

Wishing you a very happy and prosperous new year in well advance.









Few techniques I used to create new year count down file are:

Go To Special series. Select visible cells only

Welcome to the nineth post of this series. Hope you are enjoying this series. Click here to read to navigate to go to special.

What are visible cells?

How often you filter the data in your spreadsheet? How often you hide some rows or columns from your data? I know your answer. Quite a number of times...Correct? If your answer is yes then read on and answer some more questions patiently.

How often you want to select and copy only the data you filtered and how often you want to select and copy only the rows / columns that are visible (excluding the hidden rows and columns)? This option is for you if you have failed copying this data and ended up pasting the whole set of data instead of only the filtered / visible data.

Go To Special series. Select Last Cell

Welcome to the eighth post of this series. Hope you are enjoying this series. Click here to read to navigate to go to special.

Select Last cell. Cell that has data and / or formatting. This is one of those most used excel option people often use.

Most often we need to go to the last cell in the worksheet we are working.