introduction to microsoft excel 2010 l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Introduction to Microsoft Excel 2010 PowerPoint Presentation
Download Presentation
Introduction to Microsoft Excel 2010

Loading in 2 Seconds...

play fullscreen
1 / 40

Introduction to Microsoft Excel 2010 - PowerPoint PPT Presentation


  • 98 Views
  • Uploaded on

Introduction to Microsoft Excel 2010. While Waiting (Do Now) . Launch Microsoft Excel Create a Blank Document Name and Save Document to Desktop. Standard Addressed.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Introduction to Microsoft Excel 2010' - tracy


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
introduction to microsoft excel 2010

Introduction to Microsoft Excel 2010

SPS Technology Department

while waiting do now
While Waiting (Do Now)
  • Launch Microsoft Excel
  • Create a Blank Document
  • Name and Save Document to Desktop

SPS Technology Department

standard addressed
Standard Addressed

Standard 1: Demonstrate proficiency in the use of computers and applications as well as an understanding of concepts underlying hardware, software, and connectivity.

SPS Technology Department

introduction to ms excel
Introduction To MS Excel

By the end of this session you will know and be able to:

  • Describe structure and function of a spreadsheet (i.e., cell, column, row, values, labels, chart, graph).
  • Create an original spreadsheet, entering simple formulas.
  • Use advanced formatting features of a spreadsheet application (e.g., reposition columns and rows, add and name worksheets, alignment of data).
  • Define and use functions of a spreadsheet application (e.g., sort, filter, find)
  • Identify, discuss, and explore how spreadsheets are used to calculate and graph in a variety of settings (e.g., schools, government, business, industry, scientific research labs).

SPS Technology Department

you will demonstrate this by
You Will Demonstrate This By
  • Creating a worksheet for
      • Book Inventory

or

      • Equipment Inventory

or

      • Class List

or

      • Attendance Sheets

SPS Technology Department

what is excel why do i want to know how to use it
What is Excel?Why do I want to know how to use it?
  • Excel is a spreadsheet program that allows large amounts of data to be stored, calculated, sorted, and accessed quickly.
  • Some uses:
    • Store Information
    • Maintain Budgets
    • Inventories
    • Attendance
    • Grade book

SPS Technology Department

launching excel
Launching Excel

In order to use a program, you must start—or launch—it

first.

1. Click the Start button.

The Start menu appears.

2. Click All Programs.

The left pane of the Start menu displays the programs

and menus installed on your computer.

3. Click Microsoft Office.

4. Select Microsoft Office Excel 2010.

The Excel 2010 program screen appears.

SPS Technology Department

workbook vs worksheets
WorkBook -vs.- Worksheets
  • A Microsoft Excel workbook is a file that contains one or moreworksheets.
  • A worksheet is the primary document that allows you to store and work with data. It is sometimes referred to as a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.

SPS Technology Department

workbook vs worksheet
Workbook -vs.- Worksheet
  • A Workbook by default has 3 worksheets
  • To create an additional Worksheet within a Workbook
    • Menu Bar>Insert>Worksheet
    • A Worksheet always insert to the left.

SPS Technology Department

naming a worksheet
Naming a Worksheet

Put cursor over Sheet Tab

Right Click and pick Rename from Pop-up Menu

Type in an Worksheet name

SPS Technology Department

columns rows cells
Columns, Rows, Cells
  • Columns labeled A, B, C . . .
  • Rows labeled 1, 2, 3 . . .
  • Cell - where Columns and Rows Intersected A1, C25, D32 . . . .

SPS Technology Department

resizing columns and rows
Resizing Columns and Rows
  • Resize a row - by dragging the line below the label of the row you would like to resize.
  • Resize a column - by dragging the line to the right of the label corresponding to the column you want to resize.

SPS Technology Department

alignment of data within cells
Alignment Of Data Within Cells
  • Numbers by default - right aligned
  • Labels/Words by default - left aligned
  • Data can be centered aligned – highlight data, select center alignment button on Formatting Toolbar.

7782

PD Center

Student Name

SPS Technology Department

alignment of data using toolbar icons
Alignment Of Data Using Toolbar Icons

Alignment Icons

Highlight Cells You Wish To Format

SPS Technology Department

slide16

1. Select the cell(s) you want to align.

2. Click the Home tab on the Ribbon and click an alignment button in the Alignment group.

SPS Technology Department

centering column headings
Centering Column Headings

Highlight Column Headings and Select Center Icon on Formatting Toolbar

SPS Technology Department

merge columns and center headings
Merge Columns and Center Headings

Merge and Center Headings over multiple Columns

  • Type Data in First Column of data
  • Highlight all Columns you wish to center over
  • Click on Icon in Formatting Toolbar

SPS Technology Department

formatting options using menu bar
Formatting Options Using Menu Bar
  • Highlight Cells You Wish To Format
  • On the Home Tab Click Format
  • Selecting Format Cells will bring to the next screen

SPS Technology Department

slide20

Select Data Category

SPS Technology Department

sort data in a column
Sort Data in a Column
  • Highlight Entire Column Or Row You Wish To Sort

Sort Ascending

Sort Descending

SPS Technology Department

sorting all data in worksheet
Sorting all Data in Worksheet
  • Highlight entire worksheet by selecting the blank area above the row 1
  • Click the Home or Data tab
  • Click sort- Custom sort
  • Sort by-click add level
    • Then by Secondary Sort

SPS Technology Department

summing cells and ranges
Summing Cells and Ranges

SPS Technology Department

formula bar
Formula Bar
  • Click to place the cursor into the Formula Bar so that you can perform or edit an equation.

=A2+A3

Will total up values in cells

=A2+A3

SPS Technology Department

using auto sum feature
Using Auto Sum Feature

Excel allows you to

quickly find the total

of a column or row of

Numbers using the

Auto Sum Feature

Highlight the Column or Row and then click on Auto Sum

SPS Technology Department

deleting and inserting columns and rows
Deleting and Inserting Columns and Rows

SPS Technology Department

1. Select the row or column heading(s) you want to delete.

2. Click the Home tab on the Ribbon and click the Delete button in the Cells group.

The rows or columns are deleted. Remaining rows are shifted up, while remaining columns are shifted to the left.

.

slide31

Inserting or Deleting a Column

Highlight row or column

Insert

Delete

SPS Technology Department

page setup
Page Setup

SPS Technology Department

slide33

The Print settings and Print Preview as shown in Backstage view. Use the print

settings in the left column to control how the document is printed. Use the print preview area in

the right column to preview how the document will look when printed.

SPS Technology Department

slide34

Save a new workbook

1. Click the Save button on the Quick Access Toolbar.

The Save As dialog box appears.

Other Ways to Save:

Press <Ctrl> + <S>. Or, click the File tab and

select Save.

2. Specify the drive and/or folder where you want to

save your workbook.

3. Enter the file name in the File name text box.

4. Click Save.

SPS Technology Department

slide36

Name of Printer

SPS Technology Department

your turn
Your Turn
  • Create a worksheet for
    • Book Inventory
    • Equipment Inventory
    • Class List
    • Attendance Sheets

SPS Technology Department

links for learning online microsoft excel resources
Links for Learning Online Microsoft Excel Resources
  • Florida Gulf Coast University
    • http://www.fgcu.edu/support/office2007/Excel/index.asp
  • Get to Know Excel
    • http://office.microsoft.com/en-us/excel-help/

SPS Technology Department

references
References
  • Caughlin, J. (2002). Excel Workshop for Teachers. Watertown, MA: Tom Snyder Productions.

SPS Technology Department

rubric
Rubric

Excel I

Teacher Name: _____________________________________

Student Name:     ________________________________________

SPS Technology Department