Friday 24 February 2017

List of Railway Headquarters in India.


1
Central Railway    
Mumbai
Bhusawal, Nagpur, Mumbai(CST), Solapur,Pune
2
Eastern Railway
 Kolkata
                Malda, Howarh, Sealdah, Asansol
3
Northern Railway
New Delhi
Ambala, Ferozpur, Lucknow, Moradabad, Delhi
4
North Eastern Railway
Gorakhpur
Lucknow, Varanasi, Izatnagar
5
Northeast Frontier Railway
Guwahati
Katihar, Lumding,Tinsukhia, Alipurduar, Rangiya
6
Southern Railway
Chennai
Chennai, Madurai, Palghat,Trichy, Trivandrum
7
South Central Railway
Secunderabad
Secunderabad, Hyderabad, Guntakal, Vijaywada, Guntur, Nanded
8
South Eastern Railway
Kolkata
Kharagpur, Chakradharpur, Adra, Ranchi
9
Western Railway
Mumbai
Bhavnagar, Mumbai Central, Ratlam, Rajkot, Vadodara, Ahemdabad
10
East Central Railway
Hajipur
Danapur, Dhanbad,Sonepur, Mughalsarai, Samastipur
11
East Coast Railway
Bhubaneswar
Khurda Road, Waltair, Sambalpur
12
North Central Railway
Allahabad
Allahabad, Jhansi, Agra
13
North Western Railway
Jaipur
Bikaner, Jodhpur, Jaipur, Ajmer
14
South East Central Railway
Bilaspur
Nagpur, Bilaspur, Raipur
15
South Western Railway
Hubli
Bangalore, Mysore, Hubli
16
West Central Railway
Jabalpur
Jabalpur, Bhopal, Kot

MS Excel all formulas at one palce

MS EXCEL
Formula

Description
Ctrl+A Select All
Ctrl+B Bold
Ctrl+C Copy
Ctrl+D Fill Down
Ctrl+F Find
Ctrl+G Goto
Ctrl+H Replace
Ctrl+I Italic
Ctrl+K Insert Hyperlink
Ctrl+N New Workbook
Ctrl+O Open
Ctrl+P Print
Ctrl+R Fill Right
Ctrl+S Save
Ctrl+U Underline
Ctrl+V Paste
Ctrl W Close
Ctrl+X Cut
Ctrl+Y Repeat
Ctrl+Z Undo
F1 Help
F2 Edit
F3 Paste Name
F4 Repeat last action
F5 Goto
F6 Next Pane
F7 Spell check
F8 Extend mode
F9 Recalculate all workbooks
F10 Activate Menubar
F11 New Chart
F12 Save As
Ctrl+: Insert Current Time
Ctrl+; Insert Current Date
Ctrl+" Copy Value from Cell Above
Ctrl+’ Copy Formula from Cell Above
Shift Hold down shift for additional functions in Excel’s menu
Shift+F1 What’s This?
Shift+F2 Edit cell comment
Shift+F3 Paste function into formula
Shift+F4 Find Next
Shift+F5 Find
Shift+F6 Previous Pane
Shift+F8 Add to selection
Shift+F9 Calculate active worksheet
Shift+F10 Display shortcut menu
Shift+F11 New worksheet
Shift+F12 Save
Ctrl+F3 Define name
Ctrl+F4 Close
Ctrl+F5 XL, Restore window size
Ctrl+F6 Next workbook window
Shift+Ctrl+F6 Previous workbook window
Ctrl+F7 Move window
Ctrl+F8 Resize window
Ctrl+F9 Minimize workbook
Ctrl+F10 Maximize or restore window
Ctrl+F11 Inset 4.0 Macro sheet
Ctrl+F12 File Open
Alt+F1 Insert Chart
Alt+F2 Save As
Alt+F4 Exit
Alt+F8 Macro dialog box
Alt+F11 Visual Basic Editor



CONCURRENT AUDIT

CONCURRENT AUDIT
Concurrent Audit is an audit which is conducted on concurrent basis, means no specific time period of Audit is defined particularly.
 In more simpler terms, usually an statutory or internal audit is conducted for a specified period say 1 year or 3 months. But, in concurrent audit no such Audit period is defined. It is conducted to check the daily transactions and ensure whether organisation is ensuring operational, regulatory compliance.
Usually concurrent audit is conducted for bank branches, depending upon the quantum of advances given. It also depends upon bank to bank and their risk taking capability. Concurrent audit is conducted to monitor day to day bank operationa so that all the compliances and security measures are being followed.
 Concurrent audit involves daily account opening checking, cash balance, income leakage, BCP & DRP analysis, NPA tracking, laws compliance,RBI compliance, various authorisations and all.
