Tag Archives | Microsoft Office

## 15 Excel Tips on Improving Productivity Using Excel

To format a number as SSN, use the custom format code â€ś000-00-0000?â€¦ To format a phone number, use the custom format code â€ś000-000-0000?â€¦ To show values after decimal point only when number is less than one, use [<1]_(\$#,##0.00_);_(\$#,##0_) as formatting codeâ€¦ To remove grid lines from excel worksheet, go to menu > tools > options […]

## 20 Tips in How to Solve Common problems using Excel Formulas

To get the first name of a person, use =left(name,find(â€ť â€ś,name)-1) To calculate mortgage payments, use =PMT(interest-rate,number-of-payments,how-much-loan) To get nth largest number in a range, use =large(range,n)â€¦ To get nth smallest number in a range, use = small(range,n)â€¦ To generate a random phone number, use =randbetween(1000000000,9999999999), needs analysis toolpak if you are using excel 2003 […]

## 25 Very Useful Keyboard Shortcuts for Excel

1. To format any selected object, press ctrl+1 2. To insert current date, press ctrl+; 3. To insert current time, press ctrl+shift+; 4. To repeat last action, press F4 5. To edit a cell comment, press shift + F2 6. To autosum selected cells, press alt + = 7. To see the suggest drop-down in […]

## Perform Simple Math Calculation in Word 2013

Perform Simple Math Calculation in Word 2013

## Useful Shortcuts for PowerPoint 2013

TO DO THIS PRESS Perform the next animation or advance to the next slide. N, ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, or SPACEBAR Perform the previous animation or return to the previous slide. P, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE Go to slideÂ number. number+ENTER Display a blank black slide, or return to […]

## How to Merge Word Files to PDF

How to Merge Word Files to PDF

## Microsoft PowerPoint Shortcut Keys Long List

Microsoft PowerPoint Shortcut Keys List

## Microsoft Access Shortcut Keys List

Microsoft Access Shortcut Keys List