Skip to main content

Library Workshops

Excel Intermediate - Learning Objective #6:

Excel Intermediate - Learning Objective #6:

Importing Text Files:

Skills and concepts covered:

  • Data Tab
  • External Data

Activities:

  • On the Budget Worksheet click to the data tab of the ribbon → click “from text” from the get external data section → choose the file “Budget 2013” from the desktop and select “import” → select delimited circle then hit next → delimiters defined as tab → select next → select general format (because there are both numbers and text in this file) → select finish → place data into existing worksheet cell A1 → select ok

Telephone416-864-5059 Email icon hslibrary@smh.ca           Twitter icon   Health Sciences Library Blog                Health Sciences Library Feedback