Microsoft excel
This presentation is the property of its rightful owner.
Sponsored Links
1 / 20

Microsoft Excel PowerPoint PPT Presentation


  • 282 Views
  • Uploaded on
  • Presentation posted in: General

Microsoft Excel. Workbooks and Worksheets Mrs. Stevens. What is Microsoft Excel?. Microsoft Excel is an electronic spreadsheet developed by Microsoft. Each file created in Excel is called a Workbook. My Grades.xlsx. Familiar Features of Microsoft Excel.

Download Presentation

Microsoft Excel

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


Microsoft excel

Microsoft Excel

Workbooks and Worksheets

Mrs. Stevens


What is microsoft excel

What is Microsoft Excel?

  • Microsoft Excel is an electronic spreadsheet developed by Microsoft.

  • Each file created in Excel is called a Workbook.

My Grades.xlsx


Familiar features of microsoft excel

Familiar Features of Microsoft Excel

  • Icon – Green and White and a large X

  • Excel 2010 File Extension - .xlsx

My Grades.xlsx


Features of microsoft backstage in excel

Features of Microsoft backstage in Excel

  • Green File Tab

    • Matches Icon color

  • Same Menu Items as…

    • Word

  • Same Menu Items as…

    • PowerPoint


Familiar features of microsoft command ribbon in excel

Familiar Features of Microsoft Command Ribbon in Excel

  • Home

  • Insert

  • Page Layout

  • Review

  • View

  • Home

  • Insert

  • Page Layout

  • Review

  • View

HOME

INSERT

Watch for new commands on these familiar ribbons…

PAGE LAYOUT

REVIEW

VIEW


New features of microsoft command ribbon tabs in excel

new Features of Microsoft Command Ribbon tabs in Excel

  • Formulas

  • Data

Formulas

Data


Familiar microsoft page layout features in excel

Familiar Microsoft page layout features in Excel

  • Title Bar

  • Save Icon

  • Undo and Redo Arrows

  • Quick Access Toolbar (QAT)

  • Command Ribbons

  • Title Bar

  • Save Icon

  • Undo and Redo Arrows

  • Quick Access Toolbar (QAT)

Undo & Redo Arrows

Title Bar

Save Icon

  • Command Ribbons

QAT

Command Ribbons


New microsoft page layout features in excel

New Microsoft page layout features in Excel

  • Blank Page is a grid

    • Boxes called Cells

    • Like Graph Paper

  • Columns

    • Up & Down

    • Named by Letters

  • Rows

    • Left to Right

    • Named by Numbers


New microsoft page layout features in excel1

New Microsoft page layout features in Excel

  • Name Box

    • Identifies the Active Cell

    • Ex: C3

  • Formula Bar

    • Type in to enter Cell Contents

    • Ex: Ships

    • Can enter:

      • Text

      • Numbers

      • Formulas


What are cells in excel

What are cells in Excel?

  • Cells – boxes in a worksheet layout

  • Active Cell - Where a column and row intersect

  • Cell Name – By Letter of Column & Number of Row

  • Example: Cell C3

  • Each cell can only have ONE piece of data in it

  • What do you notice about Column C and Row 3?


How to create a workbook

How to create a workbook

  • Open Microsoft Excel

  • Double Click Desktop Icon

  • Or…Go to “Start”

    • “All Programs”

      • “Microsoft Office”

        • Click the Excel Icon

  • Can you name a 3rd way?


  • How to save a workbook

    How to save a workbook

    • Go to “File” (Backstage View)

    • Click “Save”

    • “Save as…” Dialog Box appears

    • Be sure to save in YOUR folder

    • Default name is “Book1”

    • Rename and click “Save”


    Your turn

    Your turn…

    • Open Excel

    • Go to “File”  “Save”

    • Navigate to this location:

      • Project Drive (S:) Drive

        • Open - “Stevens_ProbSolv” Folder

        • Open – “Excel Projects” Folder

    • Name your workbook this way:

      • Your Last Name_ID#_Xprj1

      • Example: Stevens_348242_Xprj1

    • Click “Save”


    Basic terms

    Basic Terms

    • Excel

    • Workbook

    • Worksheet

    • Cells

    • Active Cell

    • Columns

    • Rows

    • An electronic spreadsheet application

    • An Excel file (like a notebook)

    • Pages in the Workbook

    • Boxes where a column and row intersect (cross/meet)

    • Identified by the Column Letter & Cell Number

    • Cells going up/down – Identified by a letter of the alphabet

    • Cells going across (left to right) – Identified by a number


    Spreadsheet review slides

    Spreadsheet Review slides

    Do you remember this?


    Electronic spreadsheet

    Electronic Spreadsheet

    • An interactive computer program that…

    • organizes information into software-defined rows and columns

    • adds up the data, using a formula, to give a total or sum

    • can generate charts or graphs of the data.


    Excel worksheet

    Excel Worksheet

    • The pages in the workbook.

    • Each Workbook has 3 worksheets

    • Worksheets can be added to or removed from the workbook.


    Ledger vs excel workbook

    Ledger VS Excel Workbook

    • Bound Book

    • Has Paper Pages

    • Storing Uses Extra Space

    • Easily Damaged/Lost

    • Hard to Read - Handwritten

    • Computer Program

    • Has Electronic Worksheets

    • Easily Stored on Local or External Disk

    • Easy to Read – Computer Fonts

    Ledger

    Excel Workbook


    Spreadsheet vs excel worksheet

    Spreadsheet VS Excel Worksheet

    • Paper Pages in a Ledger

    • Pages have Columns and Rows

    • Handwritten Data

    • Hand Calculated Data

    • Work is Slow

    • People make Mistakes

    • Not easy to add or remove pages

    • Electronic Worksheets

    • Worksheets have Columns and Rows

    • Data Entered Electronically

    • Computer Calculated Data

    • Work is Fast

    • Accurate Computer Formulas

    • Pages can be added or removed easily

    Spreadsheet

    Excel Worksheet


  • Login