CASTLE – UCEA Center for the Advanced Study of Technology Leadership in Education
  • Home
  • Events
    • KySTE 2012
    • Iowa 1:1 Institute
  • Research
    • Projects
      • Blogs for Busy Administrators
      • Current Projects
      • Past Projects
        • Technology Boot Camps
        • School Leadership & Creativity
      • 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.

Events

  • 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?

  • Join us for a NetTutor Demo & Discussion
  • CALL FOR PROPOSALS (Due June 15, 2012): International Forum for Women in E-Learning (IFWE)
  • CFP Extended to June 4 for Orlando Conf & Early Bird Reg Ends May 25 for ET4 Online Symposium
  • The Vitality of our Growth for the Field of Educational Leadership and Policy
  • Greetings From K12/Aventa Learning
  • [Webinar Reminder] The Future of Education: Learning Powered by Technology
  • UCEA Launches Graduate Student Summit 2012 - Exploring the Future of Leadership Preparation: Alternative Perspectives, Frameworks and Methods
  • CNIE 2012 – Promoting Persistence in Online Calculus through Just-in-Time Learning Modules
  • UCEA Announces Graduate Student Fellows for 2012
  • More Cyber Charter Decisions Being Overturned

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

  • Join us for a NetTutor Demo & Discussion
  • CALL FOR PROPOSALS (Due June 15, 2012): International Forum for Women in E-Learning (IFWE)
  • CFP Extended to June 4 for Orlando Conf & Early Bird Reg Ends May 25 for ET4 Online Symposium
  • The Vitality of our Growth for the Field of Educational Leadership and Policy
  • Greetings From K12/Aventa Learning

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.