Phildavi Consultants

Total Solutions


Excels Keyboard Shortcuts

 

Excels Keyboard Shortcuts

Shortcut key

Action

Menu equivalent

comments

Version

 

Ctrl+A

Select All

None

All

Ctrl+B

Bold

Format, Cells, Font, Font Style, Bold

All

Ctrl+C

Copy

Edit, Copy

All

Ctrl+D

Fill Down

Edit, Fill, Down

All

Ctrl+F

Find

Edit, Find

All

Ctrl+G

Goto

Edit, Goto

All

Ctrl+H

Replace

Edit, Replace

All

Ctrl+I

Italic

Format, Cells, Font, Font Style, Italic

All

Ctrl+K

Insert Hyperlink

Insert, Hyperlink

Excel 97/2000

Ctrl+N

New Workbook

File, New

All

Ctrl+O

Open

File, Open

All

Ctrl+P

Print

File, Print

All

Ctrl+R

Fill Right

Edit, Fill Right

All

Ctrl+S

Save

File, Save

All

Ctrl+U

Underline

Format, Cells, Font, Underline, Single

All

Ctrl+V

Paste

Edit, Paste

All

Ctrl W

Close

File, Close

Excel 97/2000

Ctrl+X

Cut

Edit, Cut

All

Ctrl+Y

Repeat

Edit, Repeat

All

Ctrl+Z

Undo

Edit, Undo

All

F1

Help

Help, Contents and Index

All

F2

Edit

None

All

F3

Paste Name

Insert, Name, Paste

All

F4

Repeat last action

Edit, Repeat. Works while not in Edit mode.

All

F4

While typing a formula, switch between absolute/relative refs

None

All

F5

Goto

Edit, Goto

All

F6

Next Pane

None

All

F7

Spell check

Tools, Spelling

All

F8

Extend mode

None

All

F9

Recalculate all workbooks

Tools, Options, Calculation, Calc,Now

All

F10

Activate Menubar

N/A

All

F11

New Chart

Insert, Chart

All

F12

Save As

File, Save As

All

Ctrl+:

Insert Current Time

None

All

Ctrl+;

Insert Current Date

None

All

Ctrl+"

Copy Value from Cell Above

Edit, Paste Special, Value

All

Ctrl+'

Copy Fromula from Cell Above

Edit, Copy

All

Shift

Hold down shift for additional functions in Excel's menu

none

Excel 97/2000

Shift+F1

What's This?

Help, What's This?

All

Shift+F2

Edit cell comment

Insert, Edit Comments

All

Shift+F3

Paste function into formula

Insert, Function

All

Shift+F4

Find Next

Edit, Find, Find Next

All

Shift+F5

Find

Edit, Find, Find Next

All

Shift+F6

Previous Pane

None

All

Shift+F8

Add to selection

None

All

Shift+F9

Calculate active worksheet

Calc Sheet

All

Shift+F10

Display shortcut menu

None

All

Shift+F11

New worksheet

Insert, Worksheet

All

Shift+F12

Save

File, Save

All

Ctrl+F3

Define name

Insert, Names, Define

All

Ctrl+F4

Close

File, Close

All

Ctrl+F5

XL, Restore window size

Restore

All

Ctrl+F6

Next workbook window

Window, ...

All

Shift+Ctrl+F6

Previous workbook window

Window, ...

All

Ctrl+F7

Move window

XL, Move

All

Ctrl+F8

Resize window

XL, Size

All

Ctrl+F9

Minimize workbook

XL, Minimize

All

Ctrl+F10

Maximize or restore window

XL, Maximize

All

Ctrl+F11

Inset 4.0 Macro sheet

None in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 Macro

All

Ctrl+F12

File Open

File, Open

All

Alt+F1

Insert Chart

Insert, Chart...

All

Alt+F2

Save As

File, Save As

All

Alt+F4

Exit

File, Exit

All

Alt+F8

Macro dialog box

Tools, Macro, Macros in Excel 97 Tools,Macros - in earlier versions

