On UrbanPro

View My Profile       Proud to be a Teacher       Write a Review  

Friday, November 18, 2016

Get Your Bank Mini Statements on Your Mobile Without the Internet


Get Your Bank Mini Statements on Your Mobile Without the Internet

Dial *99# to do basic Banking instantly. One can check balance for accounts, mini statement where the mobile number is registered & no internet required. Below are the direct codes for banks:


*99*41# - State Bank of India
*99*42# -  Punjab National Bank
*99*43# - HDFC Bank
*99*44# - ICICI Bank
*99*45# - AXIS Bank
*99*46# - Canara Bank
*99*47# -  Bank Of India
*99*48# - Bank of Baroda
*99*49# - IDBI Bank
*99*50# - Union Bank of India
*99*51# - Central Bank of India


*99*52# - India Overseas Bank
*99*53# - Oriental Bank of Commerce
*99*54# - Allahabad Bank
*99*55# - Syndicate Bank
*99*56# - UCO Bank
*99*57# - Corporation Bank
*99*58# -  Indian Bank
*99*59# - Andhra Bank
*99*60# -  State Bank Of Hyderabad
*99*61# -  Bank of Maharashtra
*99*62# - State Bank of Patiala
*99*63# - United Bank of India
*99*64# - Vijaya Bank
*99*65# - Dena Bank
*99*66# - Yes Bank
*99*67# - State Bank of Travancore
*99*68# - Kotak Mahindra Bank
*99*69# - IndusInd Bank
*99*70# - State Bank of Bikaner and Jaipur
*99*71# - Punjab and Sind Bank
*99*72# - Federal Bank
*99*73# - State Bank of Mysore
*99*74# - South Indian Bank
*99*75# - Karur Vysya Bank
*99*76# - Karnataka Bank
*99*77# - Tamilnad Mercantile Bank
*99*78# - DCB Bank
*99*79# - Ratnakar Bank
*99*80# - Nainital Bank


*99*81# - Janata Sahakari Bank
*99*82# - Mehsana Urban Co-Operative Bank
*99*83# - NKGSB Bank
*99*84# - Saraswat Bank
*99*85# - Apna Sahakari Bank
*99*86# - Bhartiya Mahila Bank
*99*87# -  Abhyudaya Co-Operative Bank
*99*88# - Punjab & Maharashtra Co-operative Bank
*99*89# - Hasti Co-Operative Bank
*99*90# - Gujarat State Co-Operative Bank
*99*91# - Kalupur Commercial Co-Operative Bank.

Also, u can dial *99*99# to know your Aadhaar linking and Over Draft Status.

Thursday, November 17, 2016

Know your bank balance without wasting your ATM transaction

We all know that all the banks have restricted us to do limited transactions through ATM. If we are doing ATM transactions beyond the provided limits, bank will charge us for each exceeded transactions. 

Now you need not to worry, All Banks have started this new facility to know your bank balance without wasting your ATM transaction: 





What you need to do is: You have to call on below mentioned mobile number of your bank from your registered mobile number (which linked with your bank account). Call will automatically get disconnected and you will get your bank balance information on your mobile phone through SMS. Now you need not to waste your ATM transaction, just to know your Bank Balance.



1. Axis Bank – 09225892258
2. Andhra Bank – 09223011300
3. Allahabad Bank – 09224150150
4. Bank of Baroda – 09223011311
5. Bhartiya Mahila Bank – 09212438888
6. Dhanlaxmi Bank – 08067747700
7. IDBI Bank – 09212993399
8. Kotak Mahindra Bank – 18002740110
9. Syndicate Bank – 09664552255
10. Punjab National Bank - 18001802222
11. ICICI Bank – 02230256767
12. HDFC Bank – 18002703333
13. Bank of India – 02233598548
14. Canara Bank – 09289292892
15. Central Bank of India – 09222250000
16. Karnataka Bank – 18004251445
17. Indian Bank – 09289592895
18. State Bank of India – Get the balance via IVR 1800112211 & 18004253800
19. Union Bank of India – 09223009292
20. UCO Bank - 09278792787
21. Vijaya Bank – 18002665555
22. Yes Bank – 09840909000
23. South Indian Bank- 0922300848
24. Bank of Maharashtra- 9222281818


