3 - Excel Modeling and Analysis

3 - Excel Modeling and Analysis - BIT 200 Personal...

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

View Full Document Right Arrow Icon
Session 3 Excel Modeling and Analysis 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? § Wiki/Tech Topics Project Presentation Team 2 – Mobile Computing § Reflection on Last Week § Models and Model Analysis § Data Tables § Scenario Manager § Lab: Tutorial 10
Background image of page 2
What’s In the News? 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Wiki/Tech Topics Project § Team 2 – Mobile
Background image of page 4
Reflection on Last Week
Background image of page 5

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

View Full DocumentRight Arrow Icon
Spreadsheets – Last Week Spreadsheets are widely used to perform calculations to record and organize data to present data in easy-to- understand forms to build models to perform simulations (e.g. what-if analyses)
Background image of page 6
Client No Name Category Region MTD Sales YTD Sales Last Year 101 Argus Industries Manufacturing North $9,569 $13,775 $14,723 102 LEX Software Services South $3,527 $10,534 $12,887 103 National Bank Financial South $1,472 $8,123 $10,022 104 Services East $3,717 $12,374 $9,221 105 Northwest Investments Financial North $3,315 $18,656 $11,044 106 Nica Corporation Manufacturing West $6,542 $58,229 $52,559 107 MDC Enterprises
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.

Page1 / 22

3 - Excel Modeling and Analysis - BIT 200 Personal...

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