In some particular banks, scope of concurrent audit is very well defined to focus on the areas they are most concerned with.
 Now a days more and more branches are coming under the review of concurrent audit due to alarming rise of NPAs in all banks.
 So now banks are hiring more and more concurrent auditors to ensure their operational efficiency and profitability.

Nationalised banks in India


Nationalised banks in India 
1.            Allahabad Bank
2.            Andhra Bank
3.            Bank of India
4.            Bank of Baroda
5.            Bank of Maharashtra
6.            Canara Bank
7.            Central Bank of India
8.            Corporation Bank
9.            Dena Bank
10.          Indian Bank
11.          Indian Overseas Bank
12.          Oriental Bank of Commerce
13.          Punjab & Sindh Bank
14.          Punjab National Bank
15.          Syndicate Bank
16.          UCO Bank
17.          Union Bank of India
18.          United Bank of India
19.          Vijaya Bank
20.        Under State Bank of India.
  •     State Bank of Hyderabad
  •     State Bank of India
  •     State Bank of Mysore
  •     State Bank of Patiala
  •     State Bank of Travancore

Other public sector banks
1.            Bharatiya Mahila Bank


Sunday 12 February 2017

Effective Study Habits

              Effective Study Habits



Effective study habits -- studying smarter -- can be learned to improve your ability to better retain reading material. These habits include approaching study with the right attitude, choosing the right environment, minimizing distractions, setting a realistic schedule, and employing memory games, among others.

*How you approach studying matters
Too many people look at studying as a necessary task, not an enjoyment or opportunity to learn. That’s fine, but researchers have found that how you approach something matters almost as much as what you do. Being in the right mindset is important in order to study smarter.
Sometimes you can’t “force” yourself to be in the right mindset, and it is during such times you should simply avoid studying. If you’re distracted by a relationship issue, an upcoming game, or finishing an important project, then studying is just going to be an exercise in frustration. Come back to it when you’re not focused (or obsessed!) by something else going on in your life.
Way to help improve your study mindset:
  • Aim to think positively when you study, and remind yourself of your skills and abilities.
  • Avoid catastrophic thinking. Instead of thinking, “I’m a mess, I’ll never have enough time to study for this exam,” look at it like, “I may be a little late to study as much as I’d like, but since I’m doing it now, I’ll get most of it done.”
  • Avoid absolute thinking. Instead of thinking “I always mess things up,” the more objective view is, “I didn’t do so well that time, what can I do to improve?”

*Where you study is important
A lot of people make the mistake of studying in a place that really isn’t conducive to concentrating. A place with a lot of distractions makes for a poor study area. If you try and study in your dorm room, for instance, you may find the computer, TV, or a roommate more interesting than the reading material you’re trying to digest.

*Bring everything you need, nothing you don’t
Unfortunately, when you find an ideal place to study, sometimes people bring things they don’t need. For instance, while it may seem ideal to type notes into a computer to refer back to later, computers are a powerful distraction for many people because they can do so many different things. Playing games, going online, IM’ing, surfing the Web, and answering emails are all wonderful distractions that have nothing to do with studying. So ask yourself whether you really need a computer to take notes, or whether you can make do with the old-fashioned paper and pen or pencil.
*Outline and rewrite your notes
Most people find that keeping to a standard outline format helps them boil information down to its most basic components. People find that connecting similar concepts together makes it easier to remember when the exam comes around. The important thing to remember in writing outlines is that an outline only words as a learning tool when it is in your own words and structure. Every person is unique in how they put similar information together (called “chunking” by cognitive psychologists). So while you’re welcomed to copy other people’s notes or outlines, make sure you translate those notes and outlines into your own words and concepts. Failing to do this is what often causes many students to stumble in remembering important items.
It may also be helpful to use as many senses as possible when studying, because information is retained more readily in people when other senses are involved. That’s why writing notes works in the first place – it puts information into words and terms you understand. Mouthing the words out loud while you copy the notes before an important exam can be one method for involving yet another sense.

*Practice by yourself or with friends
The old age adage, practice makes perfect, is true. You can practice by yourself by testing yourself with either practice exams, past quizzes, or flash cards (depending what kind of course it is and what’s available). If a practice exam isn’t available, you can make one up for yourself and your classmates (or find someone who will). If a practice or old exam from a course is available, use it as a guide – do not study to the practice or old exam! (Too many students treat such exams as the real exams, only to be disappointed when the real exam has none of the same questions). Such exams help you understand the breadth of content and types of questions to expect, not the actual material to study for.
Some people enjoy reviewing their materials with a group of friends or classmates. Such groups work best when they’re kept small (4 or 5 others), with people of similar academic aptitude, and with people taking the same class. Different formats work for different groups. Some groups like to work through chapters together, quizzing one another as they go through it. Others like to compare class notes, and review materials that way, ensuring they haven’t missed any critical points. Such study groups can be helpful for many students, but not all.