OMIS-Excel Notes-Linda's

60 70 80 90 100 grade component percentage

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ere is a solution... Using Subtotals to Analyze a List 46 Excel Notes Jessica Gahtan OMIS2000 Your Turn! • But what if we want to see the data behind the calculations to better understand our results? You have options... – Expand back – Expand only areas of interest • NOW YOU TRY! – What do you want to aggregate and how? – Remember to PLAN AHEAD! Understanding Pivot Table Basics A pivot table Do you have more data than you know what to do with? Do you want to see trends and patterns at a glance? Then PivotTable reports are for you. They enable you to create new views of worksheet data in seconds. Hundreds or thousands of pieces of information swing into place, revealing the meanings behind the data. Pivot Table 47 Excel Notes 48 Jessica Gahtan OMIS2000 Excel Notes Pivot Table – End Result 49 Jessica Gahtan OMIS2000 Excel Notes Jessica Gahtan OMIS2000 Adding Levels and Making Changes • What if you wanted the data organized by both collection and size? Or we wanted averages instead? • Would a different way of organizing the table be more effective? • Conclusions: – Sometimes less is more (1 table or 2?) – Structure can make a difference – EXPERIMENT! – What if you want to look at only a subset of the data? Recall: Filtering Applying Filters to Fields 50 Excel Notes Jessica Gahtan OMIS2000 Data Visualization • Tables can sometimes be the more impactful way of generating an insight • Mor...
View Full Document

This note was uploaded on 03/28/2014 for the course OMIS 2000 taught by Professor Hk during the Fall '13 term at York University.

Ask a homework question - tutors are online