Search This Blog

Search Engine

Custom Search

20101231

For 2nd Hand computer purchasing in Pune-Bhosari

JAYALAXMI COMPUTERS

CONTACT VIKAS @ 99750 62542
CONTACT AJAY @ 99750 61867

NEXT DAY PC

Shop No. 1,
RAVIRAJ BUILDING,
Behind Umed Sweets,
Jay-Maharashtra Chowk,
Alandi Rd.,
Bhosari,
Pune - 411 039
Call 97634 65044

HDFC Bank, Just a Call Away - All General Inquiry nos. for HDFC Bank

Ahmedabad - 079 6662 3333
Bengaluru - 080 6600 3333
Chandigarh - 0172 469 3333
Chennai - 044 6600 3333
Kochi - 0484 408 3333
Delhi & NCR - 011 4151 4332
Hyderabad - 040 6600 3333
Indore - 0731 407 4332
Jaipur - 0141 500 3333
Kolkata - 033 2210 3838
Lucknow - 0522 400 3333
Mumbai - 022 2856 1818
Pune - 020 6609 3333 - Phone banking service - Local no. only in Pune
Call 6609 3333
Press * to continue
Dial 1 for Account related query
Dial 4 for Loan enquiry
Dial 03 for English
Dial 06 for Hindi
Dial 9 to speak to Phone Banker for any assistance

Gujarat - 98982 71111
Karnataka - 99458 63333
Punjab - 98153 31111
Tamilnadu / Pondicherry - 98406 73333
Kerala - 98956 63333
Himachal Pradesh - (Toll free) - 1800 180 4333
Andhra Pradesh - 99494 93333
Madhya Pradesh/Chhatisgarh - 98936 03333
Rajasthan - 98750 03333
West Bengal/Sikkim - 98310 73333
Uttar Pradesh / Uttarakhand - 98359 03333
Maharashtra (except Mumbai) /Goa - 98906 03333
Patna/Bihar/Jharkhand(0612) 223 3333
Assam/Orissa/Meghalaya/Tripura (Toll-free):1800 345 3333
Jammu & Kashmir (Toll-free) : 1800 180 4333

20101014

Blood Cancer Remedy

MEDICINE FOR BLOOD CANCER


MAIL COPY

Dear Indians,
I have forwarded it to the maximum I can.
Let it reach the 110 crores Indians and the remaining if aby.

If any of your beloved ones, got affected with Blood cancer,
then how u would have reacted, think it,Forward it.

'Imitinef Mercilet' is a medicine which cures blood cancer.
Its available free of cost at "Adyar Cancer Institute in Chennai".
Create
Awareness.

It might help someone.
Forward to as many as u can, kindness cost nothing.

For blood cancer free medicine is available at
Adyar Cancer Institute in Chennai.
Name of medicine is Imitinef Mercilet
Create awareness so that it can help someone

Address
East Canal Bank Road , Gandhi
Nagar , Adyar
Chennai -600020
Landmark: Near Michael School
Phone: 044-24910754
044-24910754 , 044-24911526
044-24911526 , 044-22350241
044-22350241


VERICIATION - Done on Google

1) Found not a hoax
2) True as per below link
http://www.hoaxorfact.com/Health/imitinef-mercilet-free-medicine-for-blood-cancer.html

20100701

10 Types of Excel file

Types of Excel file


  1. Excel 2
  2. Excel 3
  3. Excel 4
  4. Excel 5
  5. Excel 95
  6. Excel 97
  7. Excel 2000
  8. Excel 2002
  9. Excel 2003
  10. Excel 2007


DIFFERENCE IN THE LAST ROWS

  1. Last cell in Excel 2007 workbook is XFD 1048576
  2. Last cell in Excel 2003 workbook is IV 65536


-----------------------------------------------

How to unhide Developer tab in Excel 2007?

How to unhide Developer tab in Excel 2007?



