Microsoft excel
Download
1 / 20

Microsoft Excel - PowerPoint PPT Presentation


  • 366 Views
  • Uploaded on

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.

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 'Microsoft Excel' - lerato


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



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


    ad