Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Learn how to convert excel data to XML from scratch
Rating: 3.7 out of 5(19 ratings)
992 students

Learn how to convert excel data to XML from scratch

Step by Step guide on converting from Excel to XML
Last updated 3/2026
English

What you'll learn

  • Convert excel data to XML
  • Convert XML to Excel
  • Construct basic XML document structure
  • Create your own XML Tags
  • Understand XML Syntax
  • Understand XML Elements
  • Understand XML Namespace
  • Use Excel formulas
  • Add and remove columns
  • Share excel workbook
  • Protect excel workbook and worksheet

Course content

4 sections33 lectures2h 47m total length
  • Introduction1:55
  • What is Excel4:27
  • What is Office 3652:34
  • How to get office 36510:41
  • Setting up office 36511:03
  • Excel 2016 user interface10:50
  • Exploring excel ribbon5:57
  • Customising the quick access toolbar5:38
  • Keeping tabs on the ribbon12:29
  • Entering data into excel10:31
  • Using formulas5:55
  • Adding and removing worksheets2:35
  • Resizing columns width4:40
  • Making workbook read only2:54
  • Add and remove columns and rows4:46
  • Sharing your workbook and tracking changes3:26
  • Protecting workbook from structural change4:58
  • Protecting your workbook3:21
  • Protecting your worksheet3:08

Requirements

  • You should be able to use a PC at beginner level
  • You should have a basic working knowledge of excel (Basic intro included in the course)
  • You should have a basic working knowledge of XML(Basic intro included in the course)

Description

Introduction to basic excel

-----------------------------------

Microsoft Excel is a powerful tool essential for managing 
and presenting data in today’s working environment.
you  will gain the knowledge and skills required  to
create and edit worksheets and use formulas .

What You Will Learn Include:

What is Office 365
Setting up Office 365
Excel 2016 user interface
Exploring the Excel Ribbon 
Customizing the Quick Access Toolbar
Keeping Tabs on the Ribbon 
Entering Data in Excel
Using formulas for arithmetic tasks
Adding and removing  worksheets
Resizing columns and rows
Making worksbook read only
Add and remove columns
Sharing workbook and tracking changes
Protecting workbook and worksheet

Introduction to Basic XML
-----------------------------------

XML is a mark up language used to record data which is
 readable to both people and also a range of software applications.
 XML is used extensively in the publishing world to fill
 layouts with content and enable people with no database
 development skills to build data structures with ease.
XML is a popular standard for exchanging data between 
applications and organisations.

This course will teach you the very basics of XML
from the syntax to document structure.

What you will learn includes:

 How to write a proper XML syntax
 How to create your own custom tags
 How to set a root element
 How to create nested child elements
 How to create a document structure
 How to use comments

You will learn from scratch how to convert excel data into XML and also 
how to convert xml to excel.

Who this course is for:

  • Exel beginners
  • XML beginners
  • Beginner data analyst