Microsoft Excel

Microsoft Excel

Excel specializes in creating and designing spreadsheets, or worksheets

Worksheet – area to insert dataWorkbook – a set of worksheets grouped

together

Microsoft Excel

By default, 3 worksheets come in each workbook Named at the bottom of the screen as Sheet1, Sheet2,

Sheet3 Click on to change from sheet to sheet

Right click on Sheet name to Rename Insert Copy Change Tab color Move

(you can just click, hold, and move it into the desired location)

Microsoft Excel

Cell – an individual box in a worksheet made up of a row and column intersecting Each cell has its own properties

Columns are labeled with LettersRows are labeled with Numbers

Microsoft Excel

Cell Reference – the cells address on the worksheet Located in the Name Box (Top Left) Will contain a Column Letter and a Row Number

Example – A4, B12, C7, D10

The cell with its address in the name box is the active cell The cell that data will be inserted into if typed

Microsoft Excel

Each cell has its own properties and can have different:

Fill color Font color Font size and name Horizontal Alignment Bold, Italics, Underline

Microsoft Excel

Label – Lettered heading that specifies what the data means

Value – Numbered data that appears under a label

Dates will appear as a Formatted Date by default Example – January 5 will appear as 5-Jan

You can change the format by: Right-click Format cells Select Desired Formatting

Microsoft Excel

To insert data into a cell: First select active cell Type numbers or letters into cell ENTER sets the data into place

To delete data in a cell: First select active cell Backspace will erase all cell contents OR Right click and go to Clear Contents

If you go to Delete, it will delete the entire cell and move all other cells up or over, changing your alignment

Microsoft Excel

To edit data inside of a cell: Select active cell Double click to insert cursor in order to edit data You can single click on the FORMULA BAR to insert

your cursor there

Microsoft Excel

Formula Bar – Top of worksheet where all cell data editing should take place

Microsoft Excel

Manually Adjust Column Width – Click and hold the divider line between the main column labels

AutoFit – Double click the divider line Sizes the column to automatically fit to the largest cell

in the column

Row height will be automatically adjusted when you change a cell font size

Microsoft Excel

Range – A group of cells selected at once Will be represented by the first cell to click and the

last cell to click separated by a colon Example – A1:B15 C10:H20

Select Entire Row or Column

SELECT ALL - You can make the entire worksheet active by the box to the left of Column A and above Row 1

Microsoft Excel

You can insert a row or column by: Select an entire row or column by clicking on the

Column or Row label (Letter or Number) With the entire row or column selected, Right-click

and Go to INSERT

You can combine cells by the icon on the toolbar that says MERGE AND CENTER < a >

Microsoft Excel

FORMATTING DATAEach cell can have different number

formatting, represented by an icon on the toolbar Money - $ Percentage - % Comma – (,) – insert commas Increase Decimal Decrease Decimal

Microsoft Excel

Create a Series (Autocomplete) – a numbered list that goes in a predetermined order Example – 1,2,3,4… or 5, 10, 15, 20….

To create: First insert the difference in two cells Ex – 1,2 or 5,

10 Select both cells Grab the fill handle in the bottom right corner

The cursor should be a cross with no points Click and hold, then pull until the series is completed

Microsoft Excel

To cut and paste or to MOVE DATA: Select the range Put cursor on the box around the range (Not the fill

handle) Cursor should be a cross with arrows on all 4 points

Click and hold the box, Drag and Drop it into place

Microsoft Excel

To copy and paste: Select the range Right-click and go to Copy Only make the TOP LEFT cell of the desired location

active Right-click and go to Paste

You can copy and paste by drag and drop by holding down the CTRL key when dragging and dropping Your cursor arrow will have a small plus to the right of

it

Microsoft Excel

To print a worksheet: Select the range you want to print Set Print Area

Page Layout > Print Area Print Preview will allow you to view the set area

before you print.

Excel Charts

Excel allows you to create charts out of the data in a worksheet.

Chart types are located under: 2007: Insert Tab 2003: Insert >Chart or Chart Wizard Icon

Excel Charts

Types of charts are: Column Line Pie Bar Area Scatter Stock Surface Doughnut Bubble Radar

Excel Charts

Steps to creating a Chart1. Insert data in to worksheet

1. Data should line up either vertically or horizontally2. Labeling data makes the chart easier to read

2. Highlight data to be included in chart3. Select the type of chart to create

Excel Charts - 2007

Once the chart is created, a CHART TOOLS tab will appear at the top

CHART TOOLS has 3 tabs Design Layout Format

Excel Charts - 2007

DesignCan change chart type Reselect data Change chart layoutSet Chart Style

Excel Charts - 2007

LayoutChart titleAxis titles – Main side titlesLegend – key to read the chartData Labels – Values on each section of chartData Table – Table at bottom with numerical

valuesGridlines – Vertical or Horizontal Chart Name – located at Far Right

Excel Charts - 2007

FormatChange Shape StylesWord Art StyleChange Chart Size

Excel Charts - 2003

Chart wizard is a 3 step process Before beginning, specify the range to chart Step 1 – Select Chart type Step 2 – Select range (Should be done before) Step 3 – Format Chart Step 4 – Chart Location

Excel Charts - 2003

Step 3, you can customize your chart appearance Chart title Axis titles – Main side titles Legend – key to read the chart Data Labels – Values on each section of chart Data Table – Table at bottom with numerical values Gridlines – Vertical or Horizontal Chart Name – Chart1, double click to change

Excel Charts

To edit charts, you can click on the area to change Right click and select the area to change

To change size of the chart: Click on the chart, Grab handles should appear on all

side and corners Grab any of the grab handles and resize the chart as

desired

Excel Charts

To Move Chart: Click on the chart, Grab handles should appear on all

side and corners Grab anywhere EXCEPT the GRAB HANDLES and

drag and drop it into place

Excel Charts

To Change Location of a chart Right click and select Move chart Chart can be moved to a different sheet as an OBJECT

IN: Chart can be inserted in a new sheet, default name

Chart1, where you can specify the name of the new sheet by typing it in the box.

Formulas

Each cell has its own properties So each cell can have an embedded formula The cell will only show the value The formula bar will show the formula that made the

value

Formulas

To insert a formula:1. Select the desired active cell2. Hit equals (=) to tell the program a formula will follow3. Use mouse to select the cells you wish to operate with4. Use keyboard to select the mathematical operator

1. Mathematical operators 2. Addition +3. Subtraction –4. Multiplication *5. Division /6. Parenthesis ( )7. Exponent ^

5. Hit the ENTER key to set the formula into place

Formulas

To edit a formula: Each cell reference you select inside of the formula

will appear in the formula bar as a different color To edit, insert your cursor into the formula bar

You can backspace to take away a cell reference You can click on another cell to add it to the formula

Formulas

Order of OperationPLEASE- ParenthesisEXCUSE - ExponentMY - MultiplicationDEAR - DivisionAUNT - AdditionSALLY - Subtraction

Formulas

Order of Operation Addition and Subtraction formulas will be whichever

cell reference appears first Multiplication and Division will be whichever cell

reference appears first When both types are present in one formula, be sure

to separate the equation with parenthesis Specify which cell references to operate with first Example (D1 + A2) / B3 Wrong D1 + A2 / B3