Go to File ;
Then Go to Excel Options
Then Select Personalise
Place a check mark next to Show Developer tab in the Ribbon.
Click OK.
-----------------------------------------------


ANOTHER METHOD IN ANOTHER MICROSOFT VERSION



Go to File
Go to Excel Options
Click on POPULAR
The first Header on right side of POPULRA will be
 "Top options for working with Excel"
In that,
Click on 3rd option
"Show Developor Tab in the Ribbon"

How to copy the file which is password protected in excel?

-----------------------------------
How to copy the file which is password protected in excel?


  1. The file can be opened
  2. But can not be copied
  3. Hence cannot be pasted
  4. So save this file as text thru the "Save as" button.
  5. Please note password protected files can not be saved as web page but still these files can be
  6. saved as text
  7. Then select all text - copy it & paste it in new excel file
  8. The copy function in password protected file does not work but the paste function works.
  9. Take paste function for all sheet that is password protected.
  10. Means select the sheet & press paste function button
  11. Dump this button on the new excel file where text from text file is pasted


You will get same to same excel sheet without any changes in row or column or content with full formatting ie. borders, bold text etc.

How to activate Numbers given on JKL & UIO buttons on keyboard in Lenovo?

How to activate Numbers given on JKL & UIO buttons on keyboard in Lenovo

Press Fn button then press F7 button. F7 button has NmLk switch given in blue

By pressing Fn & F7 the Fn & NmLk gets pressed & JKL & UIO are deactivated instead 123 & 456 gets

typed everytime you press these buttons.

Again to return to JKL & UIO typings means alphabets to be typed by pressing this keys again

press Fn & then F7. By this again alphabets can be typed instead of nos.

Fn is the function button on left down corner of the keyboard
----------------------------------------------------------------

How to insert a tick box in excel & place remarks column in accordance with the ticks or blanks in the check box?

How to insert a tick box in excel & place remarks column in accordance with the ticks or blanks in the check box?

Check font awesome

Photo Source - Font Awesome by Dave Gandy - http://fortawesome.github.com/Font-Awesome [CC BY-SA 3.0], via Wikimedia Commons


Go to Developer tab
Go to Control & click INSERT
In Form click Check Box
Right click on Check box
Then click on properties
Assign a cell value
If you tick the check box the linked cell value gets converted into True
If you untick the check box the linked cell value gets converted into False
This way based on True & False derivatives you can give If then functions to get desired statements in front of the check box based on whether you tick or untick those boxes

INCOME TAX PROCESS - On Net

-----------------------------------------------------------
INCOME TAX PROCESS - On Net

Go to Income Tax Dept. Site
Register yourself with help of your PAN No.
A Form - Download it - ITR File
Fill Soft form
Convert into XML
Log in password
Upload on that site
Confirmation will be recd.
A PDF Document in soft will be recd.
Print
Sign
Put it in envelope
Put address
Send to Banglore

Duly signed ITR-V should be sent to address as below : -
Income Tax Department -
CPC,
Post Bag No - 1,
Electronic City Post Office,
Bengaluru - 560 010,
Karnatatak

How to send?
By ordinary post or Speed post only

Within how many days?
Within 120 days from the date of transmitting data electronically

At no other Income tax dept. other than this, the form accepted.

The confirmation of receipt of this FORM ITR-V at ITD-CPC will be sent to email address client.cadbnehere@gmail.com
----------------------------

How to get the Top 5 & Bottom 5 values in a table?

How to get the Top 5 & Bottom 5 values in a table

To get Top 5 values from a given column
Use formula
=LARGE(C4:C81,1) to find 1st highest value which can also be obtained from Max formula
=LARGE(C4:C81,2) to find 2nd highest value
=LARGE(C4:C81,3) to find 3rd highest value
=LARGE(C4:C81,4) to find 4th highest value
=LARGE(C4:C81,5) to find 5th highest value
where C4:c8 is the range from where top 5 values are to be selected

