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 _($#,##0.00_);_($#,##0_) as formatting code… To remove grid lines from excel worksheet, go to menu > tools > options > and un-check grid lines option. (Excel 2007: office button > excel option > advanced)… To hide a worksheet, go to menu > format…

Read More

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 or earlier… To count number of words in a cell, use =len(trim(text))-len(SUBSTITUTE(trim(text),” “,””))… To count positive values in a range, use =countif(range,”>0?)… To calculate…

Read More

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 a cell, press alt + down arrow 8. To enter multiple lines in a cell, press alt+enter 9. To insert a new sheet, press…

Read More

Visual Studio 2015 keyboard shortcuts – The complete list

Analyze Navigate Backward Shift+Alt+3 Navigate Forward Shift+Alt+4 Architecture New Code Map Ctrl+\, Ctrl+O New UMLor Layer Diagram Ctrl+\, Ctrl+N Architecture Context Menus Add Node Ins Both Dependencies B Incoming Dependencies I Outgoing Dependencies O New Comment Ctrl+Shift+K Ctrl+E, C Remove Del Rename F2 Build Build Solution Ctrl+Shift+B Cancel Ctrl+Break Compile Ctrl+F7 Run Code Analysison Solution Alt+F11 Class Diagram Collapse Num – Expand Num + Class View Context Menus Properties Alt+Enter Misc Commit All Edits Shift+Alt+U Move Left Edgetotheleft Ctrl+Shift+,…

Read More

Create an ODBC Connection to Access Database

The Microsoft Access, also known as MSAccess, is a management system database from Microsoft, packaged with Microsoft Office Professional which combines the Microsoft Database Engine with a graphical user interface. In Windows 64bit to check whether the 32-bit Microsoft Access Database Engine drivers are installed, go to C:\Windows\SysWOW64\odbcad32.exe. If on a 32-bit machine, go to C:\Windows\System32\odbcad32.exe to access the utility.  Go to the drivers tab. If the Microsoft Access Driver lists .mdb and .accdb, then the correct drivers are installed….

Read More

Keyboard Shortcuts for Microsoft Word 2013 – Quick Reference

Common tasks in Microsoft Word TO DO THIS PRESS Create a nonbreaking space. CTRL+SHIFT+SPACEBAR Create a nonbreaking hyphen. CTRL+SHIFT+HYPHEN Make letters bold. CTRL+B Make letters italic. CTRL+I Make letters underline. CTRL+U Decrease font size one value. CTRL+SHIFT+< Increase font size one value. CTRL+SHIFT+> Decrease font size 1 point. CTRL+ Remove paragraph or character formatting. CTRL+SPACEBAR Copy the selected text or object. CTRL+C Cut the selected text or object. CTRL+X Paste text or an…

Read More

Posted in Microsoft Word Comments Off on Keyboard Shortcuts for Microsoft Word 2013 – Quick Reference
Keyboard Shortcuts for Microsoft Word 2013 – Navigating the Ribbon

Access any command with a few keystrokes Access keys let you quickly use a command by pressing a few keys, regardless of where you are in the program. Every command in Word 2013 can be accessed by using an access key. You can get to most commands by using two to five keystrokes. To use an access key: Press ALT. The KeyTips are displayed over each feature that is available in the current view. Press the letter shown in…

Read More