Excel 97/2000

Alt+F11

Visual Basic Editor

Tools, Macro, Visual Basic Editor

Excel 97/2000

Ctrl+Shift+F3

Create name by using names of row and column labels

Insert, Name, Create

All

Ctrl+Shift+F6

Previous Window

Window, ...

All

Ctrl+Shift+F12

Print

File, Print

All

Alt+Shift+F1

New worksheet

Insert, Worksheet

All

Alt+Shift+F2

Save

File, Save

All

Alt+=

AutoSum

No direct equivalent

All

Ctrl+`

Toggle Value/Formula display

Tools, Options, View, Formulas

All

Ctrl+Shift+A

Insert argument names into formula

No direct equivalent

All

Alt+Down arrow

Display AutoComplete list

None

Excel 95

Alt+'

Format Style dialog box

Format, Style

All

Ctrl+Shift+~

General format

Format, Cells, Number, Category, General

All

Ctrl+Shift+!

Comma format

Format, Cells, Number, Category, Number

All

Ctrl+Shift+@

Time format

Format, Cells, Number, Category, Time

All

Ctrl+Shift+#

Date format

Format, Cells, Number, Category, Date

All

Ctrl+Shift+$

Currency format

Format, Cells, Number, Category, Currency

All

Ctrl+Shift+%

Percent format

Format, Cells, Number, Category, Percentage

All

Ctrl+Shift+^

Exponential format

Format, Cells, Number, Category,

All

Ctrl+Shift+&

Place outline border around selected cells

Format, Cells, Border

All

Ctrl+Shift+_

Remove outline border

Format, Cells, Border

All

Ctrl+Shift+*

Select current region

Edit, Goto, Special, Current Region

All

Ctrl++

Insert

Insert, (Rows, Columns, or Cells) Depends on selection

All

Ctrl+-

Delete

Delete, (Rows, Columns, or Cells) Depends on selection

All

Ctrl+1

Format cells dialog box

Format, Cells

All

Ctrl+2

Bold

Format, Cells, Font, Font Style, Bold

All

Ctrl+3

Italic

Format, Cells, Font, Font Style, Italic

All

Ctrl+4

Underline

Format, Cells, Font, Font Style, Underline

All

Ctrl+5

Strikethrough

Format, Cells, Font, Effects, Strikethrough

All

Ctrl+6

Show/Hide objects

Tools, Options, View, Objects, Show All/Hide

All

Ctrl+7

Show/Hide Standard toolbar

View, Toolbars, Stardard

All

Ctrl+8

Toggle Outline symbols

None

All

Ctrl+9

Hide rows

Format, Row, Hide

All

Ctrl+0

Hide columns

Format, Column, Hide

All

Ctrl+Shift+(

Unhide rows

Format, Row, Unhide

All

Ctrl+Shift+)

Unhide columns

Format, Column, Unhide

All

Alt or F10

Activate the menu

None

All

Ctrl+Tab

In toolbar: next toolbar

None

Excel 97/2000

Shift+Ctrl+Tab

In toolbar: previous toolbar

None

Excel 97/2000

Ctrl+Tab

In a workbook: activate next workbook

None


Dr DEEPIKA kind attention

Affordable medical degrees from LSMU
The Lugansk State Medical University, Ukraine, offers post-graduate medical degrees, recognised by the WHO.
A post-graduate medical degree is almostanecessity for MBBS doctors in today’s competitive and growing Health Sector. While many write the PG entrance exams herein India and get through,over the last four years, the Lugansk State Medical University (LSMU), Ukraine,has been an increasingly sought after university for post-graduate medical degrees.

LSMU offers the European Union syllabus in English. Every year,around 300students from India gain admission into this university.

LSMU is known internationally for its innovative teaching, clinical training and research programmes.The award-winning faculty members constantly strive for innovation and excellence in the classroom, the laboratory and the clinic.Since the class size is relatively small, faculty members interact with each student well.

International recognition LSMU is recognised by the World Health Organisation and is listed in the WHO Directory of MedicalSchools. This may be verified from the WHO website http://www.who.int/hrh/wdms/en/  By virtue of beinglisted in the WHO Directoryof Medical Schools, LSMUautomatically gains recognition with the foremostmedical councils aroundthe world including GMCUK and with the Medical Council of India (MCI).LSMU is also listed in the USA with the FAIMER International Medical Education Directory of the Educational Commission for Foreign Medical Graduates(ECFMG®) that validates foreign Universities and qualifications. Graduates from LSMU can practice directly in most Gulf countries.

Post Graduation DisciplinesPost graduation of international standards can be done in several disciplines including Radiology, Pediatrics, ENT, Nuclear Medicine, Orthopedics, Surgery,Gynecology, Internal diseases, Neurology, Neurosurgery, Urology, Uro surgery, Cardiology, Cardiosurgery, Gastroenterology,Forensic Medicine, Intensive care medicine, Therapy, Oncology, Social Medicine,Family Medicine,Public Health and Ophthalmology. Students may also pursue research Doctorates onthese and several other subjects. The medium of instruction is English.

Admissions Post-Graduate in take happens through out theyear and students may mail with their details to the email id mentioned below to check on the availabilityof batches for their required specialisation. If all necessary documents are in order, the admission process is simple and within a period of 2 months,the student can start his postgraduate degree classes.

Students can complete their post-graduate programme for about Rs.6.25lakh. This covers the entire tuition fee,hostel fee,living and travel expense. For admissions, information and processing, contact:

Ace Career Pathways Pvt Ltd, 275,Ist Floor, 11th Main, 14thCross, Indiranagar 2ndStage, Bangalore-38.

Telephone Number:9902000570 /9880310345 / 25286875.

Email:lsmu@acepathways.com    Website: http://www.lsmu.com


Passport

MEGHNA AND SHANTHI ARE WELL ADVISED TO READ CLARIFICATION WRT TO ECNR:PLZ CLICK BELOW  

ECNR

ETS,GRE etc

IELTSIELTS INDIA BRITISH COUNCIL  - BANGALORE  CAMBRIDGE ESOL

TEACHING ENGLISH   ONE STOP ENGLISH   COE 

TEST YOUR LEVEL   

ORDER RESOURSES: KELTIC UK   BEBE UK

ETS, TOEFL

Click here for GRE:

Test Takers

Industrail Poly Coats Paint

   (User: Phillip David) :  GRANDPOLY COATS

Travel Department

BY RAIL: TRAIN NO : 6592,HAMPI EXP FROM BANGALORE CITY to HOSPET : DEP 2220H ARR NEXT DAY 0745 H

Train Route : 6592

TOURIST BUS : KSTDC : HAMPI    

 OFFICES ; You can get more Information on KSTDC and its activities at ;

  • Karnataka State Tourism Development Corporation
    No. 49, 2nd Floor West Entrance, Khanija Bhavan, Race Course Road, Bangalore - 560 001. KARNATAKA, INDIA.
    Telephone: 91-080-22352901/ 22352902/ 22352903,
    Monday through Saturday, 10:00 am through 5:30 pm

    Fax : 91-080-22352963
    e-mail:- For General Information: kstdc@vsnl.in

  • KSTDC Central Reservation Counter Badami House,
    N.R.Square, Bangalore - 560 002.KARNATAKA, INDIA.
    Tel
    : 91-080-2275869 / 2275883 / 22212098.
    Fax : 91-080-2238016.

  • KSTDC Central Information Counter City Railway Station,
    Bangalore - 560 009. Karnataka, India.
    Tel
    : 91-080-2870068.

  • KSTDC Central Information Counter Bangalore Airport,
    Bangalore 560 008. Karnataka, India.
    Tel : 91-080-5268012.


Branches

  • KSTDC Transport Wing
    C/o Mayura Yatri Nivas, 2, J.L.B. Road, Mysore - 570 005 ,KARNATAKA, INDIA.
    Tel : 91-0821-423652.

  • KSTDC Transport Wing
    Old Fire Station Building, Taluk Office Circle, Hospet -583201, KARNATAKA, INDIA.
    Tel : 91-08394-28537.

  • KSTDC Transport Wing Hotel Indraprastha,
    Opp. Kasturba Medical College, Mangalore - 575 004. KARNATAKA, INDIA.
    Tel : 91-0824-421692.

  • KSTDC Transport Wing Hotel Krishna Bhavan Complex,
    Lamington Road, Hubli, Dharwad District - 580 020 KARNATAKA, INDIA.
    Tel : 91-0836-362251-52.
  • KSTDC Tourism One Stop Shop,
    St. Mark’s Road Bangalore 560 001. Karnataka, India.
    Tel : 91-080-51329211, 51329222 Fax : 080 – 51329221.

Also at

  • Department of Tourism
    No. 49, 2nd Floor West Entrance, Khanija Bhavan, Race Course Road, Bangalore - 560 001 KARNATAKA, INDIA.
    Tel : 91-080-22352828.
    Fax : Tel : 91-080-22352626.

Education

 

International Schools and Global Education

Why International schools in Bangalore?

Because Bangalore encapsulates the future of India.
Because Bangalore is a microcosm of the Global Village; an IT and hi-tech hub that represents to the world the dynamic India of the 21st century.
Because it is the bellwether City that best represents India's global aspirations.
Because Newsweek magazine listed it as one of the 10 hottest hi-tech cities globally in its Nov 19, 1998 issue.
Because the UNDP 2001 Report ranked Bangalore 4th with a score of 13 out of 16 along with Austin, San Francisco and Taipei.
   
Because it is a cosmopolitan City with a growing population that is expected to touch ten million within the next six to seven years.
Because there is a crying need not only for high quality education but also for internationally accepted certification.
Because Bangalore has a large number of foreigners and Non- Resident Indians(NRIs) working in various hi-tech industries who want their children to have a global education. Trust.
Because Bangalore is fast becoming the Knowledge Capital of India with its numerous educational institutions and centres of higher learning that include such organizations of repute as the Indian Institute of Science(IISc), the Indian Institute of Management (IIM-B) and the Indian Institute of Information Technology (IIIT-B).
Because many families in Bangalore and elsewhere in the country want their children, both boys and girls, to go to a school that offers all-round development in academics, sports and extra-curricular activities, as well as provides the best in-campus medical facilities.
Because the Sarjapur Road-Ring Road-Hosur Road is a vital portion of the City's IT corridor, providing employment to over three lakh software engineers and other personnel.
Because hundreds of families, especially those of IT, telecom and other hi-tech industry personnel are moving into gated communities, condominiums and bungalows located in this area.

Because hundreds of boys and girls are looking for a school that is futuristic as well as promising.

EBENEZER INTERNATIONAL SCHOOL,BANGALORE


 

List of international schools: Global

The International School, Bangalore, 12-A main, HAL 2nd Stage, Indira Nagar, Bangalore Ph-25280611

Canadian School of India, (International Baccalaureate School),  located near Bangalore city, off Bellary Road, Sahakar Nagar
 

Indus International School
Billapura Cross,
Sarjapur, Bangalore.

Board Line : 080 - / 080 -
Admission :  080 -
Fax           : 080 - 

Jain International Residential School 
School Campus
Jain International Residential School
Jakkasandra Post, Kanakapura Taluk,
Bangalore (Rural) District,
Karnataka - 562 112, INDIA
Tel: to 44, Fax: 7007

Corporate Office
#91/2, Dr A N Krishna Rao Road,
V V Puram, Bangalore - 560 004
Tel:, Fax:

Inventure Academy, Whitefield - Sarjapur Road, Near Dommasandra Circle, Bangalore -.

Mallya Aditi International School, Yelahanka, Bangalore, India

Mallya Aditi International School
Yelahanka, Bangalore 560 064, India
Telephones: 91.80.28462506,7,8

Musing about social software in enterprises and corruption and flow of information

Create a free website at Webs.com