| In this tutorial, you will apply connect with another data source to obtain data. |
| Making a connection |
| 1) Open the <"/tips-and-tricks/ms-office-tips-and-tricks/ms-excel/working-with-data/Disk Usage.xlsx">Disk Usage.xlsx Sample. |
| 2) Create a new work sheet by clicking the tab as shown below. |
  |
| Illustration 1: New Work sheet Tab. |
| 3) Select the A2 cell. |
| 4) Select the Connections command from the Connections Group in the Data in the Options Tape. |
 |
| Illustration 2: Select Connections. |
| 5) Click on the Add button. |
 |
| Illustration 3: Add new connection window. |
| 6) Click in the Browse for more button. |
 |
| Illustration 4: Browse connections. |
| 7) You will connect to an SQL Database. As the connection does not exists, click in the New Source Button. |
 |
| Illustration 5: Create new source. Click here to view larger image. |
| 8) Select the SQL Server Database and press the Next button. |
 |
| Illustration 6: Select the source. |
| 9) Provide the Server Name and user credentials. Press the Next button. |
 |
| Illustration 7: Configure the connection. |
| 10) Select Database name and table to connect. Press the Next button. |
 |
| Illustration 8: Table Range. |
| 11) Provide a connection name and description for save it for later use. Press the Finish button. |
 |
| Illustration 9: Automatic format. |
| 12) Workbook Connections list will be refreshed. Select the new connection and press the Close button. |
 |
| Illustration 10: Refreshed list. |
| Getting Data |
| 13) Select the Existing Connections command from the Get External Data Group. |
 |
| Illustration 11: Select the new connection. |
| 14) Select the recently created SQL Repo connection and click in the Open button. |
 |
| Illustration 12: New connection available for selection. |
| 15) Select the import method prefered and the destination cell. Press the OK button. |
 |
| Illustration 13: Setting data imported format. |
| 16) Provide user credentials for SQL Server. Press the OK button. |
 |
| Illustration 14: User identification. |
| 17) See the results. |
 |
| Illustration 15: Imported Data. |
| Using Filters |
| 18) After data import, you will see an arrow at each column title bottom corner. These arrorws represent filters for data. Click in the arrow in column name. |
| |
| Illustration 16: Changing the cell format. |
| 19) Click on Select All, the click and select Collect Data Option. Press the OK button. |
 |
| Illustration 17: Selecting the cell format. |
| 20) The filter will hide all rows that do not match with the selected Collect Data text in column Name. |
 |
| Illustration 18: Filtered Table. |
| 21) To see all rows, open the filter in column Name and Click on Select All option. Press the OK button. |
 |
| Illustration 19: Restoring view. |
| 22) To exit from the Filter option, de select the Filter option from the Sort & Filter command in the Editing Group. |
 |
| Illustration 20: De selecting Filtering option. |
| 23) You could filter by other conditions. |
 |
| Illustration 21: Filters. Click here to view larger image. |
| 24) Select the A2 Cell. Select the Font Color as red. |
 |
| Illustration 22: Change cell¡¯s font color. |
| 25) Select the Filter by Selected cell¡¯s Font color option and see the results. |
 |
| Illustration 23: Filtering by cell¡¯s font color. |
discuss this topic to forum
