this presentation contains narration and notes n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
This Presentation Contains Narration and Notes PowerPoint Presentation
Download Presentation
This Presentation Contains Narration and Notes

Loading in 2 Seconds...

play fullscreen
1 / 18

This Presentation Contains Narration and Notes - PowerPoint PPT Presentation


  • 179 Views
  • Uploaded on

This Presentation Contains Narration and Notes. To hear the narration, turn on your speakers or plug in headphones. If you would like to view this slideshow WITHOUT narration please do the following: Click on the ‘Slide Show’ tab in the ribbon.

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 'This Presentation Contains Narration and Notes' - dagan


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
this presentation contains narration and notes
This Presentation Contains Narration and Notes
  • To hear the narration, turn on your speakers or plug in headphones.
  • If you would like to view this slideshow WITHOUT narration please do the following:
    • Click on the ‘Slide Show’ tab in the ribbon.
    • In the ‘Set Up’ section click the ‘Set Up Slide Show’ button.
    • Under ‘Show Options’ check the box next to ‘Show without narration.’
    • Click ‘Ok’ and view the slideshow as normal.
    • The notes at the bottom are a transcription of the narration or extra information.
microsoft excel 10

Microsoft eXCEL 10

short course Section II

OFFERED BY

INSTRUCTIONAL COMPUTING

UNIVERSITY OF MISSOURI – ST.LOUIS

Fall 2011

goals of this short course
Goals of this short course
  • Using excel as a database
  • Setting up a home budget
database
Database
  • A database is collected data that is organized.
    • It is used to find out some specific information that you have created the database for.
    • The user gives the data a purpose, but if there is no purpose a database could beuseless.
setting up the data base
SETTING UP THE DATA BASE
  • Set up the data base with each field/category as a column and each record as a row. The name of your field is the top cell in the column.  Widen the column if needed to show your full field. In most cases press <Tab> to move to the next field and <Enter> to move down to the next record. The image to the right is going to be our example.
filtering
FILTERING
  • Click on any categorized cell, e.g. Last Name
  • Click on the Data tab
  • Click on Filter
filtering examples
FILTERING EXAMPLES
  • Use drop down menu to filter your data
  • Click on Text Filters -> Custom Filters
filtering examples1
FILTERING EXAMPLES
  • Let’s say we want to filter our data by last name and we need any entry starting with “c” or a letter before “c” in the alphabet.
filtering examples2
FILTERING EXAMPLES
  • Here is the result of the filtering.
  • Notice the row numbers filtered are marked blue.
  • Use drop down menu and check Select All to get the full list back.
home budget
Home Budget
  • A home budget shows people how much money they are making and spending.
    • It allows people to plan ahead so they can save money for certain goals.
setting up your home budget
Setting up your home budget
  • You should set up labels for your budget.
  • Labels include dates, expenses, revenue, etc.
  • It is your preference on which direction you make the budget go, but in our example we are going to have the date going horizontal and the data going vertical.
setting up your formulas
Setting up your formulas
  • Before entering in your data, you should do the formulas beforehand as it makes it easier to calculate later.
  • We are going to calculate the net income (paychecks minus expenses), balance of our checking account($100 starting balance), balance of our savings account ($200 starting balance), and balance of one credit card ($400 at the moment).
entering your data
Entering your data
  • Since the formulas are setup you can now enter your data based on what you spent and made during the months.
  • If extra expenses or revenue come in then you have to correct your budget.
continuing the home budget
Continuing the Home Budget
  • When the next year begins you can create a new worksheet in the same file.
  • Rename Sheet1, Sheet2, Sheet3 to your liking, (we used the new years) and create new sheets so you can have as many years as possible.
questions
Questions?

If any further questions arise, please contact a lab consultant in any of the following Instructional Computing Labs.

SSB 103

SSB 452

Benton Hall 232

Math TLC (UC 050)

Ward E. Barnes Library

Thomas Jefferson Research Commons

additional information
Additional Information
  • http://www.cetc.umsl.edu
    • The Microcomputer Program at the University of Missouri-St. Louis offers day and evening computer courses as part of the Chancellor's Certificate series.
  • http://www.umsl.edu/stg
    • The Online Student Technology Guide has answers to many computing questions.
  • http://help.umsl.edu
    • Online self-service solutions for UMSL Technology Issues