Free Microsoft Training
Microsoft Office
All Template Categories
OpenOffice.org Calc spreadsheet
A spreadsheet is a computer application that simulates a paper, accounting worksheet.
It displays multiple cells usually in a two-dimensional matrix or grid consisting of rows and columns. Each cell contains alphanumeric text, numeric values or formulas. A formula defines how the content of that cell is to be calculated from the contents of any other cell (or combination of cells) each time any cell is updated.
Spreadsheets are frequently used for financial information because of their ability to re-calculate the entire sheet automatically after a change to a single cell is made.
A pseudo third dimension to the matrix is sometimes applied as another layer, or layers/sheets, of two-dimensional data.
Lotus 1-2-3 was the leading spreadsheet when DOS was the dominant operating system. Excel now has the largest market share on the Windows and Macintosh platforms.
Paper spreadsheets
The word “spreadsheet” came from “spread” in its sense of a newspaper or magazine item (text and/or graphics) that covers two facing pages, extending across the center fold and treating the two pages as one large one.
The compound word “spread-sheet” came to mean the format used to present book-keeping ledgers—with columns for categories of expenditures across the top, invoices listed down the left margin, and the amount of each payment in the cell where its row and column intersect—which were, traditionally, a “spread” across facing pages of a bound ledger (book for keeping accounting records) or on oversized sheets of paper ruled into rows and columns in that format and approximately twice as wide as ordinary paper.
Template: Training presentation: Excel 2007—Create your first workbook
This template contains training content that teaches newer Microsoft Office Excel 2007 users the basic skills they’ll need to create their first workbook.
Crabby goes chart crazy with Excel 2007
Crabby Office Lady
Summing up large quantities of information used to be time-consuming and daunting if you were unfamiliar with how to put it all together, particularly if you had to do it with a chart. Excel 2007 has made such huge improvements in the area of charts that you may find yourself making all sorts of charts for no apparent reason…other than it’s fun.
Charts make data visual. Instead of having to analyze columns of worksheet numbers, you can see at a glance what the data means.
In Excel 2007 you can make a chart in about 10 seconds, which you’ll see how to do in just a bit.
GoalsAfter completing this course you will be able to:
|
Excel 2007: Simple Formulas
Tour Of Excel: Formulas, Formatting, Sort, Filter, PivotTables, Charts, Keyboards
Excel Is Fun! How to build efficient systems of spreadsheets to save time, get promoted and have extra time for vacation.
Uploaded by ExcelIsFun on May 19, 2011
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm (all the way at bottom in the ”Other Excel Series” section)
Highline Community College Science Seminar: The Wonders Of Excel, May 20, 2011
Learn about the wonders of what excel can do with a tour of the different things that Excel can do:
1 Copy & Paste Special (2 Examples) (00:48 minute mark)
2 Keyboard Magic (3 Examples) (03:45 minute mark)
3 Number Format (06:03 minute mark)
4 Decimal (6:11 minute mark)
5 Date (5 Examples) (07:32 minute mark)
6 Percentage (15:02 minute mark)
7 Formulas and Relative Cell References (18:26 minute mark)
8 Formulas and Absolute Cell References (2 Examples) (21:47 minute mark)
9 Sorting (4 Examples) (27:27 minute mark)
10 Filtering (32:27 minute mark)
11 PivotTables (2 Examples) (35:19 minute mark)
12 Charts (6 Examples) (43:31 minute mark)
Category: Science & Technology ♦ YouTube
PowerPoint 2007 Layer Demo: Layering Items/Pictures – Layered Selection Pane
Outlook 2007 Demo: Preview your messages
Recent Comments