Similarly to find bottom 5 values from a given column
Use formula
=SMALL(C4:C81,1) to find 1st lowest value which can also be obtained from Max formula
=SMALL(C4:C81,2) to find 2nd lowest value
=SMALL(C4:C81,3) to find 3rd lowest value
=SMALL(C4:C81,4) to find 4th lowest value
=SMALL(C4:C81,5) to find 5th lowest value
where C4:c8 is the range from where bottom 5 values are to be selected

---------------------------

20100627

Night Trains after 9 PM from Kalyan to Pune

Trains after 9 PM from Kalyan to Pune

Train No. 1333+1329+1327 - Shirdi Fast Passenger, BB Bijapur Fast passenger & Fast Passenger
Starts at 23.55 from Kalyan
& reaches Pune in 4.15 hours@ 4.10 AM

Train No. 1005-CSTM Latur express
Starts at 21.50 from Kalyan
& reaches Pune at 00.50 AM in 3 hrs.

Train No. 2163-Chennai Express
Starts at 21.15 from Kalyan
& reaches Pune at 00.05 AM in 2 hrs. 50 min.

Train No. 1017-Chalukya Express
Starts at 22.15 from Kalyan
& reaches Pune at 01.00 AM in 2 hrs. 45 min

Train No. 1035-Sharavati Express
Starts at 22.15 from Kalyan
& reaches Pune at 1.00 AM in 2 hrs. 45 min.

Train No. 1013-Coimbatore Express
Starts at 23.18 from Kalyan
& reaches Pune at 1.55 AM in 2 hrs. 37 min

Train No. 2115-Siddheshwar Express
Starts at 23.35 from Kalyan
& reaches Pune at 2.10 AM in 2 hrs. 35 min

Train No. 1011-Mahalaxmi Express
Starts at 21.30 from Kalyan
& reaches Pune at 2.10 AM in 2 hrs. 35 min

20100608

How to remove spacings in text in excel?

CLEAN & TRIM FORMULA

Clean formula is used to remove space & nonprintable characters from text which is majorly imported from other systems.

But 1 or 2 etc. spacings created after writing a word bcos of which vlookup does not work can not be corrected by Clean Formula. We need to go for Trim formula for this

Clean formula
=Clean(C1) where c1 is text to be cleaned

Trim formula
=Trim(c1) where C1 is text to be trimmed

To trim means to remove unwanted spaces either between the text or at end or beginning of text

So space created bcos of Alt+Enter is removed by Clean formula but one or two spacings can not be removed by Clean formula. We need to use Trim formula for the same.

-----------------------------------------------

20100607

Google Desktop Search

Google Desktop Search
Download Link - google-desktop.en.lo4d.com/download/mirror-ex1
Present status - Discontinued by developer but still preferred to use by a lot of users inspite of shortcomings


Use Google desktop search button as 2nd option to find out lost files in PC if Microsoft search

buttons cannot find those files.

In finding files from PC - Microsoft search button is superior to Google desktop bcos display of

files is more convenient in Microsoft search button whereas in google desktop the same files are

displayed as webpage hence slightly not so user friendly to use

But Google desktop is superior from the point of view of extensive search bcos

- It can search even those excel files which are as an attachment in Outlook express. Hence

Google desktop search is more extensive as compared to Microsoft search button. Just the file

display is not so good. Hence if u r not able to find any file by Microsoft search button u may

take Google desktop as 2nd option & your lost files will be searched by Google desktop search

button.

Secondly Finding mails option is very superior in Outlook express but in Microsoft outlook the

finding option button does not help in finding out all files. Under such conditions Google

desktop installed slightly helps out bcos a Google desktop search button gets installed on its

own in Microsoft outlook & it helps in finding out mails. However this search gives only one

option for word as in Google web search button. Various buttons like Which subject, which date

etc. as given in Outlook express is not provided in the google search button which gets installed

in OE by its own.

