Scribd
Upload
206 views5 pages

Excel Data Tab: Import & Transform

The document discusses features in the Data tab in Excel including getting external data from sources like Access, refreshing connections, sorting and filtering data, and forecasting tools. It describes how to import data from Access by selecting a table, which can then be viewed as a table, pivot table report, or pivot chart in Excel.

Uploaded by

ukakkad2011
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
206 views5 pages

Excel Data Tab: Import & Transform

The document discusses features in the Data tab in Excel including getting external data from sources like Access, refreshing connections, sorting and filtering data, and forecasting tools. It describes how to import data from Access by selecting a table, which can then be viewed as a table, pivot table report, or pivot chart in Excel.

Uploaded by

ukakkad2011
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 5

Data tab in Excel

Get external data, Get & Transform, Connections, Sort & Filter, Data
Tools, Forecast, Outline groups
Get external data

 This group helps insert data into a worksheet from sources that are outside
the current workbook
 Allows you to refresh your excel workbooks that are connected to an external
data source
 This helps update the data that is in your current worksheet
 You can get data from a variety of external data sources like: -
From Access

 This option allows you to import data from MS Access


 For this click on the ‘From Access’ option in the Data tab
 This will open up a dialog box asking you to select an Access Database from
which you wish to get the table from
 Click open
Pivot table

 A pivot table is an important feature in MS Excel


 A pivot table allows you to extract data of interest from a large, detailed
data set.
Importing Data from Access

 On clicking open, a dialog box appears asking you where in the current
workbook you wish to place your data
 You have the option to view this data as: -
 Table: data arranged in rows & columns
 PivotTable report: gives you the option to add the table column fields that
you wish to add to the report
 PivotChart:
 Only create a connection:

You might also like