Instructor Josh Rischin outlines 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 data being well-structured,…it is simply not possible.…If you'd like to follow along, open up XOL StructuredData.…Structured data is data organized into rows and columns.…Take this example,…which is an extract from a company's chartered accounts.…We have a cost center, a general ledger code,…and an amount, in this case full year actuals.…Clearly this data is not well-structured,…as the cost center name appears once…and then we have blank cells.…We also have blank rows in our data.…
And as you can see,…the data itself is out of alignment between the columns.…Let's go ahead and prove this…while highlighting the date in columns C and D.…Let's go and try to produce a simple 2-D pie chart…by selecting Insert, Pie, 2-D Pie.…Now, as you can see,…Excel Online is having a lot of trouble charting the data,…simply because it is poorly structured.…Let's go to our second example…by clicking on the Example2 worksheet.…This is exactly the same data,…however, as you can see, it is clearly better structured.…
- Creating and editing workbooks
- Integrating the desktop version of Excel
- Sharing workbooks and assigning access privileges
- Creating charts
- Designing forms and surveys
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.