Excel 101- How to Use Excel Spreadsheets
Excel beginners will find all the basics needed on how to create effective and professional looking spreadsheets. A beginner’s guide covers essential information and a labeled diagram of the Excel screen, helps you learn what some of this spreadsheet terminology means. Free step by step tutorials and tips help make that first adventure in creating spreadsheets go smoothly.
What is Excel?
Microsoft Excel is an electronic spreadsheet program that people use for storing, organizing and manipulating data. The types of data that Excel can use includes numbers, text and formulas. Formulas are used to perform basic mathematical operations, calculating repayment plans for loans or mortgages, and to find the average, maximum, or minimum values in a specified range of data.
Microsoft Excel is an electronic spreadsheet program that people use for storing, organizing and manipulating data. The types of data that Excel can use includes numbers, text and formulas. Formulas are used to perform basic mathematical operations, calculating repayment plans for loans or mortgages, and to find the average, maximum, or minimum values in a specified range of data.
Beginners Guide to Excel 2007
This Ten Part Series of Free Excel Tutorials is intended for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, using formulas and formatting, how to make charts, widen columns, and how to add and remove columns and rows.
This Ten Part Series of Free Excel Tutorials is intended for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, using formulas and formatting, how to make charts, widen columns, and how to add and remove columns and rows.
Beginner's Guide to Excel 2003
An Eleven Part Series of Free Excel Tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, using formulas and formatting, how to make charts, use Excel headers and footers and to freeze panes so that you can always see column and row headings.
An Eleven Part Series of Free Excel Tutorials for the absolute beginner. Learn about the parts of the Excel screen, how to enter data, using formulas and formatting, how to make charts, use Excel headers and footers and to freeze panes so that you can always see column and row headings.
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.
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.
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.
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.
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.
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.
#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.
Invalid cell reference errors occur when a spreadsheet formula contains incorrect cell references. This article discusses the causes and cures for this common error.
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.
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.
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.
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.
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.
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.