Ball State University - Excel 2007 - Windows

Current Students

Faculty and Staff

Alumni

Parents

Business Partners

Directory

Contact Us

A-Z Index

AboutHover

AdmissionsOff

AcademicsOff

CampusLifeOff

AthleticsOff

NewsOff

CalendarOff

GivingOff

Home » About » Administrative Offices » Technology HelpDesk » TechClips: How-to Videos » Create and Manage Documents and Files » Create and Manage Documents and Files - Windows » Excel 2007 - Windows

Getting Started

	Microsoft Excel 2007 Introduction Learn the basics of using Microsoft Excel 2007. Includes and explanation of columns, rows, and cells.
	Excel Office Button Overview Office 2007 programs feature an Office Button on the ribbon. If is a replacement of the File menu item in previous versions of the Office programs. Take a tour of the Excel Office Button and the option you find when you click on it.
	Quick Access Toolbar Easily access common used commands by using the Quick Access Toolbar. Also learn how to customize the Quick Access Toolbar.
	Understanding Column and Row Headings Learn the basics of using Microsoft Excel 2007. Includes and explanation of columns, rows, and cells.
	Saving a Spreadsheet There is more than one way to save an Excel spreadsheet. There are also options that can be selected to save a spreadsheet in different formats.

Formatting Cells and Data

	Format Font, Size and Color Format text in a cell by changing the font, the size, or the color. Learn to apply Bold, Italic, or Underline characteristics to text in a cell.
	Modify the Appearance of Data Using Bold, Italic, and Underline Using Bold, Italic, and Underline features allows you to highlight portions of a spreadsheet.
	Modify the Alignment of Data There is more than one way to change the alignment of text in a single cell or a series of cells.
	Fill a Cell with Color Add visual interest to a spreadsheet by using color to fill cells. This is a great way to draw attention to a particular cell or series of cells.
	Using the Fill Handle Use the Fill Handle to copy formulas and values to other cells. The Fill Handle is a great time saver. Several examples of different ways to use it are explained.
	Format Data in a Cell as a Percentage Excel 2007 offers an easy way to format data as a percentage.
	Remove all Formatting Remove all formatting from cells in an Excel 2007 spreadsheet. The Select All option is explained.
	Merge and Center Center information above a range of cells using the Merge and Center command.

Modifying a Worksheet

	Select Cells, Rows, or Columns Learn how to select a single cell, a series of cells, a complete row or a complete column or cells.
	Modify the Width of Columns There are several ways to modify the width of a column or series of columns.
	Change Row Height Modify the height of a row or series of rows using one of three methods explained in this TechClip.
	Insert Columns and Rows in Excel Insert columns and rows into an existing spreadsheet.
	Set the Page Margins Choose a default margin setting or learn how to customize the size of the margins.
	Modifying Page Breaks Insert a page break and then learn how to modify the page breaks and remove them.
	Insert Headers and Footers Headers and Footers can be used to place the same text at the top (Header) or bottom (Footer) of all the pages in your spreadsheet.
	Using the Undo and Redo Functions The Undo function allows you to undo changes you have made. This allows you to discard changes. You can discard the latest change or several changes at once. After you Undo changes, if you decide you do want those changes made again, you can use the Redo function to get them back.
	Adding ClipArt to a Spreadsheet Insert a piece of Microsoft ClipArt into your spreadsheet and then learn how to move it and resize it.
	Adding WordArt to a Spreadsheet WordArt allows you to insert text that has decorative affects. It is a great way to draw attention to a title or other text that is part of your spreadsheet.

Creating Charts

	Insert a Bar Chart Learn how to create a bar chart with data on an existing worksheet.
	Create a Pie Chart Adding a Pie Chart to a worksheet is easy and is a great way to graphically represent your data.

Working with Multiple Sheets

	Renaming Worksheets and Moving Between Worksheets Manage the sheets that make up your Excel 2007 workbook. You can rename an existing worksheet.
	Insert a New Worksheet By default a workbook has three worksheets. New worksheets can be added.
	Delete an Existing Worksheet Delete a worksheet from an Excel 2007 workbook.
	Change Worksheet Tab Colors Customize a worksheet by changing the color of the tab.

Printing Excel Documents

	Print Preview Use Print Preview to see what an excel document will look like when you print it. This gives you the chance to make changes before actually printing.
	Setting Page Orientation By default an Excel spreadsheet will be set to portrait. It can easily be changed to landscape so that wide spreadsheets can be printed on a page.
	Scale to Fit The Scale to Fit option allows you to force the spreadsheet to print on a set number of pages. Scale to Fit can apply to either the height or width of the document.