Sunday 31 January 2010

Collection of Flowers

Collection of Flowers


Make Windows XP Run Much Faster Faster

Excel Formulas Examples

Excel Formulas Examples

Run Commands For Windows XP Very Useful

Program                                                                               Run Command


Accessibility Controls                                                           access.cpl

Accessibility Wizard                                                             accwiz

Add Hardware Wizard                                                         hdwwiz.cpl

Add/Remove Programs                                                        appwiz.cpl

Administrative Tools                                                            control admintools

Adobe Acrobat (if installed )                                                acrobat

Adobe Distiller ( if installed )                                                 acrodist

Adobe ImageReady ( if installed )                                          imageready

Adobe Photoshop ( if installed )                                             photoshop

Automatic Updates                                                                wuaucpl.cpl

Basic Media Player                                                                mplay32

Bluetooth Transfer Wizard                                                      fsquirt

Calculator                                                                              calc

Ccleaner ( if installed )                                                            ccleaner

C: Drive                                                                                c:

Certificate Manager                                                                cdrtmgr.msc

Character Map                                                                       charmap

Check Disk Utility                                                                  chkdsk

Clipboard Viewer                                                                  clipbrd

Command Prompt                                                                  cmd

Command Prompt                                                                command

Component Services                                                            dcomcnfg

Computer Management                                                        compmgmt.msc

Compare Files                                                                      comp

Control Panel                                                                        control

Create a shared folder Wizard                                               shrpubw

Date and Time Properties                                                      timedate.cpl

DDE Shares                                                                         ddeshare

Device Manager                                                                   devmgmt.msc

Direct X Control Panel ( if installed )                                    directx.cpl

Direct X Troubleshooter                                                      dxdiag

Disk Cleanup Utility                                                            cleanmgr

Disk Defragment                                                                dfrg.msc

Disk Partition Manager                                                     diskmgmt.msc

Display Properties                                                            control desktop

Display Properties                                                            desk.cpl


Display Properties
(w/Appearance Tab Preselected )                                    control color

Dr. Watson System Troubleshooting Utility                      drwtsn32

Driver Verifier Utility                                                       verifier

Ethereal ( if installed )                                                     ethereal

Event Viewer                                                                 eventvwr.msc

Files and Settings Transfer Tool                                    migwiz

File Signature Verification Tool                                    sigverif

Findfast                                                                      findfast.cpl

Firefox                                                                       firefox

Folders Properties                                                      control folders

Fonts                                                                          fonts

Fonts Folder                                                               fonts

Free Cell Card Game                                                freecell

Game Controllers                                                       joy.cpl

Group Policy Editor ( xp pro )                                   gpedit.msc

Hearts Card Game                                                    mshearts

Help and Support                                                       helpctr

Hyperterminal                                                           hypertrm

Hotline Client                                                           hotlineclient

Iexpress Wizard                                                       iexpress

Indexing Service                                                     ciadv.msc

Internet Connection Wizard                                       icwonn1

Internet Properties                                                    inetcpl.cpl

Internet Setup Wizard                                               inetwiz

IP Configuration
(Display Connection Configuration)                              ipconfig /all

IP Configuration
(Display DNS Cache Contents)                                       ipconfig /displaydns

IP Configuration
(Delete DNS Cache Contents)                                      ipconfig /flushdns

IP Configuration
(Release All Connections)                                                 ipconfig /release

IP Configuration
(Renew All Connections)                                               ipconfig /renew

IP Configuration
(Refreshes DHCP & Re-Registers DNS)             ipconfig /registerdns

IP Configuration
(Display DHCP Class ID)                                            ipconfig /showclassid

IP Configuration
(Modifies DHCP Class ID)                                           ipconfig /setclassid

Java Control Panel
( if installed )                                                                        jpicpl32.cpl

Java Control Panel
( if installed )                                                                      javaws
 
Keyboard Properties                                                       control keyboard


Local Security Settings                                                       secpol.msc

Local Users and Groups                                                     lusrmgr.msc

Logs You Out of Windows                                                 logoff

Malicious Software Removal Tool                                        mrt

Microsoft Access ( if installed )                                     access.cpl

Microsoft Chat                                                               winchat

Microsoft Excel ( if installed )                                           excel

Microsoft Diskpart                                                         diskpart

Microsoft Frontpage ( if installed )                                   frontpg

