Software Skills

Monday, May 26, 2008

Microsoft Office Keyboard Shortcut Keys : MS POWERPOINT Shortcut keys

Microsoft Office Keyboard Shortcut Keys : MS POWERPOINT Shortcut keys

Apply subscript formatting - CTRL+EQUAL SIGN (=)
Apply superscript formatting - CTRL+PLUS SIGN (+)
Bold - CTRL+B
Capitalize - SHIFT+F3
Copy - CTRL+C
Delete a word - CTRL+BACKSPACE
Demote a paragraph - ALT+SHIFT+RIGHT ARROW
Find - CTRL+F
Insert a hyperlink - CTRL+K
Insert a new slide - CTRL+M
Italicize - CTRL+I
Make a duplicate of the current slide - CTRL+D
Open - CTRL+O
Open the Font dialog box - CTRL+T
Paste - CTRL+V
Print - CTRL+P
Promote a paragraph - ALT+SHIFT+LEFT ARROW
Repeat your last action - F4 or CTRL+Y
Save - CTRL+S
Select all - CTRL+A
Start a slide show - F5
Switch to the next pane (clockwise) - F6
Switch to the previous pane - SHIFT+F6
Undo - CTRL+Z
View guides - CTRL+G

Microsoft Office Keyboard Shortcut Keys : MS EXCEL Shortcut keys (Time saving)

Microsoft Office Keyboard Shortcut Keys MS EXCEL Shortcut keys (Time saving)
Move to next cell in row - Tab
Move to previous cell in row - Shift + Tab
Up one screen - Page Up
Down one screen - Page Down
Move to next worksheet - Ctrl + Page Down
Move to previous worksheet - Ctrl + Page Up
Go to first cell in data region - Ctrl + Home
Go to last cell in data region - Ctrl + End
Bold toggle for selection - Ctrl + B
Italic toggle for selection - Ctrl + I
Underline toggle for selection - Ctrl + U
Strikethrough for selection - Ctrl + 5
Change the font - Ctrl + Shift + F
Change the font size - Ctrl + Shift + P
Apply outline borders - Ctrl + Shift + 7
Remove all borders - Ctrl + Shift + Underline
Wrap text in same cell - Alt + Enter
Format cells - Ctrl + 1
Select font - Ctrl + Shift + F
Select point size - Ctrl + Shift + P
Format as currency - Ctrl + Shift + 4
Format as general - Ctrl + Shift + # (hash sign)
Format as percentage - Ctrl + Shift + 5
Format as number - Ctrl + Shift + 1
Autosum a range of cells - Alt + Equals Sign
Insert the date - Ctrl + ; (semi-colon)
Insert the time - Ctrl + Shift + ; (semi-colon)
Insert columns/rows - Ctrl + Shift + + (plus sign)
Insert a new worksheet - Shift + F11
Read Monitor Cell One - Alt + Shift + 1
Read Monitor Cell Two - Alt + Shift + 2
Read Monitor Cell Three - Alt + Shift + 3
Read Monitor Cell Four - Alt + Shift + 4
List Visible Cells With Data - Ctrl + Shift + D
Lists Data In Current Column - Ctrl + Shift + C
List Data In Current Row - Ctrl + Shift + R
Select Hyperlink - Ctrl + Shift + H
Move To Worksheet Listbox - Ctrl + Shift + S
Move To Monitor Cell - Ctrl + Shift + M
Select Worksheet Objects - Ctrl + Shift + O
List Cells At Page Breaks - Ctrl + Shift + B
Options Listbox - Insert + V

Postures to be followed while working on Compters way

Thursday, May 22, 2008

Microsoft Office Keyboard Shortcut Keys: MS WORD Shortcut Keys

Microsoft Office Keyboard Shortcut Keys: MS WORD Shortcut Keys

All Caps - CTRL+SHIFT+A

Annotation - ALT+CTRL+M

Auto Format - ALT+CTRL+K

Auto Text - F3 or ALT+CTRL+V

Bold - CTRL+B or CTRL+SHIFT+B

Bookmark - CTRL+SHIFT+F5

Copy - CTRL+C or CTRL+INSERT