When microsoft buttons are not able to find a particular file on our PC use Google desktop search

button & if the file is there in PC the google desktop button gets it for you. You just have to

scroll a number of pages to find out that file bcos Google finds out all files related with that

word which is not only in file name but also in file contents.

Did you know?

Excel lessons

Did you know?

No. of columns in xlsx / microsoft 2007 is 16384
No. of columns in xls / microsoft 2003 is 256 only


No. of rows in xlsx / microsoft 2007 is 1048576
No. of rows in xls / microsoft 2002 is 65536 only


F4 means pressing this key repeats last command
So if u delete 3 columns then no need to select 3 columns everytime & delete. Instead just press

F4 it will select 3 column on its own & delete 3 columns automatically.

20100604

Do you know?

Do you Know?

A PC cannot calculate factorial beyond 170
Formula for factorial is fact (c4) where C4 can contain any number between 1 to 170
On 171st no. the factorial formula does not work bcos PC cannot make calculations beyond this
- Discovered by Ravi

: means Colon
; means Semi-colon

" means Inverted comma. Also known as quotation mark.
' also means inverted comma. Also known as apostrophe or quotation mark.

RDC means Regional Distribution Center

20100518

Open University in Kalyan

ICFAI University,
02502312237,9224209699,
3 Jasraj Commercial cmplx
grnd flr
Vallipeer Station Rd,
Kalyan West,
nr Bhanu Talkies,
Thane

20100508

Abbreiviations for Ravi

Abbreiviations for Ravi

ASAP means As soon as possible
ASN means Advanced Shipping Note
BOPT means Battery Operated Pallet Trucks
BR means Best Regards
CSP means Customer Sales Person
DD means Door Delivery
DEO means Data Entry Operator
FIFO means First In First Out
GRN means Goods Receipt Note
Hauler or Haulier means Transport Co-ordinator
HSSE means Housekeeping Safety Security Executive
I-card means Identity Card
IWAN means Integrated Wireless Area Network
KRA means Key Result Area
LIFO means Last In First Out
LR means Lorry Receipt
MRN means Material Receipt Note
POD means Proof of Delivery
PPE means Personal Protective Equipment
RIC means Reading in Copy
SKU means Stock Keeping Unit
SL means Stock List
SQL means Structured Query Language
STN means Stock Transfer Note
TAT means Turn Around Time
VNA Truck means Very Narrow aisle truck
w.r.t. means With respect to
WB means Way Bill
WH means Warehouse
WR means Warm Regards



-------------------------------------------------------

20100506

How to apply Borders in Visio while making flowcharts

Name of the program which makes flowcharts
Visio Professional


In Visio how to apply borders to flow chart

Go to File
Go to Stencil
Go to Visio Extra
Click on Borders

A lot of borders will be seen in left pane
Select single line border-Copy it
Then paste it on flowchart
Border will be applied or pasted
Take print preview

20100428

TATA Indicom-Call forwarding and call pulling commands

TATA Indicom-Call forwarding and call pulling commands

For Intercom

Call Pulling - Dial *16 on any handset to pull any call on any number after rings are heard

Call Forwarding - Press Flash & dail last 3 digits then the call will be forwarded on last 3 digits

20100425

Hotel for Chennai-Perambur area

Hotel at Chennai, Perambur

Hotel Gateway,
(Lodging),
No. 12,
Perambur High Road,
(Opp. Railway Station), Chennai - 600 011.
Phone - 4275 3199, 2551 7896, 2551 3786

20100419

Remove spacings from excel cells created bcos of Alt+ent formula

How to remove spacings created in excel row bcos of using Alt+Enter formula

OR

How to remove line spacings from excel cell

Use Clean formula

Say Clean(A1) then all line spacings between the contents in A1 will be cleaned or removed.

20100414

Rail & Air Ticket booking in Kolkata

Unique Travels,
Tel - Sanjay @ 98311 06235 & Bapi @ 98312 37599