Microsoft Movie Maker                                               moviemk

Microsoft Management Console                                      mmc

Microsoft Narrator                                                       narrator

Microsoft Paint                                                              mspaint

Microsoft Powerpoint                                                   powerpnt

Microsoft Word ( if installed )                                        winword

Microsoft Syncronization Tool                                     mobsync

Minesweeper Game                                                      winmine

Mouse Properties                                                      control mouse

Mouse Properties                                                           main.cpl

MS-Dos Editor                                                               edit

MS-Dos FTP                                                                ftp

Nero ( if installed )                                                      nero

Netmeeting                                                               conf

Network Connections control                                 netconnections

Network Connections                                             ncpa.cpl

Network Setup Wizard                                            netsetup.cpl

Notepad                                                                    notepad

Nview Desktop Manager ( if installed )                  nvtuicpl.cpl

Object Packager                                                     packager

ODBC Data Source Administrator                           odbccp32

ODBC Data Source Administrator                        odbccp32.cpl

On Screen Keyboard                                                    osk

Opens AC3 Filter ( if installed )                               ac3filter.cpl

Outlook Express                                                           msimn

Paint                                                                              pbrush

Password Properties                                                 password.cpl

Performance Monitor                                                 perfmon.msc

Performance Monitor                                                         perfmon

Phone and Modem Options                                          telephon.cpl

Phone Dialer                                                                    dialer

Pinball Game                                                                     pinball

Power Configuration                                                 powercfg.cpl

Printers and Faxes                                                 control printers

Printers Folder                                                              printers

Private Characters Editor                                          eudcedit

Quicktime ( if installed )                                          quicktime.cpl

Quicktime Player ( if installed )                              quicktimeplayer

Real Player ( if installed )                                                realplay

Regional Settings                                                             intl.cpl

Registry Editor                                                             regedit

Registry Editor                                                          regedit32

Remote Access Phonebook                                            rasphone

Remote Desktop                                                                 mstsc

Removable Storage                                                         ntmsmgr.msc

Removable Storage Operator Requests                               ntmsoprq.msc

Resultant Set of Policy ( xp pro )                                       rsop.msc
 
Scanners and Cameras                                                 sticpl.cpl

Scheduled Tasks control                                              schedtasks

Security Center                                                            wscui.cpl

Services                                                                        services.msc

Shared Folders                                                          fsmgmt.msc

Sharing Session                                                           rtcshare

Shuts Down Windows                                               shutdown

Sounds Recorder                                                       sndrec32

Sounds and Audio                                                   mmsys.cpl

Spider Solitare Card Game                                         spider

SQL Client Configuration                                        clicongf

System Configuration Editor                                     sysedit

System Configuration Utility                                         msconfig

System File Checker  Utility
( Scan Immediately )                                               sfc /scannow

System File Checker Utility
( Scan Once At Next Boot )                                    sfc /scanonce

System File Checker Utility
( Scan On Every Boot )                                       sfc /scanboot

System File Checker Utility
( Return to Default Settings)                                     sfc /revert

System File Checker Utility
( Purge File Cache )                                          sfc /purgecache

System File Checker Utility
( Set Cache Size to Size x )                            sfc /cachesize=x

System Information                                             msinfo32

System Properties                                         sysdm.cpl

Task Manager                                            taskmgr

TCP Tester                                               tcptest

Telnet Client                                               telnet

Tweak UI ( if installed )                           tweakui

User Account Management                      nusrmgr.cpl

Utility Manager                                        utilman

Volume Serial Number for C:                     label

Volume Control                                       sndvol32

Windows Address Book                                        wab

Windows Address Book Import Utility               wabmig

Windows Backup Utility ( if installed )                ntbackup

Windows Explorer                                             explorer

Windows Firewall                                           firewall.cpl

Windows Installer Details                                 msiexec

Windows Magnifier                                            magnify

Windows Management Infrastructure              wmimgmt.msc

Windows Media Player                                       wmplayer

Windows Messenger                                             msnsgs

Windows Picture Import Wizard
(Need camera connected)                                         wiaacmgr

Windows System Security Tool                                  syskey

Windows Script host settings                                       wscript

Widnows Update Launches                                    wupdmgr

Windows Version
( shows your windows version )                               winver

Windows XP Tour Wizard                                    tourstart

Wordpad                                                                write
 
