Library Workshops

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