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 chart of 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 by highlighting the data…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,…
Note: This course is for users who know the basics of the Excel desktop app, but are new to the web browser version, Excel Online. It emphasizes features that work differently in Excel Online. For basic Excel guidance, please see Learning Excel 2016 or Excel 2016 Essential Training.
- Creating and editing workbooks
- Integrating the desktop version of Excel
- Sharing workbooks and assigning access privileges
- Creating charts
- Designing forms and surveys