Zoom Utility                                                         igfxzoom



http://syedimranrocks.blogspot.in/



Tuesday 26 January 2010

task Manager Disable / Enable

Checking your PING for DUMMIES!

Dos Commands

Dos Commands




A)    ANSI.SYS      ATTRIB



B)    BREAK



C)    CD    CHCP    CHDIR  CHKDSK    CLS     COMMAND    COPY    CTTY



D)     DATE      DEBUG    DEL    DELTREE    DIR     DISKCOPY        DOSKEY        DOSSHELL



E)     ECHO    EDIT    EDLIN     EMM386    ERASE    EXIT     EXPAND     EXTRACT



F)    FASTHELP     FC     FDISK     FIND     FORFORMAT



H)    HELP



I)      IFSHLP.SYS



K)     KEYB



L)      LABEL     LH      LOADFIX         LOADHIGH



M)    MD     MEM     MKDIR      MODE      MORE     MOVE      MSAV     MSD          MSCDEX



N)    NLSFUNC



P)    PATH      PAUSE       PING       POWER      PROMPT



Q)    QBASIC



R)    RD      REN     RENAME      RMDIR



S)     SET     SETVER     SHARE     SORT      SUBST      SWITCHES      SYS



T)    TIME     TYPE



U)    UNDELETE       UNFORMAT



V)    VER     VERIFY      VOL



X)    XCOPY

ATTRIB , - The comma does the same thing as ATTRIB -a -h -r - s *.* (removes all attribs).



BACKUP /HP – Unknown



DIR , - This list's all file's including hidden files, does not work in Windows 95



DIR ... - lists all directories that do not have extensions.



DOSKEY /APPEDIT – Unknown



DOSKEY /COMMAND – Unknown



DOSKEY /PERMANENT – Unknown



DOSKEY /SCRSIZE – Unknown



DOSKEY /XHISTORY – Unknown



FDISK /MBR - Recreates the master boot record good way to get rid of Virus's



FDISK /PRI - See FDISK Page for additional information.



FDISK /EXT - See FDISK Page for additional information.



FDISK /LOG - See FDISK Page for additional information.



FDISK /Q - Prevents fdisk from booting the system automatically after exiting fdisk.



FDISK /STATUS - Shows you the current status of your hard drives.



FORMAT /AUTOTEST - Formats the hard drive without any prompting.



FORMAT /BACKUP - Like /AUTOTEST but it will ask you for a volume label.



FORMAT /Z:n - Command used with FDISK supporting FAT32, used to specify the cluster size in bytes where n is multiplied by 512.



MEM /A or /ALL - Adds a line into the MEM command tells the available space in HMA.



SET DIRCMD=0 -Will make all directories hidden however still accessable, to get them back

SET DIRCMD=

TRUENAME - Put before a file well display the whole directory which it exists.



TRACERT - When you are online tells the address that you are at such as www.yahoo.com, only in Windows 95



VER /R - Tells you the Revision and if DOS is in HMA.


http://syedimranrocks.blogspot.in/



Monday 25 January 2010

Microsoft Excel Shortcuts



General


Description                                                           Shortcut Key

New file                                                                  Ctrl + N

Open file                                                                 Ctrl + O

Save file                                                                   Ctrl + S

Move between open workbooks                              Ctrl + F6

Close file                                                                  Ctrl + F4

Save as                                                                        F12

Display the print menu                                             Ctrl + P

Select whole spreadsheet                                        Ctrl + A

Select column                                                     Ctrl + Space

Select row                                                         Shift + Space

Undo last action                                                  Ctrl + Z

Redo last action                                                 Ctrl + Y

