Affiliates

Amazon.com


Popular Microsoft Excel Books

Excel 2003 Bible
Excel 2003 Bible
Author: John Walkenbach 

Excel 2003 for Dummies
Excel 2003 for Dummies
Author: Greg, PhD Harvey 

Microsoft Office Excel 2003 Step by Step
Microsoft Office Excel 2003 Step by Step
Author: Curtis Frye 

Excel VBA Programming For Dummies
Excel VBA Programming For Dummies
Author: John Walkenbach 

Excel 2003 Personal Trainer
Excel 2003 Personal Trainer
Author: Inc 

Microsoft Office Excel 2003 Inside Out
Microsoft Office Excel 2003 Inside Out
Author: Craig Stinson 

Excel 2003 All-in-One Desk Reference for Dummies
Excel 2003 All-in-One Desk Reference for Dummies
Author: Greg Harvey 

Popular MS Excel Related Websites

Microsoft Corporation 













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
Working with data {Tutorial for beginners}  
 
Written by Upendra Kumar  
Saturday, 07 July 2007
Category MS Excel 2007 - Data.  
 
General Information
 
 
Making a connection
Getting Data
Using Filters
 
 
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.
 

 
Advertisement



Advertisement



Copyright MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster