|
221- Reviewing a workflow in Excel
a)
Open new spreadsheet
1)
Go to office button
2)
select the new option
3)
select blank workbook
4)
click create
5)
click the data
tab selecting from text and open an old file
6)
choose the
import if it is delimited click on next
7)
click tab
8)
click next to
identify what column data you want to work with
9)
select general
and then finish
10)
place where do
you want to put the data
11)
First cell of
the sheet that we are looking at
12)
Click ok bring
my information to my worksheet
b)
Now I got my
information I want to format it as a table
1)
Click on the
home tab
2)
Select format as
a table
3)
Select the style
I want , be sure that you have selected the table that I want to work with
4)
If the data got
header make sure that you select the box and click ok
c)
Now make sure
the data is calculated
1)
Select the cell
you want
2)
Put the formula
beginning with equal sign, select the cell and put enter
3)
Now the data is
calculated in the first row
4)
Drag the formula
threw out the table
5)
Scroll up among
the cells to make sure my data is calculated all
d)
Go to page
layout view to see how it is going to print
1)
I can add a
header to my information
2)
Click on the
cell and add the header
e)
To print the
information :
1)
Go to the office
button
2)
Click print and
choose from the three options to print out my information
f)
Save the
information
1)
Go to office button
2)
Click save as
3)
Choose the
option you want
4)
Select excel
97-2003 so it will be able to open in different excel 2007 for those who don’t
have 2007 so it will be compatible
Back To Top Back To Excel Index Page (Open Exercise file)
|