Data manipulation in excel

Assignment Help Database Management System

Reference no: EM13762921

Data Manipulation in EXCEL

How to enter in data manually to an EXCEL spreadsheet and then create formulas to perform calculations on that data. In this lesson, you will learn how to import data to EXCEL from an external source,use tools built-in to EXCEL to manipulate the data, and create a pivot table.

Step 1 - Create a new blank worksheet in EXCEL.

Step 2 - Import the data.

In the previous lesson you entered in your data manually. Manual data entry is fine when the spreadsheet is relatively small and the data entry can be done quickly. When the amount of data is large - hundreds of rows and many columns- manual data entry is typically not feasible. EXCEL provides the functionality to import data directly from another source including: from an ACCESS database, from the Web, from a text file, and other data sources.

For this lesson you will import the data from a text file. You should have downloaded the file stocks.txt from the course website already. If not, do so now (NOTE: REMEMBER WHERE YOU SAVE THE FILE!).

To import your data, perform the following steps:

1. Click on the Data tab on the ribbon.

2. The first pane on the Data tab of the ribbon is "Get External Data." Click on the icon labeled "From Text."
Mac Users:Click on the "Text" icon in the "External Data Sources" section of the tab.

3. A dialog box should open prompting you choose the file you want to import. Navigate to where you saved thestocks.txt file and click the Open button.

Attachment:- data manipulation.rar

Reference no: EM13762921

Questions Cloud

The causes of nursing home death : What are some of the causes of nursing home deaths?

Compute the combined worth of steves retirement assets : Steve is about to retire and wants to calculate the total worth of his retirement assets. He has a corporate pension paying $2250 at the beginning of every month. He is also entitled for Social Security benefits of $1450 at the beginning of every mon..

An exchange traded fund that invests in the stocks : An exchange traded fund that invests in the stocks of large corporations is an example of

Her capital gain per share : Sarah purchased a stock one year ago at a price of $32 a share. In the past year, she has received four quarterly dividends of $0.75 each. Today she sold the stock for $38 a share. Her capital gain per share is

Data manipulation in excel : Data Manipulation in EXCEL-How to enter in data manually to an EXCEL spreadsheet and then create formulas to perform calculations on that data. In this lesson, you will learn how to import data to EXCEL from an external source,use tools built-in t..

Problems related to fingngerprint technology : Explain the following for each fingerprinting method selected by the group.

Cyber law or internet law : The director of your department has requested that you conduct some research on the topic of cyber law or Internet law. He has asked you to draft a memo including the following information:

Modify the java application using java netbeans ide : Modify the Java application using Java NetBeans IDE to meet these additional and changed business requirements

Why does much of womens literature reflect a dystopian view : How and why does much of women's literature reflect a dystopian view? Explain whether you see this form of literature as typical in any marginalized group.

User Account

All Pages