Saturday, April 13, 2013

Help the earth by avoiding the useless prints and wastage of papers.


It’s not a request to “think only” to print or not.
It’s a request to not to print unnecessary documents.

As we believe that your thinking will not make any change, infact your change will ultimately change and make a difference.


Every day, people hit the print button even after knowing the fact that this particular print is just for their viewing purpose and not required to be filed as important. They also know and understand the effect of printing and wasting pages.
But why they do like this: - May be the following few points will give a clear idea for that: -
1.      They are not used to read the documents on the screen.
2.      It’s just a habit for some to go for printing as soon as some official correspondence is received.
3.      They believe it more convenient to make any correction on the hard copy and then forward or keep with them.
4.      They don’t care for the paper wastages and the global effect of the same.

In my official email id, I have around 13K mails and if I would have printed all of them, then they would be more than 50K (avg 4 pages per mails, excluding attachments)
I personally have seen many peoples who just go for printing the papers without having any necessary requirements. 

But is there any alternative for the same.
Yes we can save papers by just following the below steps: -
1.      Check before printing that this is the final outcome of the report you have prepared.
2.      Don’t print the casual conversations; only print the outcomes and final reports. For e.g. if you are in conversation with your client on the sales, offerings for your company’s products. In this case you have to focus on the PO only (i.e. Purchase Order) You don’t need to print what you offered earlier, how the negotiations gone, etc.
3.      Make a place in your office for rough papers. And inform all to use these papers when they print the uncompleted reports.
4.      Before printing, go for print preview. By this you can adjust your margins, etc so that you can exclude those papers which don’t contain anything to print.
5.      Use double sided prints. {Why do we use one side for printing when we can print on both the sides? Do we also use one hand even after having gifted by two hands by god}
6.      Recycle the office papers. Organize a meeting on this topic for the awareness of everyone in your office.
7.      Go Digital – You can store your files online also, only most important documents can only be printed.

I don’t know that how much the above article will impact on you and your understanding but definitely we need to change to make a change.

Finally it’s a fight between what you believe and what you do.

Thanks & Regards,
BS

The Excel Formula : TRIM, UPPER, LOWER & PROPER

Dear Friends,
Please find some useful formula for MS Excel. You can learn them, try them and apply them when you need them. If your database is huge then these are very useful to get the output easily in seconds.


TRIM

ColC
ColD

Row3
Original Text
Trimmed Text

Row4
        kuna
kuna
 =TRIM(C4)

Row5
k    u   n   a
k u n a
 =TRIM(C5)

Row6
  kuna             meher
kuna meher
 =TRIM(C6)

Row7
kuna
kuna
 =TRIM(C7)




What the use of this function / formula?



This function removes unwanted spaces from a piece of text.


The spaces before and after the text will be removed completely.


Multiple spaces within the text will be trimmed to a single space




Formula Syntax




=TRIM(TextToTrim)




Formatting




No special formatting is needed.







LOWER

ColC
ColD

Row3
Upper Case Text
Lower Case

Row4
kuna meher
kuna meher
 =LOWER(C4)

Row5
LITU GARNAIK
litu garnaik
 =LOWER(C5)

Row6
RAJENDRA BEHERA
rajendra behera
 =LOWER(C6)

Row7
NAVEen sharma
naveen sharma
 =LOWER(C7)

Row8
navEEN123
naveen123
 =LOWER(C8)




What the use of this function / formula?



This function converts all characters in a piece of text to lower case.




Formula Syntax




=LOWER(TextToConvert)




Formatting




No special formatting is needed.








UPPER

ColC
ColD

Row3
Original Text
Upper Case

Row4
kuna meher
KUNA MEHER
 =UPPER(C4)

Row5
LITU GARNAIK
LITU GARNAIK
 =UPPER(C5)

Row6
rAJENDRA beHERA
RAJENDRA BEHERA
 =UPPER(C6)

Row7
NAVEen sharma
NAVEEN SHARMA
 =UPPER(C7)

Row8
navEEN123
NAVEEN123
 =UPPER(C8)




What the use of this function / formula?



This function converts all characters in a piece of text to upper case.




Formula Syntax




=UPPER(TextToConvert)




Formatting




No special formatting is needed.




Example




See the example for FREQUENCY.








PROPER

ColC
ColD

Row3
Original Text
Proper

Row4
kuna meher
Kuna Meher
 =PROPER(C4)

Row5
LITU GARNAIK
Litu Garnaik
 =PROPER(C5)

Row6
rAJENDRA beHERA
Rajendra Behera
 =PROPER(C6)

Row7
NAVEen sharma
Naveen Sharma
 =PROPER(C7)

Row8
navEEN123
Naveen123
 =PROPER(C8)




What the use of this function / formula?



This function converts the first letter of each word to uppercase, and all subsequent letters

are converted to lower case. Useful when you have a database in which the data

has been entered without taking care of upper and lower cases.


Formula Syntax




=PROPER(TextToConvert)




Formatting




No special formatting is needed.







For any query on these formulas ,you can mail me at sharma.ctc@gmail.com