It’s a rare occasion when a spreadsheet doesn’t need a change of layout before it is finished. When this happens in Excel, with a click of the mouse you can easily add that extra column or delete those unwanted rows.
Ten Common Spreadsheet Terms
Here is a quick list of 10 of the most common Spreadsheet terms. A handy tool for those new to using a spreadsheet program like Excel or Microsoft Works.
Basic Excel 2003 Spreadsheet Tutorial
This tutorial covers creating a basic spreadsheet in Excel 2003. The topics covered include how to enter data, using formulas and functions, and formatting the spreadsheet.
Excel Tutorial Series
Each free Excel tutorial covers either an introductory or intermediate level topic in Microsoft Excel 2003 or 2007. Each tutorial will give you a good understanding of how to use Excel and what you can accomplish with the program.
Parts of the Excel Screen
This labeled picture shows the main parts of a Excel spreadsheet work area. Components include the active cell, name box, column letter, row number, formula bar and sheet tabs.
Entering Data in Excel
Learn how to enter data into an Excel spreadsheet. Topics covered include planning the spreadsheet, cells and cell references, data types, widening columns and editing cells.
Print Gridlines and Headings in Excel
This article shows you how to print gridlines and headings in Excel 2007. A step by step example is included showing you how to print gridlines and headings in Excel.
#REF! - Invalid Cell Reference Errors
Invalid cell reference errors occur when a spreadsheet formula contains incorrect cell references. This article discusses the causes and cures for this common error.
Basic Calculations in Excel Spreadsheets
This series of Excel Tutorials will teach you the fundamentals of using formulas and functions to perform basic calculations in Excel spreadsheets.
Excel Math
These articles cover how to carry out basic math operations Microsoft Excel. If you want to know how to add, subtract, multiply, or divide numbers in Excel, these articles will show you how.
Excel Printing
Printing in Excel has a variety of options. These options can be accessed through a number of locations including the print button on the standard toolbar and several options under the file menu.
How to Use Excel's Format Painter
To quickly copy formatting from one cell or group of cells to another part of the spreadsheet use the format painter in Excel. The format painter icon is on the formatting toolbar. It is very useful when extending a spreadsheet to accommodate new data and you need to format the new cells to match the original data area.
Using Excel's AutoFormat Option
Formatting a spreadsheet effectively can make the most important information on the spreadsheet stand out from the rest of the data. To accomplish this you can use one of the 17 AutoFormat styles available in Excel to give your spreadsheets a professional look that makes them easy to read.
Add and Remove Columns and Rows in Excel
It’s a rare occasion when a spreadsheet doesn’t need a change of layout before it is finished. When this happens in Excel, with a click of the mouse you can easily add that extra column or delete those unwanted rows.
Excel Error Message Help
If you get an error message in Excel you might not get much help from the program in finding out the cause. The articles listed here cover the cause and cures for a number of common error messages in Excel, such as #REF!, #NULL!, and #####.
Excel 2007 Spreadsheet Print Options - Part 1
This tutorial on spreadsheet print options covers how to use the print options in Excel to set a print area, print an entire spreadsheet, or print just selected areas.
Excel 2007 Spreadsheet Print Options - Part 2
This tutorial on spreadsheet print options covers how to use the print options in Excel to set a print area, print an entire spreadsheet, or...
Adding Print Options to the Quick Access Toolbar
The Quick Access Toolbar is used to store shortcuts to frequently used features in Excel. This tutorial shows you how to add the autoformat button to the Quick Access Toolbar.
Sumber : http://spreadsheets.about.com/od/excel101/Excel_101_How_to_Use_Excel_Spreadsheets.htm
No comments:
Post a Comment