Excel 2007

An overview of Excel 2007

The Excel Interactive Guide allows the user to demonstrate a task in Excel 2003. Then the resource will demonstrate the same task in Excel 2007. To begin click "Start the guide". To go to the next demonstration click on the grayed Excel 2003 tab.

To see what's new in Excel 2007: Conditional formatting, advanced visuals and the new user interface.

Links to Tutorials:
Basics
Charts
Filtering & Sorting Data
Formatting
Formulas & Macros
Importing & Exporting Data
PDF
Templates
Websites

Basics

• Create a new workbook

• Change the default file format for saving workbooks

• Automatically save a backup copy of a workbook

• Close workbooks or workbook windows

• Naming files and attachments

• Open a file

• Save a file

• Copy a file

• Rename a file

• Move a file

• Delete a file

• Organize quick file access by using the My Places bar

• Select multiple files

• Enter data manually

• Edit cell contents

• Move the cursor after entering data

• Turn automatic completion of cell entries on or off

• Undo, redo, or repeat an action

• Fill data automatically in worksheet cells

• Insert or delete cells, rows, and columns

• Turn the Insert Options button on or off

• Turn the option to edit directly in cells on or off

• Select cells, ranges, rows, or columns on a worksheet   

• Select specific cells or ranges

• Select all cells on a worksheet

• Select one or multiple worksheets

• Move or scroll through a worksheet

• Find and select cells that meet specific conditions

• Hide or display scroll bars in a workbook

• Move or copy cells and cell contents

• Move or copy rows and columns

• Move or copy a worksheet  

• Insert or delete a worksheet

• Move or copy a worksheet

• Freeze or lock rows and columns

• Change the number of worksheets in a new workbook

• Hide or display rows and columns

• Freeze or unfreeze rows and columns

• Hide or unhide rows and columns

• Insert and delete rows, columns, and worksheets

• Place your favorite commands on the Quick Access Toolbar

Charts

• Overview of charting

• Create charts in Excel 2007

• Available chart types

• Create charts in Excel

• Create a chart

• Change the chart type of an existing chart

• Copy a chart

• Timesaving techniques for adding or editing chart data in Excel 2007

• Create, apply, or remove a chart template

• Display hidden data and empty cells in a chart

• Plot data series from worksheet rows or columns

• Present your data in an area chart

• Present your data in a bar chart

• Present your data in a bubble chart

• Present your data in a column chart

• Present your data in a combination chart

• Present your data in a doughnut chart

• Present your data in a Gantt chart in Excel

• Present your data in a histogram

• Present your data in a pie chart

• Present your data in a radar chart

• Present your data in a scatter chart or a line chart

• Present your data in a stock chart

• Present your data in a surface chart

• Use a picture in a chart

• Change the layout or style of a chart

• Print a chart

• Select chart elements

• Format chart elements

• Change the display of chart axes

• Change data markers in a line, xy (scatter), or radar chart

• Change the scale of the depth (series) axis in a chart

• Change the plotting order of categories, values, or data series

• Change the scale of the horizontal (category) axis in a chart

• Change the scale of the vertical (value) axis in a chart

• Change the shape fill, outline, or effects of chart elements

• Change the display of a 3-D chart

• Add or remove a secondary axis in a chart

• Align or rotate a chart or axis title

• Display or hide chart gridlines

• Display dates on a category axis

• Show or hide a chart legend or data table

• Display or hide data label leader lines in a pie chart

• Use titles on a chart

• Vary colors in the same data series

• Add or remove data labels in a chart

• Modify chart legend entries

• Edit titles or data labels in a chart

• Add a text box to a chart

• Add drawing objects to Excel 2007 charts

• Add or remove series lines, drop lines, high-low lines, or up-down bars in a chart

• Demo: Organize your data by using an Excel table

Filtering & Sorting Data

• Filter data in a range or table

• Filter for unique values or remove duplicate values

• Filter by using advanced criteria

• Reapply a filter and sort, or clear a filter

• Sorting with Excel 2007

• Default sort orders

• Sort data in a range or table

• Guidelines and examples for sorting and filtering data by color

• Add, change, or clear conditional formats

• Conditionally formatted data: Examples and guidelines

• Find cells that have conditional formats

• Manage conditional formatting rule precedence

• Wildcard characters

• Create flexible, effective conditional formats

• Create Conditional Format Functions

• Create or delete a custom list for sorting and filling data

Formatting

• Wrap text in a cell

• Combine the contents of multiple cells

• Merge cells or split merged cells

• Distribute the contents of a cell into adjacent columns

• Merge a range of cells into a single cell

• Combine the contents of multiple cells into 1 cell

• Distribute the contents of 1 cell across multiple cells

• Insert bullets in a worksheet

• Hide or display cell values

• Change the column width and row height

• Annotate a worksheet by using comments

• Display cell contents in a shape or text box

• Available number formats

• Insert a symbol, fraction, or special character

• Insert symbols and special characters on a worksheet

• Type ¢, £, ¥, ®, and other characters not on the keyboard

• Convert numbers stored as text to numbers

• How to handle leading zeros and precision in number codes

• Reset a number to the General format

• Create or delete a custom number format

• Convert dates stored as text to dates

• Change the character used to separate thousands or decimals

• Change the way negative numbers are displayed

• Display numbers as percentages

• Change the decimal places displayed for numbers

• Display numbers as phone numbers

• Display numbers as fractions

• Display numbers as Social Security numbers

• Display numbers as postal codes

• Display numbers as credit card numbers

• Display numbers as currency

• Display numbers as dates or times

• Show or hide the thousands separator

• Set rounding precision

• Change the font or font size in Excel

• Change the default font in Excel

• Change the color of gridlines in a worksheet

• Data and conditional formatting

• SmartArt graphics

• Adjust page breaks to control what is printed on each page

• Transpose data in Excel 2007

• Clear cells of contents or formats

Formulas & Macros

• Create formulas with Formula AutoComplete

• Use simple formulas to do the math

• Automatically number rows

• Create a list of sequential dates

• Display or hide the fill handle

• Fill data by using a custom fill series

• Enable blocked macros

Importing & Exporting Data

• Exchange (copy, import, export) data between Excel and Access

• Import or export text files

• Text Import Wizard

PDF

• Make changes to a PDF file

• Save a file in PDF format

Templates

• Why do you check to see if my software is genuine when I download a template?

• Create and use an Excel template

• Excel calendar templates

Websites

• Save all or part of a workbook to a static Web page

• Create or remove a hyperlink

• Copy or move a hyperlink

• Change a hyperlink

• Select a hyperlink without activating the link

• Get external data from a Web page

Microsoft Office Online: Help and How To

Office 2007: User step-by-step manuals from Information Technology

Quick Reference Guides for all Office 2007 programs are available from Custom Guide