El-GibboR

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.

Starting Microsoft Excel

Two Ways

Double click on the Microsoft Excel icon on the desktop.

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

Creating Formulas

Click the cell that you want to enter the formula.

Type = (an equal sign).

Click the Function Button

Select the formula you want and step through the on-screen instructions

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	<

Inserting A Chart

Select over the text you want to make your chart with

Click Insert --> Chart

Select the type of chart you want

Confirm or change your data range

Update the Chart Options

Select if you want to put it into the current worksheet or into a new worksheet

Freeze Pane

If you need to see the column headings even after scrolling, you could try freezing the pane in Excel. To do this, open your Excel spreadsheet. Select the cell that is below the right-most column heading that you wish to see. Then under the Window menu, select Freeze Panes.

In our example, we've selected cell A2 which is just below the "Order ID" heading.

Now when you scroll down, you should still continue to see the column headings.

To use the Validation Input Message as a cell Comment

1. Select a cell and from the Data menu, select Validation.
2. Select the Input Message tab.
3. Fill the two text boxes Title and Input message.
4. Click OK.

Screenshot // Using the Validation Input Message as a Cell Comment

To validate text entries

1. Select the range of cells.
2. From the Data menu, select Validation.
3. Select the Settings tab.
4. From the Allow dropdown list, select Custom.
5. In the Formula box, enter the following formula:
=IsText (A1)
where A1 is the first cell in the range.
6. Click OK.

Previous

Next