Class Notes (807,001)
Canada (492,560)
Dr.Hurst (27)
Lecture 3

Notesolutions COMP SCI 1B03 Lecture 3.docx

2 Pages
Unlock Document

McMaster University
Computer Science

September 17th 2012 Totals and Subtotals - Totals and Subtotals - Totals available through the "Total Row" box - Subtotals can only be applied to ranges - Sort the data by the column you want to subtotal - "Convert to Range" - Data tab, Outline group, Subtotal button - "At each change in" (sorted column) - Outline levels allow you to view the data in various levels of detail Structured References - You can replace the specific cell or range address with a structured reference, the actual table name or column header - Syntax: Tablename[qualifier] - Example: Summary[Sales] = SUM(Summary[Sales]) - Qualified vs. unqualified references - Unqualified references don't include the table name. - You can use unqualified references in a calculated column or formula within an Excel table, however you need to use qualified references outside the table or in another worksheet when referring to an Excel table or a portion of the table. PivotTables - Sometimes large tables can be difficult to interpret - PivotTables allow us to summarize data into categories using functions (detailed data is not showed) - Quick and concise analysis - Named as such since data can easily be "pivoted". Terminology - Values fields - the fields containing the data to be summarized - Category fields - the fields
More Less

Related notes for COMPSCI 1BA3

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.