Address,
59, Diamond Harbour Road,
Ekbalpur, Kolkata - 700 023
(Opposite Calcutta Hospital)

Deals in
Air Ticket, Railway Ticket, Bus Ticket & all types of HOtel & Resort Booking

Guest House in Kolkata

In Taratala area

Saini Guest House
For Lodging & Fooding
T: 0091-033-24497834 & 2448-6237
Fax : 0091-033-24493019

Nitin : 90070 71249/96818 72302

63, Diamond Harbour Road,
Kolkata - 700 023, (Opp. Calcutta Hospital)

20100406

How to enter lines in same cell of excel?

How to enter lines in same cell of excel?



Press shortcut key
Alt+Enter

As many times pressed
that many times
lines can be entered in same Excel cell.

This helps in copy pasting data in word
from excel cell
in form of lines rather than
getting a merged data to copy
when data is copied from a single cell of excel
into a word file.

20100317

Shortcut key to rotate acrobat files

Shortcut key to rotate acrobat files


To view landscape acrobat file views into portrait form

Press - shift+Ctrl+Plus

And then the file becomes viewable in Portrait Set-up from the given landscape Set-up

20100302

Name Conflict Error in Excel 2007

Name Conflict Error in Excel 2007

In Name Conflict Error box type

a_1 then press enter

Later again type

a_2 then press enter

Then type

a_3 & press enter

Then type

a_4 & press enter

That way proceed upto a_7.

On 7th - "enter" command the file opens

Directly typing a_7 & pressing enter does not work

To open such files with name conflict error one requires to type a_1 to a_7 each time in name conflict error box & press enter each time they type this letters. Then only file gets opened

20100301

Forchanging Branch in HDFC at Pune

Forchanging Branch in HDFC at Pune

Contact 6609 3333 for local inquiries

Steps needed to perform

1) Fill 1 form as given by HDFC for Branch Transfer

Impacts

Account no. gets changed

20100208

12 Rasas or 12 Roopas

  1. Raudra - (Anger)
  2. Adhbuta - (Wonder)
  3. Sringara -(efforts done to look more pleasant & attractive)
  4. Hasya - (Comic)
  5. Vira - (Gallant/Brave/Bold)
  6. Daya - (Mercy)
  7. Dasya - (Service)
  8. Sakhya - (Friendship)
  9. Bhayanaka - (Horror)
  10. Bibhatsa - (Shocking)
  11. Shanta - (Peaceful)
  12. Vatsalya - (Love/Parenthood)

Word of the Day

Paganist means a person who believes in multiple Gods

A person believing that angels etc. exists & we can contact with them & then they guide us.

How to know amount consumed per call in Airtel Postpaid connection

How to know amount consumed per call in Airtel Postpaid connection
Dial *121*12#

Within 10-15 seconds amount will be displayed say Rs. 169

Later make the call.

After that again dial *121*12#

Check amount.

Difference between these 2 amounts is charge per call in Airtel postpaid connections.

Can be also used for knowing present bill status so whether the billing amount has exceeded our limits or not can be known by this.

20100205

List of 14 Vidyas extended from Vedas

List of 14 Vidyas extended from Vedas or considered to be branches of that Single Veda given by Lord Brahma in beginning when world started.

  1. Shiksha means Education
  2. Kalpa means division of billions & billions of years into Yugas & day & night of Brahma
  3. Vyakaran means Grammer
  4. Nirukt
  5. Jyotish means Astrology
  6. Chhand means for eg. Gayatri Mantra is considered to be a Chhand
These 6 are considered to be the bodies of Vedas
  1. Four Vedas - Rigveda, Samveda, Yajurveda & Atharva veda
  2. Mimansa
  3. Nyaya Shastra - How justice is important & crucial for protection of all worlds
  4. Puraans - 18 Purans as given by Ved Vyaas & also other Purans other than this 18 Purans
  5. Dharma Shastra - Religion Theories & Importance of duties towards parents, wife,nation,Gods etc.
