CSCI0020 Microsoft Excel Tutorial, Fall 2007

Short Description
CSCI0020 Microsoft Excel Tutorial, Fall 2007. Introduction. Chances are you’ve used Microsoft Excel before. Its grids of rows and columns …

Website: www.cs.brown.edu | Filesize: 685kb

Content
CSCI0020 Microsoft Excel Tutorial, Fall 2007
Introduction
Chances are you’ve used Microsoft Excel before. Its grids of rows and columns
are perfect for making lists and schedules as well as for organizing data in
general.
Excel is widely used today in the sciences, engineering, economics, accounting,
and everyday uses such as party planning or creating a daily routine.
In this reference and the accompanying tasks and assignments, we want to show
you how to employ Excel’s most useful features and invite you to explore its
more complex capabilities a little bit.
Basics
When you first open Excel you’ll see a blank workbook consisting of three
sheets. Each sheet is made up of a grid of cells (those little boxes in which you
can enter information).
You may already be familiar with the basics of how these cells can help keep
information organized, but the real power of Excel is that cells can be linked
together and used in calculations. This way when you change information in one
cell, the other cells that are linked to that cell will automatically update their
values.The Goal of Today’s Lab
You’ll be using Excel to create a weekly budget report. We want to introduce you
to linking cells together, setting up calculations, and formatting data to make it
more readable and aesthetically pleasing.
Task
Open up a new Excel file by going to Start All Programs Microsoft Office
Microsoft Excel. Rename your first sheet “Budget” by right-clicking on the “Sheet
1″ tab and selecting “Rename.” Now create your Budget sheet to include 5 days
of data: Mon, Tues, Wed, Thur, Fri (hint: make these columns in the
spreadsheet).
*note: the glowing yellow circle in the upper-left corner of your window is used to
Save your file. Be sure to save your work periodically.
Now add two kinds of income and four expenditures in to your spreadsheet so
you can keep track of money flow on a day-to-day basis throughout the week.
Examples of income could be salary, tips, stipends. Some possible expenditures
are food, clothing, utilities. In any case be creative and fill the chart with values
for each income and expenditure on each day (feel free to make up numbers).
*…