Week%208-ACC381 - CollegeofBusiness Information Systems...

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Name College of Business Information Systems Management / Accounting Information Systems Lab - Transforming Raw Data into Various Formats Samantha Kleitsch / Lise Urbaczewski
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Focus Today: 1. Importing text data into a worksheet 2. Setting up your VPN 3. Using dates and times in calculations 4. PivotTables and PivotCharts 5. Importing Web data into Excel 6. Assignment 8: Pivot tables and Pivot charts Property of L. Urbaczewski / S. Kleitsch
Background image of page 2
Importing Data into Excel (populating your worksheet) Real world – we may have data that appears as a list in a text file (.txt) note: if this is a Word document, resave the file as a txt file For starters, a brief example: 25 oct-textfile.txt Property of L. Urbaczewski / S. Kleitsch
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Import External Data Try it out! Example: 25 oct-textfile.txt A list In Excel…. . Data Get External Data Import Text File (choose – then get file) (what questions does it ask?) Property of L. Urbaczewski / S. Kleitsch
Background image of page 4
CONCATENATION Now that we have imported the data, we may wish to reformat that data. Concatenation will take each of the fields of the record and combine them into one long string – takes the multiple cells and creates one string in one cell. =CONCATENATE (text1, text2, …) Property of L. Urbaczewski / S. Kleitsch
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
/manipulate the data See pages 432 and 433, Table 7.1 Try some of these out so you are comfortable with them and to see which ones you might use in the future. Property of L. Urbaczewski /
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 23

Week%208-ACC381 - CollegeofBusiness Information Systems...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online