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
Search This Blog
Search Engine
Custom Search
20101231
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
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 hoax2) 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
DIFFERENCE IN THE LAST ROWS
-----------------------------------------------
- Excel 2
- Excel 3
- Excel 4
- Excel 5
- Excel 95
- Excel 97
- Excel 2000
- Excel 2002
- Excel 2003
- Excel 2007
DIFFERENCE IN THE LAST ROWS
- Last cell in Excel 2007 workbook is XFD 1048576
- 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"
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?
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 copy the file which is password protected in excel?
- The file can be opened
- But can not be copied
- Hence cannot be pasted
- So save this file as text thru the "Save as" button.
- Please note password protected files can not be saved as web page but still these files can be
- saved as text
- Then select all text - copy it & paste it in new excel file
- The copy function in password protected file does not work but the paste function works.
- Take paste function for all sheet that is password protected.
- Means select the sheet & press paste function button
- 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
----------------------------------------------------------------
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?
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
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
----------------------------
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.
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
---------------------------
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
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.
-----------------------------------------------
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.
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.
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
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
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
-------------------------------------------------------
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
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
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
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.
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
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)
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.
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
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
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
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
- Raudra - (Anger)
- Adhbuta - (Wonder)
- Sringara -(efforts done to look more pleasant & attractive)
- Hasya - (Comic)
- Vira - (Gallant/Brave/Bold)
- Daya - (Mercy)
- Dasya - (Service)
- Sakhya - (Friendship)
- Bhayanaka - (Horror)
- Bibhatsa - (Shocking)
- Shanta - (Peaceful)
- 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.
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.
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.
- Shiksha means Education
- Kalpa means division of billions & billions of years into Yugas & day & night of Brahma
- Vyakaran means Grammer
- Nirukt
- Jyotish means Astrology
- Chhand means for eg. Gayatri Mantra is considered to be a Chhand
- Four Vedas - Rigveda, Samveda, Yajurveda & Atharva veda
- Mimansa
- Nyaya Shastra - How justice is important & crucial for protection of all worlds
- Puraans - 18 Purans as given by Ved Vyaas & also other Purans other than this 18 Purans
- Dharma Shastra - Religion Theories & Importance of duties towards parents, wife,nation,Gods etc.
- Ayurveda -Knowledge about use of medicine
- Dhanurveda - Knowledge about use of Divine weapons
- Gandharv veda - Gandharva species are believed to be different & superior to humans. They are indulged in music & dance
- Niti Shastra - eg. Honesty is the best policy is a Niti. So knowledge about Nitis.
How many Puraans are there in Hinduism?
List of 18 Puraans and additional ones also
Picture Source - Commons Wikimedia
- Brahm Puran
- Padma Puran
- Vishnu Puran
- Shiv Puran (Vaayu Puran)
- Bhagvat Puran
- Naradiya Puran
- Markandeya Puran
- Agni Puran
- Skand Puran
- Bhavishya Puran
- Brahm Vaivart Puran
- Ling Puran
- Vaaraaha Puran
- Vaamana Puran
- Koorma Puran
- Matsya Puran
- Garud Puran
- Brahmaand Puran
Wikipedia Links for Puraans
B
Vayu Puran is same as Shiva Puran
17 Intellectual quotes by Chanakya
- A person should not be too honest. Straight trees are cut first and honest people are screwed first. - Chanakya
- 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
- Do not reveal what you have thought upon doing, but by wise council keep it secret being determined to carry it into execution. - Chanakya
- Even if a snake is not poisonous, it should pretend to be venomous.(True for ancient world of warriors) - Chanakya
- God is not present in idols. Your feelings are your god. The soul is your temple. -Chanakya
- 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
- If one has a good disposition, what other virtue is needed? If a man has fame, what is the value of other ornamentation? - Chanakya
- People who work sincerely are the happiest. - Chanakya
- Whose wealth is in the possession of others, can not use wealth when the need for them arises. - Chanakya
- Test a servant while in the discharge of his duty, a relative in difficulty, a friend in adversity, and a wife in misfortune. - Chanakya
- The biggest guru-mantra is: never share your secrets with anybody. It will destroy you. - Chanakya
- The wise man should restrain his senses like the crane and accomplish his purpose with due knowledge of his place, time and ability. - Chanakya
- 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
- 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
- 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
- Men of discernment deal only with the present moment. - Chanakya
- 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.
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.
Subscribe to:
Posts (Atom)