Greenwood School District 50

Office of Computing Services

 

Excel for School Secretaries and Other School Staff

August 15, 2007

 

 

  1. Basic Excel

a.       Rows, columns, cells, cell addresses

b.      Values, labels, formulas

c.       Records, fields

 

  1. Acquiring Data

a.       Get data from SDE website

b.      Export data from SASIxp

c.       Export data from TestView

d.      Importing/converting data in Excel

 

  1. Analyzing Data

a.       Sorting

b.      Subtotals

c.       Charts and graphs

d.      Pivot tables

e.       Transposing

  1. Formatting Data

a.       Formatting rows, columns, and other features

b.      Pasting into formatted worksheets

 

  1. Online Resources

a.       Tutorials

b.      Templates

c.       Workshop webpage:  http://www.gwd50.org/XLWork/XLWork.htm