microsoft excel tutorial

Introduction into Microsoft Excel
Starting Up Microsoft Excel
Creating Formulas
Order Of Operations
Borders and Shading
Inserting A Chart


Introduction into Microsoft Excel
Microsoft Excel is allows you to create professional spreadsheets and charts. It performs numerous functions and formulas to assist you in your projects.

This tutorial will help you get started with Microsoft Excel and may solve some of your problems, but it is a very good idea to use the Help Files that come with Microsoft Excel , or go to Microsoft's web site located at http://microsoft.com/office/excel/default.htm for further assistance.

Back to top

Starting Microsoft Excel

• Two Ways


1. Double click on the Microsoft Excel icon on the desktop.


2. Click on Start --> Programs --> Microsoft Excel

Back to top

Creating Formulas

1. Click the cell that you want to enter the formula.
2. Type = (an equal sign).
3. Click the Function Button
4. Select the formula you want and step through the on-screen instructions

Back to top

Order of Operations Excel Uses

Precedence	Operation	Operator
1	Exponentiation	^
2	Multiplication	*
2	Division	/
3	Addition	+
3	Subtraction	-
4	Concatenation (putting 2 strings together, like Jenn & ifer)	&
5	Equal To	=
5	Greater Than	>
5	Less Than	<

Back to top

Adding Borders and Shading to Cells

1. Make sure you have the Formatting toolbar visible
   • Click on View --> Toolbars --> Formatting
2. Select cells you wish to format by left clicking on them and highlighting them
3. Click the button to shade a cell and/or the to give a cell a border

Back to top

Inserting A Chart

1. Select over the text you want to make your chart with
   
2. Click Insert --> Chart
   
3. Select the type of chart you want
   
4. Confirm or change your data range
5. Update the Chart Options
   
6. Select if you want to put it into the current worksheet or into a new worksheet
   

Back to top