Excel Basics Training



Excel for Educators

Basics

[pic]

By Cyndi Bradford

Woodridge School District #68

Excel for Educators

Basics

[pic]

Main Screen

[pic]

Excel Ribbons

▪ The Ribbon spans the top of Excel.

▪ Related commands on the Ribbon are organized in groups.

o Home Ribbon

[pic]

• Most important Ribbon

• Fonts, borders, alignment, etc..

o Insert Ribbon

[pic]

o Page Layout Ribbon

[pic]

o Formulas Ribbon

[pic]

o Data Ribbon

[pic]

o Review Ribbon

[pic]

o View Ribbon

[pic]

To move commands you always use

o Right click on command

o Add to Quick Access Toolbar

[pic]

Entering Data

▪ Click on cell

▪ Type data

▪ Enter to move down a cell

▪ Tab to move over a cell

Changing Column Width or Row Height

▪ Double click the edge of a column – will fit the longest item in the column

▪ Drag from the edge as far as you want it

▪ Format, row or column, height or width

[pic]

Changing Format of Data or Cells

▪ Same font changes as Word

▪ Color fill options

▪ Gridlines

Inserting a Column or Row

▪ Excel with insert a cell, row, or a column

▪ Select a row, Insert, Rows or Columns

▪ Or right click

Delete a Column or Row

▪ Select the cell, row, or column you want to delete

▪ Delete

▪ Then choose what/how you want o delete the item(s)

▪ Or right click

Renaming Worksheets

▪ Right click on “sheet #” on the bottom of the worksheets

▪ Rename

▪ Type name

Other Formatting Choices for Cells: Always select cells first!

▪ Home Ribbon

▪ Format

▪ Format Cells

▪ Number Tab – what type of characteristics do your numbers have

▪ Mainly number, currency, date, time

[pic]

▪ Alignment Tab

[pic]

Completing a Series

Years, Months, Days, Number Patterns, etc..

▪ Enter the text (one word) or numeral (at least two) you want to start the series

▪ For text click the cell containing the text you want to start the series

▪ For numbers you must select the first two cells in the series

▪ Position the mouse over the bottom right corner of the cell to get a BLACK plus sign

▪ Drag the mouse over the cells you want to include in the series

Print Options

▪ Office Button, Print:

▪ Active sheet if only the worksheet showing

▪ Entire workbook if you want all worksheets in the workbook to print

[pic]

Sorting Items in a List

Data Ribbon

▪ Highlight the list you want sorted

▪ If simply “A to Z” or “Z to A” use left side

[pic]

▪ If you would like to sort by more than one characteristic use right Sort button

▪ You can click Add Level to sort by more than one feature

▪ You should check off if your data has a header

[pic]

Functions and Formulas

▪ Highlight cells you want a sum of and the empty cell you want the answer in

[pic]

-----------------------

Opening Excel

Start, Programs, MS Office, Excel

Formula Bar: Displays the cell reference/address and the contents of the active cell

Active cell has black outline

Cell Reference/Address: Column letter followed by row number “A1”

Help Feature: You are able to search categories or ask questions in this feature. It is very helpful.

Worksheet Tabs: Tabs that show your active worksheets

Orientation: Will allow you to change the degree in which your data appears in a cell. You always highlight the cells you want to change, click and drag the RED dot.

Center Across Selection!

Wrap text in a cell

Features to work with:

Properties….

If needed, change the orientation of the paper

Name:

Choose which printer to print to

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download