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 […]

Read full story Comments { 0 }

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 […]

Read full story Comments { 0 }

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 […]

Read full story Comments { 0 }

Perform Simple Math Calculation in Word 2013

Perform Simple Math Calculation in Word 2013

Read full story Comments { 0 }

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 […]

Read full story Comments { 0 }

How to Merge Word Files to PDF

How to Merge Word Files to PDF

Read full story Comments { 0 }

Microsoft PowerPoint Shortcut Keys Long List

Microsoft PowerPoint Shortcut Keys List

Read full story Comments { 0 }

Microsoft Access Shortcut Keys List

Microsoft Access Shortcut Keys List

Read full story Comments { 0 }