We should always share good news with others.


Wednesday, November 2, 2016

SEARCH Function in Ms-Excel

The Microsoft Excel SEARCH function returns the location of a substring in a string. The search is NOT case-sensitive.
The SEARCH function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SEARCH function can be entered as part of a formula in a cell of a worksheet.



View Video on YouTube

Syntax

The syntax for the SEARCH function in Microsoft Excel is:

 SEARCH( substring, string, [start_position] )  

Parameters or Arguments

substring :  The substring that you want to find.
string      :  The string to search within.
start_position :  Optional. It is the position in string where the search will start. The first position is 1.

Note: If the SEARCH function does not find a match, it will return a #VALUE! error.

Applies To: Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003,

                  Excel XP, Excel 2000

Type of Function : Worksheet function (WS)
Example (as Worksheet Function) - How to use the SEARCH function as a worksheet function in Microsoft Excel:


Based on the Excel spreadsheet above, the following SEARCH examples would return:

 =SEARCH("bet", A1)  
 Result: 6  
   
 =SEARCH("BET", A1, 3)  
 Result: 6  
   
 =SEARCH("e", A2)  
 Result: 2  
   
 =SEARCH("e", A2, 1)  
 Result: 2  
   
 =SEARCH("e", A2, 3)  
 Result: 9  
   
 =SEARCH("in", A2, 6)  
 Result: #VALUE!  
   
 =SEARCH("cel", "Excel", 1)  
 Result: 3  

Extract data from a long and between of the string in Excel

Extract data from a long and between of the string by using MID and SEARCH Function in Excel

One of my blog viewer Shahrukh Ali, from U.P. has raised beneath query on one of my post:

Query:
 i want only amounts which is after second (|) some time its in 3 digits and some times 4 or 5 digits  
 is there any small formula  
 Excel data is  
 774857|Fos|350|Main|Green|2234|  
 97868|Fos|4500|Main|Green|46577|  
 i mean i want only that amount which is between 2nd and 3rd (|)  
 Results should be 350 and 4500 for this data  

Solution:
Function Used:
 =MID(A2,(SEARCH("|",A2,SEARCH("|",A2,1)+1)+1),(SEARCH("|",A2,(SEARCH("|",A2,(SEARCH("|",A2,1)+1))+1))-(SEARCH("|",A2,SEARCH("|",A2,1)+1)+1)))  

Note: Type or Copy & Paste this function into Cell "B2" and string on "A2" cell








Wednesday, October 26, 2016

Easiest way to type Hindi using English Keyboard

Best and easiest way to type Hindi with English Keyboard. You Just need to download a Google Input Tool from your web browser and after that you can type Hindi with English Keyboard offline.

Follow beneath steps or watch video to download and install Google Input Tool on your Computer / Laptop:

  1. Open your web browser and paste below URL into your browser's address bar:
    http://www.google.co.in/inputtools/windows/
  2. Opened page will look like below picture:
  3. Google Input Tools Webpage
  4. Select Hindi Language or Desired Language and check the box of " I agree to the Google Terms of Service and Privacy Policy. from the Choose your languages section as shown in beneath picture:
  5. Click on Download Button.
  6. Run the "InputToolsSetup" EXE file (Installation Process will begin.)
  7. Once Installation Process Done, Change the Input Option by clicking in "ENG" Icon on System tray and Choose Hindi Option as shown in below pictures:
  8. Step-1
    Step-2

  9. Create or Open your Document and start typing and see the Magic.

Monday, October 24, 2016

IF function in Microsoft Excel

IF Function uses, when we want output on the basis of a condition. IF function returns one value if the condition is TRUE, or another value if the condition is FALSE. The IF function is a built-in function in Excel that is categorized as a Logical Function.

To make it more clear understanding for you,  This function tests a condition. If the condition is met it is considered to be TRUE. If the condition is not met it is considered as FALSE. Depending upon the result, one of two actions will be carried out.

Syntex:
 =IF(logical_test, [value_if_true], [value_if_false])  
 OR  
 =IF(Condition,ActionIfTrue,ActionIfFalse)  


