Microsoft Excel - Self Help Documents - Office of Technology Services

skip to section links

Skip to page content

TU Home
About TU
Administration & Finance Division
OTS
OTS Training

Workshops

Self-Help Documents & Movie Tutorials

Information Security & Viruses

Survey Forms

Copyright Information

Staff

OFFICE OF TECHNOLOGY SERVICES

Training & Documentation

Self Help Documents: Microsoft Excel

OTS is pleased to offer the following PDF publications and Flash movie tutorialsas 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 2007
	Macros A macro is a recorded series of instructions stored in a software program. When a user would like to recall these instructions they do so by "running" the macro. In Microsoft Office and Excel in particular, macros are used to help execute tedious day to day tasks, simplifying the end user experience.
	Advanced Macros In this self help document, you will learn how to add a macro to a icon, to assign a shortcut key to run a macro, to use relative referencing when recording a macro, deleting a macro, and saving a macro to the Personal Macro workbook.
	Editing Macros In this self help document, you will be introduced to the Visual Basic for Applications editor and learn how to make some basic modifications to an existing macro.
	Converting Columns to Rows using Paste Special Data that needs to be manipulated from rows into columns can be easily transposed using the Paste Special command. In this self help document, you will learn how to take a column of text and convert it into a row or vice versa.
	Creating a Pivot Table from Scratch, Excel 2007 In this self help document, you will learn how to manipulate data effectively using a Pivot Table.
	Creating a Pivot Chart, Excel 2007 Learn how to convert a Pivot Table into a Pivot Chart to display and manipulate data graphically.
	PivotTable Advanced Features, Excel 2007 Understand how to take advantage of the powerful advanced features that PivotTables has to offer in this self help document.
	Concatenation, Excel 2007 Learn how to join text strings together so as to simplify database entry.
	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.

Administration and Finance Questions