Best computer tricks

Hello guys, i am going to share with you some important tricks which most of you will not know. Various computer programmer who does have a few Tricks or tips that are so numerous but are hidden from sight, However familiarity of these tricks for customers to use a computer easier and entertaining renders.

1. How to take screen shot from a specific part of the screen
  • If you want to take screen shot from a specific area of your screen so no need to install any other software in your computer because there is internally a software available called "snipping tool". Click on START button and type "snipping tool" without quote and press enter and take picture from anywhere on your screen.

2. Easily repeat your last command in Excel
  • If you press F4 they will repeat the last command. For example, if you select a cell and high light of any color so if you want to apply the same task on more cell so just select the cell and press F4 it will repeat the last action.
3. Clear your computer cache in seconds.
  • Clear your computer's cache quick if you want. Press Control + Shift + R keys. It will refresh your page too." + means hold the key and press another"

4, Lock your computer in seconds
  • If you want to lock your computer, click the Windows key and L keys, they will be locked. This is the best truck for fun.

5, Computer screen rotate 

  • If your press Control + Alt and the arrow buttons, So If you click the right arrow key, It will be turn to the right. NOTE: The truck does not work on every computer.

Video Tutorials

There are many important tutorials about MS Office and also I will shared more beneficial tutorials for your help. shares with other friends and give the reference of this site to visit for more videos and posts.
________________________________________________________

Tutorials -Excel 2013- 1- Things you must know
___________________________________________
How to use Excel 2010/2013 Drop Down Box


________________________________________________________________


How to use Excel 2010/2013 - Basic Excel Tutorial Part 3 - Find the Mean, Median and Mode


_________________________________________________________________

MS Excel formulas

Microsoft Excel also known as spreadsheet is the most usable application software for accounting purposes. due to its good functionalities and accuracy its famous in all over the world and its easy to use and work on it.
Today i 'm going to tell you about MS Excel and its formula that how to make usable the spreed sheet in our daily life.I 'm trying to make some tutorials about MS Excel formulas and share with you here. let me share now some basic and simple formulas . 

1. How to perform addition:



2.Basic Formulas


3.Functions

4. Date Time Formulas

5.Statistical Formulas

6.Counting formulas

Essential Software list and Free download

1. Winrar

WinRAR is a trialware file archiver and compressor utility for Windows. It can create archives in RAR or ZIP file formats, and unpack numerous archive file formats.click the below link or picture to download the Winrar
 Download the WinRAR free


2. CCleaner 5.13

According to filehippo probably the most popular freeware cleaner globally with over 1 billion downloads since its launch in 2003. Piriform’s CCleaner is a quick and easy to use program which makes your computer faster, more secure and more reliable. CCleaner removes cookies, temporary files and various other unused data that clogs up your operating system. This frees up valuable hard disk space allowing your system to run faster. Removing this data also protects your anonymity meaning you can browse online more securely.

 Download CCleaner

3.IDM CRACH PATCH

Some time we make register the IDM permanently but it gone fail after some time or some days. To solve this problem i have upload the crack file here to make register the IDM permanently  and solve this problem. follow the simple step to register your Internet download manager.

1.First of all install the Internet download manager.
2. Restart your PC if asked.

3. Make sure 'Internet Download Manager is NOT running.

4. Run the patch program.

5. Run 'Internet Download Manager.

6. Use the generated serial to register.




Keyboard Shortcuts for MS Word

Keyboard shortcuts are very essential for a computer user.It make the work more easy than command use. Some shortcuts key for MS Word are follow.

