Create, edit, and manage connections to external data – Excel

In this tutorial about connecting Microsoft Excel to data outside of Microsoft Excel I have included an article from Microsoft and two excellent videos for you to view.
Source Microsoft: Create, edit, and manage connections to external data – Excel

From Microsoft

Create, edit, and manage connections to external data You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog box, you can easily manage these connections, including creating, editing, and deleting them. Security Note Connections to external data may be currently disabled on your computer. To connect to data when you open a workbook, you must enable data connections… Read Complete Article Here

KnowledgeWave

Uploaded on Feb 14, 2012 by Knowledge Wave:  Learn More About KnowledgeWave
KnowledgeWave provides a blended learning approach for today’s most popular business software via videos, live webinars, and live instructor-led learning.

This video is one of many in our [Knowledge Wave] Excel 2010 Warrior Series.  There are times when the data you wish to manipulate is not in an Excel workbook. The Excel Warrior needs to have knowledge of how to import data from external locations. This includes importing from an Access database, from a Web site, from a text file, or from sources such as an SQL server or XML data file. Learn how to not only import the data, but also how to change the properties of the connection. The Excel Warrior also needs to know how to edit the links between Excel workbooks. Understanding the edit links dialog box will make that process a breeze!


From BYU Hawaii

Uploaded on Sep 20, 2011

Here we show you how to import data from database to Excel spread sheet. Based on the article “Click…and the Database Loads Into Excel. An easy way to import data into a spreadsheet” By Lois S. Mahoney and Judith K. Welch.

Free Microsoft Excel Training Classes, Tutorials and Articles

Tony Holowitz founded Teach an Old Dog New Tricks to provide free computer training videos, tutorials, articles and educational resources to computer users in a wide variety of subjects that include Microsoft Excel. Tony has personally created dozens of Microsoft Excel tutorials and seeks out experts when the subject matter at hand in Microsoft Excel is beyond his scope of expertise.

Please connect with those experts to learn more and to thank them for their efforts.

Tony’s Microsoft Excel tutorials are great for or Microsoft Excel beginners and intermediate users. Expert instructors can teach you about high level Microsoft Excel subjects and concepts as well. You can find tutorials here about Microsoft Excel basics, Excel columns and rows, Excel formulas, filtering Excel data, creating Excel PivotTables and much more.

Free Microsoft Excel Training Classes

I number the Microsoft Excel tutorials, so taking them in an order is exactly like taking a Microsoft Excel class. The benefit is that you can come back and watch a tutorials as often as you like to keep your Microsoft Excel skills sharp. I have one request: tell your friends about www.TeachAnOldDogNewTricks.com. Thank you. The tutorials can be found here:

Microsoft Excel 2013