Example:
The following table shows the Sales figures and Targets for sales reps.
Each has their own target which they must reach.
The =IF() function is used to compare the Sales with the Target.
If the Sales are greater than or equal to the Target the result of Achieved is shown.
If the Sales do not reach the target the result of Not Achieved is shown.
Note that the text used in the =IF() function needs to be placed in double quotes "Achieved".




Sunday, October 2, 2016

How to select cells, ranges, rows, or columns in Excel

To select Do this
A single cell Click the cell, or press the arrow keys to move to the cell.
A range of cells Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection.
You can also select the first cell in the range, and then press F8 to extend the selection by using the arrow keys. To stop extending the selection, press F8 again.
A large range of cells Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible.
All cells on a worksheet
Click the Select All button.






To select the entire worksheet, you can also press CTRL+A.

Note: If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
Nonadjacent cells or cell ranges Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges.

You can also select the first cell or range of cells, and then press SHIFT+F8 to add another nonadjacent cell or range to the selection. To stop adding cells or ranges to the selection, press SHIFT+F8 again.

Note: You cannot cancel the selection of a cell or range of cells in a nonadjacent selection without canceling the entire selection.
An entire row or column

Click the row or column heading.






1. Row heading

2. Column heading

You can also select cells in a row or column by selecting the first cell and then pressing CTRL+SHIFT+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns).

Note: If the row or column contains data, CTRL+SHIFT+ARROW key selects the row or column to the last used cell. Pressing CTRL+SHIFT+ARROW key a second time selects the entire row or column.
Adjacent rows or columns Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.
Nonadjacent rows or columns Click the column or row heading of the first row or column in your selection; then hold down CTRL while you click the column or row headings of other rows or columns that you want to add to the selection.
The first or last cell in a row or column Select a cell in the row or column, and then press CTRL+ARROW key (RIGHT ARROW or LEFT ARROW for rows, UP ARROW or DOWN ARROW for columns).
The first or last cell on a worksheet or in a Microsoft Office Excel table Press CTRL+HOME to select the first cell on the worksheet or in an Excel list.

Press CTRL+END to select the last cell on the worksheet or in an Excel list that contains data or formatting.
Cells to the last used cell on the worksheet (lower-right corner) Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on the worksheet (lower-right corner).
Cells to the beginning of the worksheet Select the first cell, and then press CTRL+SHIFT+HOME to extend the selection of cells to the beginning of the worksheet.
More or fewer cells than the active selection Hold down SHIFT while you click the last cell that you want to include in the new selection. The rectangular range between the active cell and the cell that you click becomes the new selection.


Monday, September 26, 2016

CHAR function in excel

What Does It Do?

This function converts a normal number to the character it represent in the ANSI character set used by Windows. For Example:


Syntax

  =CHAR(Number)  


 The Number must be between 1 and 255.

The following is a list of all 255 numbers and the characters they represent. Note that most Windows based program may not display some of the special characters, these will be displayed as a small box.




Note: Number 32 does not show as it is the SPACEBAR character.


Friday, September 23, 2016

Get Parent Folder Name in Excel using Function

One of my friend was working on a project, where he was required just the name of the parent folder for the current workbook file, not the complete path and he wanted it to be derived using a regular Excel formula, not a macro or user-defined function.

Here is the function which I have created for him. However, the function is bit long and complicated to understand. I have tried to make it more concise.

 =MID(CELL("filename"),FIND(CHAR(1),SUBSTITUTE(CELL("filename"),"\",CHAR(1),LEN(CELL("filename"))-LEN(SUBSTITUTE(CELL("filename"),"\",""))-1))+1,FIND("[",CELL("filename"))-2-FIND(CHAR(1),SUBSTITUTE(CELL("filename"),"\",CHAR(1),LEN(CELL("filename"))-LEN(SUBSTITUTE(CELL("filename"),"\",""))-1)))  

Above function is a combination of CHAR( ), MID( ), FIND( ), SUBSTITUTE( ), CELL( ), and LEN( ) functions.



Wednesday, September 21, 2016

CELL function in MS Excel

Cell Function

What Does It Do?

This function examines a cell and displays information about the contents, position and formatting.

Syntax

 =CELL("TypeOfInfoRequired",CellToTest)  

The TypeOfInfoRequired is a text entry which must be surrounded with quotes " ".


Codes used to show the formatting of the cell. 

Cell Functions Format

For more Examples Click on below links: