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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- using solver table to do sensitivity analysis
- microsoft excel tutorial 1 courses
- excel basics training
- creating a schedule using excel template file name excel 1
- intermediate microsoft word fema
- trouble shooting for excel weebly
- excel tutorial short cuts
- formatting in excel quia
- practical uses of microsoft excel
Related searches
- microsoft excel basics pdf
- ms excel basics tutorial pdf
- free excel basics for beginners
- excel basics pdf
- excel basics cheat sheet
- excel basics for beginners step by step
- excel basics pdf 2016
- excel basics tutorial free
- excel basics for beginners
- youtube excel basics 2010
- excel basics training free
- excel basics tutorial for beginners