Learn how to convert excel data to XML from scratch
3.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
925 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn how to convert excel data to XML from scratch to your Wishlist.

Add to Wishlist

Learn how to convert excel data to XML from scratch

Step by Step guide on converting from Excel to XML
New
3.0 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
925 students enrolled
Last updated 8/2017
English
Current price: $10 Original price: $90 Discount: 89% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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 is the target audience?
  • Exel beginners
  • XML beginners
  • Beginner data analyst
Compare to Other XML Courses
Curriculum For This Course
31 Lectures
02:44:49
+
Introduction to Basic Excel
19 Lectures 01:51:48




Setting up office 365
11:03

Excel 2016 user interface
10:50

Exploring excel ribbon
05:57

Customising the quick access toolbar
05:38

Keeping tabs on the ribbon
12:29

Entering data into excel
10:31

Using formulas
05:55

Adding and removing worksheets
02:35

Resizing columns width
04:40

Making workbook read only
02:54

Add and remove columns and rows
04:46

Sharing your workbook and tracking changes
03:26

Protecting workbook from structural change
04:58

Protecting your workbook
03:21

Protecting your worksheet
03:08
+
Introduction to Basic XML
8 Lectures 42:08
XML introduction
01:37

XML Attributes
02:57

XML Naming
05:30

XML Document Structure
02:58

XML Tags
06:04

XML Namespace
10:08

XML Syntax
08:28

XML Elements
04:26
+
How to Convert Exel Data into XML
4 Lectures 10:53
Enable Exel Developer Tab
01:01

Create basic XML from excel data source
04:05

Convert Excel data into XML
04:47

Convert XML into Excel
01:00
About the Instructor
Bluelime Learning Solutions
4.0 Average rating
1,768 Reviews
38,816 Students
92 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.