1 / 19

Creating Spreadsheets

Creating Spreadsheets. Using Microsoft Excel to create spreadsheets. Spreadsheets. Anytime data is collected and analyzed, it must be stored somewhere. A spreadsheet is a type of file, or document, that is used to store, manipulate, and analyze data.

mandy
Download Presentation

Creating 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

  1. Creating Spreadsheets Using Microsoft Excel to create spreadsheets.

  2. Spreadsheets • Anytime data is collected and analyzed, it must be stored somewhere. • A spreadsheet is a type of file, or document, that is used to store, manipulate, and analyze data. • Microsoft Excel is a common application used to create spreadsheets.

  3. Spreadsheets vs. word processing • A spreadsheet is used to store, analyze, chart, forecast, and manipulate numbers. • A word processing document is a collection of words, pictures, and/or numbers in a formatted layout. • A word processor is not used to analyze data. • A spreadsheet is not used to create documents like letters and resumes.

  4. Microsoft Excel

  5. Excel screen • The Excel screen looks like a grid. • Each box in the grid is called a Cell. • Horizontal collections of Cells are Rows. • Vertical collections of Cells are Columns.

  6. Cell labels • To designate a Cell, you specify its Row and then its Column. • The Cell in the top left is A1. • The Cell in the bottom right is D6. • It’s kind of like the old Battleship game.

  7. Movement • You can move between Cells in many ways: • With the mouse • With the arrow keys on the keyboard • With the tab key

  8. Entering data • You enter data by choosing a Cell and typing in the data. • The example below shows a title (A1) and a column of numbers (A2..A6).

  9. Name box and formula bar • When you highlight a Cell, its name is shown in the Name Box (upper left). • The contents of the Cell are shown in the Formula Bar (upper right). • Note that Cell A5 is highlighted.

  10. Formula Bar • The Formula Bar allows you to perform math functions on selected Cells. • Here Cells A1..A5 are added together, and the result is placed A6, which is where the formula is entered. • All formulas must begin with an equal sign = .

  11. Math Functions • When you start a formula with =, you can use the basic math functions • Addition use + • Subtraction use – • Division use / • Multiplication use *

  12. AutoSum • The AutoSum feature is a handy tool to add Cells together. • Position the cursor on the Cell where you wish the total to appear, and click the AutoSum tool on the toolbar. It does the rest for you.

  13. Worksheets and workbooks • Excel stores spreadsheets in files called Workbooks. • A Workbook can contain many Worksheets. • On the following slide, note the Workbook name at the top is Book1. • The Worksheet names are near the bottom, here called Sheet 1, Sheet 2, and Sheet 3.

  14. Naming books and sheets • You name your Workbook when you save the file. • All Excel 2010 spreadsheets (Workbooks) have the file extension .XLSX • You can rename a Worksheet by right clicking on its name and then clicking Rename.

  15. Preformatted Workbooks • Like Word (with Templates), Excel has some preformatted document types that you can use to save you time formatting.

  16. Standard Windows elements • Like most Windows applications, Excel uses common file management functions: • Save • Save As • Close • New • Print • Open • Cut, Copy, Paste

  17. Industry uses of Excel • Any scenario that requires number management can use Excel: • Budgets • Inventory • Service time tracking • Forecasting • Data collection

  18. For more information See the Help menu in Microsoft Excel.

More Related