MS Word shortcuts Keys
Shortcut Key
Function
Ctrl+C
Copy selected text or graphics to the Office Clipboard.
Ctrl+Y
Redo the last action.
Ctrl+V
Paste the most recent addition to the Office Clipboard.
Ctrl+X
Cut selected text
Ctrl+Z
Undo the last action.
Home
Go to beginning of document.
End
Go to end of document.
Esc
Exit reading layout view.
Ctrl+Shift+<
Decrease font size one value
Ctrl+Shift+>
Increase font size one value
Ctrl+[
Increase the font size by 1 point.
Ctrl+]
Decrease the font size by 1 point.
Ctrl+N
Create a new document
Ctrl+O
Open a document.
Ctrl+W
Close a document.
Alt+Ctrl+S
Split the document window.
Alt+Shift+C
Remove the document window split.
Ctrl+S
Save a document.
Ctrl+F
Find text
Alt+Ctrl+Y
Repeat find (after closing Find and Replace window).
Ctrl+H
Replace text
Ctrl+G
Go to a page
Alt+Ctrl+Z
Switch between the last four places that you have edited.
Alt+Ctrl+P
Switch to Print Layout view.
Alt+Ctrl+O
Switch to Outline view.
Alt+Ctrl+N
Switch to Draft view.
Alt+Shift+Arrow Up
Move selected paragraphs up.
Alt+Shift+Arrow Down
Move selected paragraphs down.
Ctrl+P
Print a document.
Alt+Ctrl+I
Switch in or out of print preview.
Alt+Ctrl+M
Insert a comment.
Alt+Shift+O
Mark a table of contents entry.
Alt+Shift+I
Mark a table of authorities entry (citation).
Alt+Shift+X
Mark an index entry.
Alt+Ctrl+F
Insert a footnote.
Ctrl+K
Insert a hyperlink.
Alt+Arrow Left
Go back one page.
Alt+Arrow Right
Go forward one page.
Backspace
Delete one character to the left.
Delete
Delete one character to the right.
Ctrl+Backspace
Delete one word to the left.
Ctrl+Delete
Delete one word to the right.
Ctrl+B
Apply bold formatting.
Ctrl+U
Apply an underline.
Ctrl+I
Apply italic formatting.
Ctrl+=
Apply subscript formatting
Ctrl+Shift+ +
Apply superscript formatting
Ctrl+E
Switch a paragraph to left-aligned
Ctrl+J
Switch a paragraph to justified
Ctrl+R
Switch a paragraph to right-aligned
Ctrl+L
Left alignment

How to type urdu in MS Word


Pak Urdu Installer

Click the above link and download the Pak-Urdu_Installer to type Urdu in any software where you can type English. Through this software we can also type Urdu in Facebook and other social media sites.
 In which software (e.g. MS Word) you want to write Urdu, press left Alt+Shift on keyboard, so you will be able to type Urdu in this software. To return English press same Alt+shift, besides keyboard shortcut (Alt+Shift) you can select Urdu or English mode by clicking on language bar on taskbar. To check the language mode we should observe Language Bar. If it appears "UR" on language bar it means Urdu mode and if it appears "EN" on language bar it means English language is selected.
Three common Urdu fonts that are used in Urdu websites or other places have been included in Pak Urdu Installer in which artistic font "Jameel Noori Nastaleeq",CRULP font "Nafees Web Naskh" and BBC Urdu font "Urdu Naskh Asia Type". These all three fonts are Urdu Unicode True Type font (ttf).
After installing "Pak Urdu Installer" on your computer, you can type Urdu in programs like Microsoft Word, Excel, PowerPoint, Photoshop and other softwares. You can also Search, Chat, send/receive Email in Urdu and type Urdu in Facebook etc. After installation of "Pak Urdu Installer" and restarting your computer as prompted a Language Bar will be displayed on the Taskbar, as illustrated in the images below.
Windows XP
Windows Vista
Windows 7
After installing "Pak Urdu Installer" further details on Urdu typing will be available in an icon with the name of Pak Urdu Installer on your computer's desktop. In addition questions like "How to write Urdu alongside English?" and "Which key should be pressed to type which alphabet?" would be answered after opening that icon.

How to make USB bootable for windows 7 ,8 and 10

To make USB flash drive Bootable follow the below steps.

1. Open the command prompt: first of all click on Start button or hold the windows key+ R and type cmd and press enter. You need to run Command Prompt as an Administrator. 

2. Open the disk management utility. Type the command diskpart to open the disk management utility.

3. Display the connected disks. Type the command list disk to show a list of all the drives connected to your computer. Your USB drive should be listed here as well. Make note of the number next to your USB drive below [Disk ###]

4. Select the USB drive. Enter the command select disk #, replace “#” with the number of your USB drive. Here the USB is on 1 so we will write select disk 1

5.Clean the flash drive. Enter the command clean to verify the integrity of USB and erase all data from USB drive.

6.Create a bootable partition. Once the USB drive is clean, type this create partition primary.

7.Format the USB drive. Input the command format fs=fat32 quick. When you press Enter, this process will complete in few seconds.

8.Active the USB Drive. To make USB active and to boot properly write the command active and press enter.

9.Copy the operating system. Once the USB drive has been made bootable, open the folder or drive where you have windows you can select all files and send to removable disk or just copy all the files and paste it in USB drive.