Copy Format - CTRL+SHIFT+C

Copy Text - SHIFT+F2

Create Auto Text - ALT+F3

Date Field - ALT+SHIFT+D

Delete Back Word - CTRL+BACKSPACE

Delete Word - CTRL+DELETE

Dictionary - ALT+SHIFT+F7

Do Field Click - ALT+SHIFT+F9

Doc Maximize - CTRL+F10

Doc Move - CTRL+F7

Doc Restore - CTRL+F5

Doc Size - CTRL+F8

Grow Font - CTRL+SHIFT+.

Grow Font One Point - CTRL+]Hanging Indent - CTRL+T

Header Footer Link - ALT+SHIFT+R

Help - F1

Hidden - CTRL+SHIFT+H

Hyperlink - CTRL+K

Indent - CTRL+M

Italic - CTRL+I or CTRL+SHIFT+I

Justify Para - CTRL+J

Left Para - CTRL+L

Line Up Extend - SHIFT+UP

List Num Field - ALT+CTRL+L

Outline - ALT+CTRL+O

Outline Collapse - ALT+SHIFT+- or ALT+SHIFT+NUM -

Outline Demote - ALT+SHIFT+RIGHT

Outline Expand - ALT+SHIFT+=

Outline Expand - ALT+SHIFT+NUM +

Outline Move Down - ALT+SHIFT+DOWN

Outline Move Up - ALT+SHIFT+UP

Outline Promote - ALT+SHIFT+LEFT

Outline Show First Line - ALT+SHIFT+L

Lock Fields - CTRL+3 or CTRL+F11

Web Go Back - ALT+LEFT

Web Go Forward - ALT+RIGHT

Word Left - CTRL+LEFT

Word Left Extend - CTRL+SHIFT+LEFT

Word Right - CTRL+RIGHT

Common Errors in PC & There Solution

Common Errors in PC & There Solution

1. MONITOR LED IS BLINKINGCheck all the connections like Monitor Cable, Data cables,RAM, Display Card , CPU connections.

2. CONTINUOS THREE BEEPSProblem in RAM Connection.

3. THREE BEEPS ( 1 Long 2 Short)Problem in Display Card Connection

4. THREE LONG BEEPS PERIOD WISEProblem in BIOS or RAM (Basic Input Output System)

5. CONTINUOS NON-STOP BEEPINGKey Board Problem (I.e.; Some Key is pressed for Longer time)

6. FDD LED IS GLOWING CONTINUOSLYData cable to be connected properly (twisted cable).

7. NO DISPLAY ON THE SCREEN AT ALLHard Disk cable connected wrongly. Connect rightly seeing the Red mark (Faces power supply) and then Restart.

8. POWER LED IS OFFa. Check main power cordb. Check S.M.P.S.c. Check Mother Board connection

9. SHOWING CMOS ERRORReplace 3 Volt battery of Mother Board . Set Original Settings Manually.(Refer CMOS Setup chart)Enter your search termsSubmit search form

10. SHOWING FDD ERROR OR FLOPPY DRIVE IS NOT WORKING PROPERLYCheck Power cord of FDD , Data Cables , set CMOS & Finally the Check drive.

11. SHOWING HDD ERROR OR HARD DISK FAILUREa. Check Power Cordb. Check connection of HDDc. Check Data cabled. Check Hard Disk parameters in CMOS or Auto detecting Setting Partitions by Fdisk Command, then format it to set track 0. 12. MOTHER BOARD HANGS DUE TO UNSTABILIZED POWER SUPPLYa. Check S.M.P.Sb. RAM not functioning properly.c. Software problem (due to using pirated software)d. CPU fan not functioning properly.

13. DANCING SCREENa. Check Display card connectionb. Virus Problemc. Video Memory Problem

14. SHAKING SCREENa. Earthing problemb. Magnetic waves comes around

15. CPU CABINET SHOCKa. Check Earthingb. Check main power cord.

16. NON-SYSTEM DISK ERRORa. Floppy Drive having different disk (Non-Bootable Disk) OR CMOS Parameters for Hard Disk may not be set properly.b. Hard Disk Partitions may not be created. c. Hard Disk may not be formatted.

