|
|
|
Amazon.com
|
 |
|
|
|
|
|
|
|
Microsoft Excel 2007 Tutorial for beginners |
|
|
Welcome to MS Tips and Tricks |
Welcome to MS Tips and Tricks -
You are at the right place if you need tutorials for beginners - Online Microsoft Excel tutorials for beginners, covering the following categories
- Advanced Formulas, Pivot data, Charts, Databases, Customization, Table, Forms, etc.,
|
Microsoft Excel Tips and Tricks for beginners |
|
|
| |
| 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. |
| |
|
|
| |
|
|
|
|
|
|
|
|
|
