Explore the concept of structured data, and why is it important when endeavoring to chart and analyze data.
- [Instructor] Charting is easy in Excel Online.…However, without the data being well structured…it simply isn't possible.…If you'd like to follow along with me…then have XOL StructuredData open.…Structured data is essentially data…that is organized into rows and columns.…Take this first example here,…which is an extract from a company's chart of accounts.…We have a cost center,…a general ledger code,…and an amount which is four year actuals.…Now at a glance, this data doesn't appear…to be very well structured.…
The numbers are out of alignment,…there are blank rows,…and there are gaps in the data set.…To proof this, let's select columns c through to e…and all the way down to the end of our data range,…let go of the mouse.…Now let's go to insert,…click on the drop down box under pie…and then select 2D pie.…Now as you can tell,…Excel Online is clearly having a lot of trouble…charting this information.…Let's go and look at example number two.…Believe it or not, this is exactly the same data.…
However, it is very well structured.…
- Creating and editing workbooks
- Using Excel Online shortcuts
- Integrating the desktop version of Excel
- Sharing workbooks and assigning access privileges
- Creating and editing charts
- Designing and creating forms
Skill Level Beginner
1. Getting to Know Excel Online
2. Working Seamlessly with Excel Online and Excel Desktop
3. Collaborating with Excel Online
4. Charting in Excel Online
5. Creating Forms with Excel Online
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.