These 6+8 = 14 are the Vidyas
  1. Ayurveda -Knowledge about use of medicine
  2. Dhanurveda - Knowledge about use of Divine weapons
  3. Gandharv veda - Gandharva species are believed to be different & superior to humans. They are indulged in music & dance
  4. Niti Shastra - eg. Honesty is the best policy is a Niti. So knowledge about Nitis.
All these 6+14+4 are considered to be the branches of single Veda given by Lord Brahma to humans when the world started.

How many Puraans are there in Hinduism?

List of 18 Puraans and additional ones also


Puran


Picture Source - Commons Wikimedia
  1. Brahm Puran
  2. Padma Puran
  3. Vishnu Puran
  4. Shiv Puran (Vaayu Puran)
  5. Bhagvat Puran
  6. Naradiya Puran
  7. Markandeya Puran
  8. Agni Puran
  9. Skand Puran
  10. Bhavishya Puran
  11. Brahm Vaivart Puran
  12. Ling Puran
  13. Vaaraaha Puran
  14. Vaamana Puran
  15. Koorma Puran
  16. Matsya Puran
  17. Garud Puran
  18. Brahmaand Puran
Contents are Various Worlds, Nature, Doom, Big & Famous King's Families,Manvantars, Characteristics of Varshas



Wikipedia Links for Puraans




Vayu Puran is same as Shiva Puran



17 Intellectual quotes by Chanakya


  1. A person should not be too honest. Straight trees are cut first and honest people are screwed first. - Chanakya
  2. Do not be very upright in your dealings for you would see by going to the forest that straight trees are cut down while crooked ones are left standing. (This reflects subconscious tendencies of mind in surrounding people towards you or any other person. People prefer easy go for implementing negative acts) - Chanakya
  3. Do not reveal what you have thought upon doing, but by wise council keep it secret being determined to carry it into execution. - Chanakya
  4. Even if a snake is not poisonous, it should pretend to be venomous.(True for ancient world of warriors) - Chanakya
  5. God is not present in idols. Your feelings are your god. The soul is your temple. -Chanakya
  6. He who lives in our mind is near though he may actually be far away; but he who is not in our heart is far though he may really be nearby. - Chanakya
  7. If one has a good disposition, what other virtue is needed? If a man has fame, what is the value of other ornamentation? - Chanakya
  8. People who work sincerely are the happiest. - Chanakya
  9. Whose wealth is in the possession of others, can not use wealth when the need for them arises. - Chanakya
  10. Test a servant while in the discharge of his duty, a relative in difficulty, a friend in adversity, and a wife in misfortune. - Chanakya
  11. The biggest guru-mantra is: never share your secrets with anybody. It will destroy you. - Chanakya
  12. The wise man should restrain his senses like the crane and accomplish his purpose with due knowledge of his place, time and ability. - Chanakya
  13. There is no austerity equal to a balanced mind, and there is no happiness equal to contentment; there is no disease like covetousness, and no virtue like mercy. - Chanakya
  14. There is poison in the fang of the serpent, in the mouth of the fly and in the sting of a scorpion; but the wicked man is saturated with it. - Chanakya
  15. Treat your kid like a darling for the first five years. For the next five years, scold them. By the time they turn sixteen, treat them like a friend. Your grown up children are your best friends. - Chanakya
  16. Men of discernment deal only with the present moment. - Chanakya
  17. Citizens never support a weak company and birds don't build nests on a tree that doesn't bear fruits. - Chanakya

20100129

How to search on Google webpage?

For exact search
use apostrope means "Word"

For more detailed information
use plus sign eg. word1+word2+word3 but this search is not exact hence not so useful & not to the point bcos quite comprehensive

For search related to particular files
give word then type Filetype:pdf or Filetype:xls etc.

For search related to particular sites
give word then type site:hi5.com etc.