Its a Spreadsheet Whats a Spreadsheet A spreadsheet

  • Slides: 13
Download presentation
It’s a Spreadsheet What’s a Spreadsheet

It’s a Spreadsheet What’s a Spreadsheet

A spreadsheet is: An interactive computer program that organizes and analyzes data

A spreadsheet is: An interactive computer program that organizes and analyzes data

What does it look like? Columns Rows Numbers

What does it look like? Columns Rows Numbers

What does it do? Calculates Analyzes organizes

What does it do? Calculates Analyzes organizes

Spreadsheets- Who uses them? Accountants *Track income, and expenses *Generate reports *Cash Flow

Spreadsheets- Who uses them? Accountants *Track income, and expenses *Generate reports *Cash Flow

Spreadsheets- Who uses them? Sales Personnel track expenses commissions

Spreadsheets- Who uses them? Sales Personnel track expenses commissions

Spreadsheets- Who uses them? Scientists enter data from experiments perform accurate calculations create tables

Spreadsheets- Who uses them? Scientists enter data from experiments perform accurate calculations create tables and graphs

Spreadsheets- Who uses them? Investors variables such as cost can be plugged into a

Spreadsheets- Who uses them? Investors variables such as cost can be plugged into a spreadsheet to determine profitability In real estate he can plug in property cost, taxes and mortgage rate to determine final cost

Spreadsheets- Who uses them? Marketing Managers sort raw data by product making money losing

Spreadsheets- Who uses them? Marketing Managers sort raw data by product making money losing money track business performance compare locations track competition

Spreadsheets- Who uses them? Students Track your grades Complete Science projects

Spreadsheets- Who uses them? Students Track your grades Complete Science projects

Vocabulary Go to my website Open the file named: Spreadsheet Vocabulary Re-Name it: last

Vocabulary Go to my website Open the file named: Spreadsheet Vocabulary Re-Name it: last first Excel vocab Find the definition that applies to spreadsheets

Short Instructional videos p 1 videos from http: //www. microsoft. com/mac Create a new

Short Instructional videos p 1 videos from http: //www. microsoft. com/mac Create a new blank workbook Explore the Excel user interface Move within worksheet cells Enter data Select and format data

Short Instructional videos p 2 videos from http: //www. microsoft. com/mac Copy and paste

Short Instructional videos p 2 videos from http: //www. microsoft. com/mac Copy and paste formatting and data Edit data Insert and resize columns Save in a new folder