Convert Range to XML List

4. Try it: Select the Range

You will be prompted to select the Range. In this example the Range is from A1:D22 (all of the date, product and revenue data) but it does not include the SUM in Cell D23.

 

What Else Do You See? You need to indicate if the first row is the Header Row. Yes, in this example the first row contains the column names.

 

Click OK and keep going...

Add-Ins-> XML Tools ->Convert a Range to an XML List...

Exam 77-888: Microsoft Excel Expert 2010

1. Sharing and Maintaining Workbooks

1.1. Apply workbook settings, properties, and data options: XML Map Properties