Start a formula                                                   Equals Sign (eg. SUM(A1+A2)

Exit Excel 97                                                     Alt + F4

Navigating

Description                                                      Shortcut Key

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

Formatting Text In Worksheet

Description                                                 Shortcut Key

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

Formatting Cells

Description                                         Shortcut Key

Format cells                                       Ctrl + 1

Select font                                         Ctrl + Shift + F

Select point size                                Ctrl + Shift + P

Format as currency                          Ctrl + Shift + 4

Format as general

(to remove any formatting)               Ctrl + Shift + # (hash sign)

Format as percentage                      Ctrl + Shift + 5

Format as number                           Ctrl + Shift + 1

Editing/Deleting Text

Description                                      Shortcut Key

Delete one character to right             Delete

Delete one character to left              Backspace

Edit active cell                                 F2

Cancel cell entry                             Escape Key

Highlighting Cells

Description                                     Shortcut Key

Select entire worksheet                   Ctrl + A

Select entire row                            Shift + Spacebar

Select entire column                        Ctrl + Spacebar

Manual select                                 Hold Shift + with Left, Right, Up, Down Arrow Key

Copying and Moving Text

Description                                   Shortcut Key

Cut                                              Ctrl + X

Copy                                           Ctrl + C

Paste                                           Ctrl + V

Inserting Text Automatically

Description                                Shortcut Key

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

Misc

Description                                                 Shortcut Key

Find text                                                      Ctrl + F

Replace text dialog                                      Ctrl + H

Create a chart automatically on new sheet        F11

Edit a cell comment                                      Shift + F2

Main Jaws Keystrokes In Excel

Description                                                        Shortcut Key

Say Version of Excel                                         Ctrl + Shift + V

Move to Next Sheet                                          Ctrl + Page Down

Move to Prior Sheet                                          Ctrl + Page Up

Go to a cell command                                        Ctrl + G

Collapse Selection To Active Cell                      Shift + Backspace

Say Active Cell Coordinates                              Insert + C

AutoSum                                                          Alt + Equals

Formula Mode                                                  Equals Sign

Insert Date In Current Cell                                Ctrl + ; (semicolon)

Insert Time In Current Cell                                Ctrl + Shift + ; (semicolon)

Current Column First Cell From Top                 Alt + 1

Current Column Second Cell From Top            Alt + 2

Current Column Third Cell From Top               Alt + 3

Current Column Fourth Cell From Top            Alt + 4

Data Region Left                                            Ctrl + Left Arrow

Data Region Right                                          Ctrl + Right Arrow

Data Region Down                                        Ctrl + Down Arrow

Data Region Up                                            Ctrl + Up Arrow

Select Whole Data Region                            Ctrl + Shift + 8

Say Formula                                                 Ctrl + F2

Spell Check                                                    F7

Report Gridline Status                                 Alt + Shift + g

Read Row Total                                         Insert + Delete

Read Column Total                                    Insert + Enter

Say Column Title                                       Alt + Shift + C

Say Row Title                                            Alt + Shift + R

Say Visible Range Coordinates                  Alt + Shift + V

Cycle Through Controls in Dialog Box         Tab

Tab Backwards                                           Shift + Tab

List Cells With Comments                           Ctrl + Shift + ' (apostrophe)

Row Second Cell From Left                       Alt + Ctrl + 2

Row First Cell From Left                            Alt + Ctrl + 1

Row Third Cell From Left                           Alt + Ctrl + 3

Row Fourth Cell From Left                        Alt + Ctrl + 4

Describe Cell Border                                 Alt + Shift + B

Read Cell Comment                                  Alt + Shift + ' (apostrophe)

Auto Filter                                                Ctrl + Shift + A

Read Cell Hyperlink                                Alt + Shift + H

Close Office Assistant                            Ctrl + Insert + F4

Set Monitor Cell One                             Alt + Ctrl + Shift + 1

Set Monitor Cell Two                           Alt + Ctrl + Shift + 2

Set Monitor Cell Three                         Alt + Ctrl + Shift + 3

Set Monitor Cell Four                          Alt + Ctrl + Shift + 4

Set Monitor Cell Five                          Alt + Ctrl + Shift + 5

Set Monitor Cell Six                           Alt + Ctrl + Shift + 6

Set Monitor Cell Seven                      Alt + Ctrl + Shift + 7

Set Monitor Cell Eight                       Alt + Ctrl + Shift + 8

Set Monitor Cell Nine                       Alt + Ctrl + Shift + 9

Set Monitor Cell 10                          Alt + Ctrl + Shift + 0

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

Read Monitor Cell Five                     Alt + Shift + 5

Read Monitor Cell Six                       Alt + Shift + 6

Read Monitor Cell Seven                  Alt + Shift + 7

Read Monitor Cell Eight                   Alt + Shift + 8

Read Monitor Cell Nine                   Alt + Shift + 9

Read Monitor Cell Ten                     Alt + Shift + 0

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







                                                      http://syedimranrocks.blogspot.in/

Popular Posts