Introduction to Spreadsheets

Nov 20, 2014

60 likes | 227 Views

Introduction to Spreadsheets. Spreadsheet Terminology. Cell – the intersection of a row and a column Active cell - The cell in which you are currently working. Cell address - The location of a cell as identified by the column letter and row number. Parts of the Spreadsheet Window.

Share Presentation

Embed Code

Link

cell
cell address
active cell
row number
prepare financial statements
maintain student grades

chester-ashley

Download Presentation

Introduction to Spreadsheets

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

Introduction to Spreadsheets
Spreadsheet Terminology • Cell – the intersection of a row and a column • Active cell - The cell in which you are currently working. • Cell address - The location of a cell as identified by the column letter and row number.
Parts of the Spreadsheet Window Active cell cells Column C Row 5
What are Uses of Spreadsheets? • Prepare budgets • Maintain student grades • Prepare financial statements • Analyze numbers • Manage inventory • Make forecasts
Quiz

Mr Watson’s Introduction to Spreadsheets

Mr Watson’s Introduction to Spreadsheets. The ‘ Quick ’ and ‘ Easy ’ guide to using Microsoft Excel. By the end of the lesson, I want you to be able to say….

776 views • 15 slides

CS101 Introduction to Computing Lecture 22 Spreadsheets

CS101 Introduction to Computing Lecture 22 Spreadsheets. Focus of the 14th Lecture was on Word Processing. It was the first among the four lectures that we plan to have on productivity software We learnt about what we mean by word processing and also desktop publishing

501 views • 28 slides

Spreadsheets

What is a Spreadsheet?. SpreadsheetsA document, or table that is made up of rows and columns.Table Columns and rows of cells that can be filled with text, used to organize informationSpreadsheet programs, such as Excel, allows you to use calculations, formulas, graphs, charts, and sorting.. Why

781 views • 26 slides

Introduction to Spreadsheets in Project Planning

Introduction to Spreadsheets in Project Planning. Bent Thomsen. Project Planning. Use SLP methods to identify project tasks Project diagrams Activity diagrams List project tasks Estimate durations Estimate resources required. Use your own judgment.

243 views • 10 slides

Introduction to Spreadsheets

Introduction to Spreadsheets. Bent Thomsen. What is an electronic spreadsheet?. It is the electronic equivalent of an accounting worksheet, comprised of rows and columns to allow you to do many tasks in the organization of numbers in a clear, easy to understand format.

566 views • 43 slides

Introduction to Spreadsheets Software

Introduction to Spreadsheets Software. Learning objectives. Understand the advantages of using spreadsheets. Understand the basic formatting functions that can be used with spreadsheets. Know how to use basic functions and the advantages of displaying data in charts. . 2 of 21.

368 views • 21 slides

An Introduction To Creating Spreadsheets

An Introduction To Creating Spreadsheets. Trainer: Sam Capurso. Introduction to today’s training. Two sessions Purpose Structure OHS requirements and facilities Questions are welcome at any time! Thank-you gift at the end. Assessment methods.

309 views • 18 slides

Introduction to Spreadsheets

Introduction to Spreadsheets. What are Uses of Spreadsheets?. Prepare budgets Maintain student grades Prepare financial statements Analyze numbers Manage inventory Make forecasts. Advantages of Spreadsheets. Forecasting and making decisions Fast and efficient Automatically recalculates .

500 views • 24 slides

Introduction to Spreadsheets

Introduction to Spreadsheets. Year 7 ICT @ WBGS. Today's Lesson…. Introduce Excel Define a Cell Reference and Cell Range Create Formulas Use Functions. Toolbar. Formula Bar. Menu. Rows. Cell. Columns. Highlighted Cells. Range B2:B11. Range C3:E12. Using Formulas.

279 views • 11 slides

An Introduction to Spreadsheets

An Introduction to Spreadsheets. Objectives Spreadsheet Purposes & Advantages Layout of Spreadsheets. Data Planning Review. Menu. Objectives. Describe how an electronic spreadsheet program works Compare the merits of an electronic spreadsheet with those of a paper spreadsheet

1.55k views • 23 slides

Introduction to spreadsheets

Microsoft Excel. Introduction to spreadsheets. IT 8/9 Edmond Chin. What is Microsoft Excel?. Microsoft Excel is a software to create an electronic spreadsheet used for financial planning and budgeting (to keep track of numbers and data).

450 views • 13 slides

Introduction to Spreadsheets

Introduction to Spreadsheets. CSCI-N 100 Department of Computer Science and Information Science. Microsoft Office – Excel 2010. This is a worksheet. Multiple worksheets make up a workbook. The default is three worksheets to start. A worksheet is made of column and rows.

4.08k views • 35 slides

SPREADSHEETS

SPREADSHEETS. MS EXCEL 2007. OBJECTIVE. You should be able to: State what is a spreadsheet Give applications of Spreadsheets State the components of a spreadsheet Navigate a spreadsheet. What is a Spreadsheet?.

4.41k views • 85 slides

Module 4.1: Introduction to Spreadsheets

Module 4.1: Introduction to Spreadsheets. Contents. What is a spreadsheet? Basic functions Inputting data Use of formatting More about different types of data formats Effective input using AutoFill Test and improve knowledge and skill Module Activities. What is a spreadsheet?.

467 views • 24 slides

Introduction to Spreadsheets Chapter 1

Introduction to Spreadsheets Chapter 1. Lecture Outline. Microsoft Excel/Apple Numbers:. A powerful spreadsheet program that allows you to : Organize data Complete calculations Make decisions Graph data Develop professional looking reports Published organized data to web

530 views • 38 slides

7.1 Introduction to Spreadsheets

7.1 Introduction to Spreadsheets. The o rigin of e lectronic s preadsheet Spreadsheet is a jargon used in accounting. Accountants presented business data such as item quantity, cost and revenue in rows and columns on a large sheet of paper.

839 views • 77 slides

Spreadsheets

Spreadsheets. Microsoft Excel. Title bar, Menu & Tool bars. Title bar – shows file name. Menu bar – all program functions. Cell Reference – displays active cell. Tool bars – shortcuts to program functions. Column/Row headings. Formula bar – input cell information.

454 views • 25 slides

Introduction to Using Microsoft Excel and Spreadsheets

Introduction to Using Microsoft Excel and Spreadsheets. Click to continue. What is a spreadsheet. We tend to think of spreadsheets as being electronic. Originally, a spreadsheet was nothing more than information in table form on a sheet of paper. Making changes was difficult.

135 views • 7 slides

Lab 08 Introduction to Spreadsheets MS Excel

Lab 08 Introduction to Spreadsheets MS Excel. Objectives. The students should understand and have hands on experience in Working with Excel worksheets Formatting Excel sheets. Outline. Introduction to spreadsheets Basics of MS Excel Starting a new workbook Working with Excel worksheets

387 views • 31 slides

Mr Wood’s Introduction to Spreadsheets

Mr Wood’s Introduction to Spreadsheets. The ‘ Quick ’ and ‘ Easy ’ guide to using Microsoft Excel. By the end of the lesson, I want you to be able to say…. “I know what a spreadsheet is, I can enter simple data into a spreadsheet, and I can use simple formulae to perform calculations.”.

172 views • 12 slides

More Related