CASTLE – UCEA Center for the Advanced Study of Technology Leadership in Education
  • Home
  • Events
    • Iowa 1:1 Institute
    • Technology Boot Camp
    • School Leadership & Creativity
    • KySTE 2012
  • Research
    • Projects
      • Blogs for Busy Administrators
      • Current Projects
      • Past Projects
      • DDDM Readiness
      • Grants & Contracts
        • AEA 8
        • AEA 267
        • FIPSE
        • Mahaska County
        • Minnesota
        • NCREL
        • SAI
      • Higher Education Programs
      • KySTE Kentucky
      • Iowa 1:1 Network
      • Moving Forward
      • PTLA
    • Publications
      • CASTLE Briefs
      • Refereed
      • Nonrefereed
    • Surveys
      • 2010 Grundy Center Tech Surveys
      • 2010 Van Meter Tech Surveys
    • School Data Tutorials
      • Charts, Formulas, Pivot Tables
      • Entering data
      • Formatting
      • Linking, Importing Data
      • Making data collection templates
      • Start here
      • Working with data
  • Graduate Programs
    • School Technology Leadership Overview
    • Graduate Certificate
    • Masters or Ed.S.
    • Ph.D.
  • People
    • Directors
    • Staff
    • Distinguished Visitors
  • CASTLE Blogs
    • 1 to 1 Schools
    • Leadership for Social Justice
    • CASTLE Twitter Archive
    • Connected Principals
    • Dangerously Irrelevant
    • Edjurist
    • Educational Games Research
    • LeaderTalk
    • School Finance 101
    • Virtual School Meanderings
  • Contact Us
    • About Us
Home » School Data Tutorials » Linking, Importing Data

Link Excel to other programs

[3 minutes total]

These three tutorials show how to link tables and charts made in Excel with word processing documents, PowerPoint presentations, and other types of files. As Excel data are updated or changed, reports or presentations that are linked to that data will automatically update themselves as well with the new changes.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

  • Copying and pasting Excel tables to Word documents (0:44)
  • Linking Excel tables to Word documents (1:12)
  • Linking Excel charts to Word documents and readjusting the size (1:14)

Import data into Excel

[8 minutes total]

These three tutorials show how to import data into Excel from other databases. Outside data might come from student information systems, electronic gradebook software, data warehouses, or other administrative and instructional systems.

After viewing the tutorial(s), use the back key in your browser to return to this web site.

  • Importing comma delimited data into Excel (2:16)
  • Importing tab delimited data into Excel (0:54)
  • Importing fixed width data into Excel (4:26)

You may need to turn off your browser’s pop-up blocker or install the latest Flash plug-in to view these tutorials.

Navigation

  • Charts, Formulas, Pivot Tables
  • Entering data
  • Formatting
  • Linking, Importing Data
  • Making data collection templates
  • Start here
  • Working with data

Our Recent Tweets

view more »

RSS Ed Tech Articles via UKY

RSS What are we talking about?

  • Still starting with the why
  • Pyramids & Balloons
  • Graduate School experience - Feb 03,2012
  • Newark Public Schools: Let’s Just Close the Poor Schools and Replace them with Less Poor Ones?
  • Guest Blogger: The Sky Has Limits – An Academic Response
  • USA TODAY JUNE 2012 REPORT – Distance Learning: From the Margin to the Mainstream
  • Everything I Need To Know — About Education — I Learned In Kindergarten
  • iForward Among First Wisconsin Online Schools to Focus on Career Prep
  • Wallace Foundation Names Jody Spiro, Ed.D., Director of Education Leadership
  • Article Notice – Challenges Of Virtual And Open Distance Science Teacher Education In Zimbabwe

Main

Events

Get Involved

Research

Teaching

Contact Us

Recent Posts

  • October 28, 2010 2011 Iowa 1:1 Institute
  • February 9, 2010 NEA Board Presentation
  • September 14, 2009 Did You Know 4.0

CASTLE Blogs

1 to 1 Schools

Connected Principals

Dangerously Irrelevant

The Edjurist

Educational Games Research

Leadership for Social Justice

Leadertalk

School Finance 101

Virtual School Meanderings

RSS CASTLE Talk

  • Still starting with the why
  • Pyramids & Balloons
  • Graduate School experience - Feb 03,2012
  • Newark Public Schools: Let’s Just Close the Poor Schools and Replace them with Less Poor Ones?
  • Guest Blogger: The Sky Has Limits – An Academic Response

Archives

  • October 2010
  • February 2010
  • September 2009

Follow Us

Login

CASTLE - UCEA Center for the Advanced Study of Technology Leadership in Education
University of Kentucky 111 Dickey Hall, Lexington, KY 40506-0017 Contact

except where otherwise noted, content on this site is licensed under a Creative Commons Attribution 3.0 License.