2 - Excel Pivot Tables

2 - Excel Pivot Tables - BIT 200 Personal Productivity...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Session 2 Excel Pivot Tables BIT 200 Personal Productivity
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Today’s Agenda § What’s in the News? § Student Consultants § Excel Basics Tutorial -- Reflection § Spreadsheets § Getting Started with Excel 2010 § Lab: Tutorial 5
Background image of page 2
Today’s Learning Objectives § Understand the concept of a computer spreadsheet and its various uses § Understand Excel tables, including sorting and filtering in a table § Understand how to use subtotals in Excel § Understand Excel PivotTables
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
What’s In the News? 4
Background image of page 4
Student Consultants – Office Hours 5 Name ID Office Hours Kush Patel kushap Monday, 5:30-7:30 PM Keivelle Lake keivelle Friday, 11:30 AM-1:30 PM Amy Kaminski amykam Monday, 11:30 AM-1:30 PM Emily Carroll eccarrol Monday, 3:00-5:00 PM Bennet Kim bennetj Friday, 2:30-4:40 PM Ali Khalil khalila Friday, 9:30-11:30 AM
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Excel Basics Tutorial § Reflection
Background image of page 6
Label: January Contents: 10.2 Defined Name: JanuarySales Cell Reference: C2 Stored as 10.213456 Displayed as 10.2 Month Sales (mils.) January 10.2 $ February 12.0
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/04/2012 for the course BIT 200 taught by Professor Moore during the Fall '08 term at University of Michigan.

Page1 / 23

2 - Excel Pivot Tables - BIT 200 Personal Productivity...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online