# Importing External Data Activity for Microsoft Excel

Resource Type
Product Rating
File Type

Compressed Zip File

1 MB|7 pages
Share
Also included in:
1. Complete bundle - Great for teachers tasked with teaching an entire Microsoft Excel module, especially if part of a course with Certiport MOS Specialist Exam Certification requirements!***Files open in Microsoft Excel or Word and you can edit them as you please. :)***Bundle now includes MOS Excel Ce
\$31.44
\$19.99
Save \$11.45
Product Description

Here's a brief lesson activity designed to teach students the basics of importing external data into a spreadsheet from both a comma-separated text file and a tab delimited text file. Students also will format the data as a table and complete a test prep extension activity covering various Excel skills they'll see on the Certiport Certification Exam.

***Lesson is optimized for Microsoft Excel 2016 & 2013

This lesson is contained within my Microsoft Excel Skills Bundle. Click on the link below to view this bundle.

Microsoft Excel Skills Bundle

Other individual Microsoft Excel Skills you may be interested in:

Basic Functions and Formulas Lesson

Cell References Lesson

Conditional Formatting Lesson

Dates, Alignment, Pictures, Cell Styles Lesson

Formatting Cells Lesson

IF Functions and Formulas Lesson (IF, SUMIF, COUNTIF, AVERAGEIF)

Intermediate Functions and Formulas Lesson (AND, OR, RIGHT, LEFT)

Nested IF THEN Functions and Formulas Lesson

Pixel Art Lesson

VLOOKUP Functions and Formulas Lesson

Vocabulary Definitions Slideshow

Working With Charts Lesson

Working With Tables Lesson

Wedding Playlist SmartArt Lesson

Microsoft Excel Vocab Quiz and Word List

Defining Name Ranges

Microsoft Excel Text and Math Functions Activity

************************************************************************

Thanks for visiting my store! Don't forget to FOLLOW ME for new product announcements, sales, promotions and updates!

-TechCheckLessons

TechCheckLessons is not affiliated with Microsoft Corp.

Product names, logos, brands, and other trademarks featured or referred to within this lesson are the property of their respective trademark holders.

These trademark holders are not affiliated with my store. They do not sponsor or endorse the contents, materials or processes discussed within this lesson.

************************************************************************

This document is for personal use only and may only be used by the original purchaser. Copying for more than one teacher, classroom, department, school, or school district is prohibited. Additional licenses can be purchased at a discount for others to use in your department. This entire document, or any parts within, may not be reproduced or displayed for public viewing. You may NOT electronically post this product online including to teacher blogs, classroom websites or school networks. Failure to comply is a copyright infringement and a violation of the Digital Millennium Copyright Act (DMCA).

Total Pages
7 pages
Included
Teaching Duration
30 minutes
Report this Resource
\$0.95
More products from TechCheck Lessons

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.