Free Microsoft Training
Training for the 2013 applications
Office 2010 training
Office 2007 training
Office for Mac 2011 training
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.
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.
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
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.
After completing this course you will be able to:
Excel 2007: Simple Formulas
Microsoft Excel Resources – Pivot Tables
|PivotTable I: Get started with PivotTable reports in Excel 2007
How PivotTable reports organize, summarize, and analyze your data to reveal its meanings. How to create a PivotTable report yourself — fast!
|PivotTable II: Filter PivotTable report data in Excel 2007
How to filter to hide and display selected data in PivotTable reports
|PivotTable III: Calculate data in PivotTable reports in Excel 2007
Power tools: how to summarize data by using summary functions other than SUM, such as COUNT and MAX. How to show data as a percentage of the total by using a custom calculation. How to create your own formulas in PivotTable reports.
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)