Skip to Main Content
Teach Yourself VISUALLY Excel 2016
book

Teach Yourself VISUALLY Excel 2016

by Paul McFedries
October 2015
Beginner content levelBeginner
352 pages
9h 32m
English
Visual
Content preview from Teach Yourself VISUALLY Excel 2016

CHAPTER 8

Importing Data into Excel

image

Excel offers a number of tools that enable you to import external data into the program. Excel can access a wide variety of external data types. However, this chapter focuses on the six most common types: data source files, Access tables, Word tables, text files, web pages, and XML files.

Understanding External Data

Import Data from a Data Source

Import Data from an Access Table

Import Data from a Word Table

Import Data from a Text File

Import Data from a Web Page

Import Data from an XML File

Refresh Imported Data

Separate Cell Text into Columns

Understanding External Data

External data is data that resides ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2010 Made Simple

Excel 2010 Made Simple

Abbott Katz

Publisher Resources

ISBN: 9781119074731Purchase book