17. MISSING OPERATING SYSTEMThe System files missing namely Ie; command.com} - User File IO.SYS & MS_DOS.SYS } - Hidden Files. These above three files required for Start up of the system that can be transferred by using SYS C: Command OR While the time of formatting by using Format c:/u/s

18. MISSING COMMAND INTERPRETORMay the file Command.com is corrupted OR Infected by Virus OR Some one has Erased it.

19. SHOWING I/O ERRORa. The type of Hard Disk in CMOS may not be set properly.b. Operating system used for formatting is not valid

20. SHOWING DIVIDE OVER- FLOW MESSAGEa. May some Directories or Files crash with other files.b. Use CHKDSK/F or SCANDISK Command to correct it.

21. HARD DISK MAKING NOISE WHILE PROCESSINGa. Unstabilized power supply.b. Check for Loose Contact.c. Do not use Y Connectors for Hard Disk.d. It may crea

22. HARD DISK HANGS WHILE PROCESSINGCheck for Bad Sector by using CHKDSK or SCANDISK Command. If found format the Hard Disk and set Partition before that area.(This is the only procedure to use Hard Disk with Bad Sector) OR (To avoid Bad Sectors use Standard Power Supply)

23. HARD DISK NOT DETECTEDa. Check Power Connectorb. Check Data Cablesc. Check Jumpers

24. PARTITION NOT SHOWNOperating System where the Hard Disk formatted is not supported with present Mother Board. For Eg: Hard Disk formatted with Pentium System will hide their partitions for 486 System

25. MMX/DLL FILE MISSINGMay the above files may be corrupted due to power failure or Virus. Make available above files from other Computer. OR Reinstall Windows 98 Operating System. (This procedure will not make any effect on existing Data).

26. WINDOWS REGISTRY ERRORThis will happen due to sudden ON/OFF of the system. Final solution is to Reinstall Operating System

27. DISPLAY COLOUR DOES NOT MATCHa. Configure Display Card properly with their CD.b. The Standard setting for Windows is set it to 800x600 for better performance.

28. UNKNOWN DEVICE FOUNDMay the Driver utility is not provided with operating system . Insert Driver CD and install software for the above Device. (Every Device requires driver utility to set active

JavaScript - Browser & Version Redirect

If you maintain separate pages for Netscape and Internet Explorer browsers and want to additionally divide each browser's page into version pages, this script is for you. The script will create a link (or can be changed to automatically redirect) to browser[version number].html. (For example, a visitor with Netscape 4.5 would see a link to netscape4.html) Here there would be a link for msie4.html

<!-- ONE STEP TO INSTALL BROWSER & VERSION REDIRECT:

1. Add the last code into the BODY of your HTML document -->

<BODY>

<!-- Begin

var name = navigator.appName;

var vers = navigator.appVersion;

vers = vers.substring(0,1); // or 0,4 could return 4.5 instead of just 4

if (name == "Microsoft Internet Explorer")

url="msie";

else

url="netscape";

url += vers + ".html";

document.write('<center>');

document.write('<A HREF="' + url + '">Enter</A>');

document.write('</center>');

// You may make the redirection automatic by using this

// window.location=url;

// instead of the three document.write lines above

// End -->

</script>

Microsoft Windows SHORTCUT KEYS: Run Commands

Microsoft Windows SHORTCUT KEYS: Run Commands

compmgmt.msc - Computer management

devmgmt.msc - Device manager

diskmgmt.msc - Disk management

dfrg.msc - Disk defrag

eventvwr.msc - Event viewer

fsmgmt.msc - Shared folders

gpedit.msc - Group policies

lusrmgr.msc - Local users and groups

perfmon.msc - Performance monitor

rsop.msc - Resultant set of policies

secpol.msc - Local security settings

services.msc - Various Services

msconfig - System Configuration Utility

regedit - Registry Editor

msinfo32 _ System Information

sysedit _ System Edit

win.ini _ windows loading information(also system.ini)

winver _ Shows current version of windows

mailto: _ Opens default email client

command _ Opens command prompt