Understanding XML Within Excel

XML is a mark-up (or "markup") language, so its uses with data are abundant. The key to understanding XML within Excel is first thinking about what a markup actually is. Imagine you have reams and reams of data relating to your customers. You might have their name, address, how much they owe you on invoices, and so on. How would you sort it out, file it, or in other words, mark it up? You'll probably start with surname in alphabetical order, invoices due in chronological order, and other logical patterns. This is all part of "marking up", and it's something XML does for you within Excel. Learn to manipulate XML, and you open up brand new ways of using your data not only in spreadsheets, but in other Office programs that are also compatible with XML.

The full article appears here:
http://www.microsofttraining.net/article-793-understanding-xml-within-excel.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com