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

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