Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 44 Minute(s)
Language
English
Taught by
Bluelime Learning Solutions
Rating
2 views
Course Overview
Step by Step guide on converting from Excel to XML
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.
Course Content
- 3 section(s)
- 32 lecture(s)
- Section 1 Introduction to Basic Excel
- Section 2 Introduction to Basic XML
- Section 3 How to Convert Exel Data into XML
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
Skills covered in this course
Reviews
-
BBecky DeWaters
Perfect for someone very new to Office/Excel and to XML. You can go from total beginner to knowing how to do this using the course. The instructor is very friendly and succinct. That said, if you already have Excel experience and some XML knowledge, the main purpose of the course is already satisfied in the title - now you know that you can work with XML data in Excel - and you'd do fine to go search the web for explainers, and skip the course.
-
PPaul Cartwright
Very Disappointed, too basic for learning anything and is just a very basic overview
-
FFred Flintstone
I was expecting it to discuss XML and the focus has been on setting Office up. I already have it up and running. Hopefully it gets better. The whole purpose was to focus on the XMto/from XML, after all that is what the title says. There was a total of 10 minutes devoted to the subject. Ave your money if this is what you are looking for. Only gave it 1 1/2 stars because it can be a really basic intro to excel fir those that need it. But, seriously, if you are looking fo xml in Excel, you're not a beginner.
-
WWilliam Mendoza
OK for beginners, good instructor.
