OTS is pleased to offer the following PDF publications and Flash movie tutorials as
self-help technology resources for the Towson University community. (For other non-profit use please refer to our copyright information.) To open a publication or play a movie tutorial, click on its title. If your browser does not properly display the publication, you may need to install a free copy of Adobe Reader. If your browser does not properly display the movie, you may need to install a free copy of Adobe Flash Player. To search this page for a specific word or phrase, press Ctrl-F.
|
 |
Excel 2003 Resources Available Here |
 |
Basics, Excel 2007
Introduces the essential skills for creating basic and design effective spreadsheets, including entering and formatting data, changing column widths and row heights, saving, printing and more . |
|
New Features, Excel 2007
Describes new Excel features including the Ribbon, Office button and Quick Access Toolbar; changes in file sizes and extensions; keyboard shortcuts; common operations; and how to work with files from other versions of Excel. |
|
Operators in Calculations, Excel 2007
Operators are a special symbols that represents a mathematical operation within a formula (or Excel function). This document shows the supported operators in Microsoft Excel. |
|
Basic Terminology , Excel 2007
This document lists the more commonly used Excel terms and is designed to serve as a reference for you as you work in Microsoft Excel. |
|
Relative and Absolute References, Excel 2007
Cell references are an important part of creating formulas in Excel. This document discusses the difference between Relative and Absolute cell referencing and when it is appropriate to use one over the other. |
|
Creating a Column Chart, Excel 2007
Describes how to create, format and modify a column chart within Excel 2007. |
|
Creating a Pie Chart, Excel 2007
Describes how to create, format and modify a pie chart within Excel 2007 |
|
Printing Basics, Excel 2007
This document describes some of the more helpful printing options and techniques for changing your page setup. You can print the active worksheet, the entire workbook or just part of a worksheet. |
|
Importing an External Data File, Excel 2007
This document describes how to use Excel's many analytical tools and features to view, process and analyze data. |
|
Working with Columns and Rows, Excel 2007
This document describes how to adjust columns and rows to achieve a desired look. |
|
Advanced Calculations, Excel 2007
Learn how to use some of Excel's built in Functions to perform advanced calculations. |
|
Sorting Data, Excel 2007
This document describes how to sort data within Excel 2007 including how to sort ascending or decending, by a custom list, by color and by multiple criteria. |
|
Adding Leading Zeros, Excel 2007
This document describes how to format columns or selected text so a numeric string has a preceeding zero. |
|
Using Find and Replace, Excel 2007
This document will show you how to replace a specific value in an Excel spreadsheet in multiple places. This will be particularly useful since the student email address has changed to a different format. Using this method, the spreadsheet can be updated quickly and accurately. |
|
Filtering Data, Excel 2007
Learn how to create a subset of data by creating a filter. Use autofilter, clear filters, create an autofilter using criteria and filter data using cell attributes. |
|
Subtotaling Data, Excel 2007
Learn to summarize a list by inserting subtotals. |
|
  Merge and Center, Excel 2007
This movie tutorial will show you how to use the merge and center feature in Excel 2007. |
|
Shortcuts, Tips and Tricks, Excel 2007
Learn shortcuts, tips and tricks to help maximize your productivity while reducing your time and effort with Excel 2007. |
| |
|
