When you create an X-Y scatter plot in Excel 2007, the default setting will create a chart with axes that end with the largest data points. If you need to extrapolate further data points, you will need to expand the axes of your existing chart.
To add the Anova Data Analysis function to Excel 2007, start by opening Excel and clicking on the Office button at the top left of the screen. At the bottom of the drop down menu, click on the’ Excel Options’ button.The Excel Options window will open. In the column on the left, click on the Add-Ins heading. On the right side of the window, scroll down to Inactive Application Add-Ins and click on ‘Analysis ToolPak’ to select it. Then click the Go Button.An ‘Add-Ins’ window will open. Click in the checkbox next to ‘Analysis ToolPak’ and click the OK button. Another window may open that says Excel can’t run the add-in until you install the feature. Click Yes.The Microsoft Office Configuration window will launch. This can take a minute or two to configure. When it is finished, click on the Data tab and the Anova Data Analysis function will appear in the Analysis group on the right side of the ribbon.
<
For more text tutorials, visit the Technology Training Center website at http://library.cortland.edu/ttc/materials.asp .
If you need more information, please contact:
Tera Doty-Blance
Software Training and Support Specialist
Memorial Library B113
(607)753-4056
dotyblancet@cortland.edu
http://library.cortland.edu/ttc/training_center.asp
Below you will find links to many more useful text based (with screen shots) tutorials on Microsoft Excel 2007 from the University of Wisconsin-Eau Claire
Working with Excel
Printing with Excel
Special Features
Working with Tables (database functions)
Managing Your Excel Worksheet
Charting with Excel
Favorite Excel Functions
Automating Excel with MacrosInserting Clip Art
The following tutorials from Florida Gulf Coast University contain screen shots with step by step instructions.
Microsoft Word 2007 – http://www.fgcu.edu/support/office2007/Word/index.asp
Getting Started
Working With Documents
Customize the Word Environment
Editing a Document
Formatting Text
Formatting Paragraphs
Styles
Adding Tables
Graphics
Proofing a Document
Page Formatting
Macros
Table of Contents
Creating Web Pages
Lists
References and Citations
Track Changes
Microsoft PowerPoint 2007 – http://www.fgcu.edu/support/office2007/ppt/index.asp
Getting Started
Customize
Creating a Presentation
Working with Content
Formatting Text
Adding Content ( Bulleted and Numbered Lists, Nested Lists, Formatting Lists, Adding Video, Adding Audio)
Graphics
Tables
Charts
Slide Effects
PrintingTips
Microsoft Excel 2007 – http://www.fgcu.edu/support/office2007/Excel/index.asp
Getting Started
Customize Excel
Working with a Workbook
Manipulating Data
Modifying a Worksheet
Performing Calculations
Macros
Sort and Filter
Graphics
Charts
Formatting a Worksheet
Developing a Workbook
Page Properties and Printing
Customize the Layout
Microsoft has created many self paced online tutorials for both the Office 2007 and Office 2003 application suites. These are text based tutorials that include images with an audio narration, and are categorize by application and function. The tutorials can be viewed at http://office.microsoft.com/en-us/training/FX100565001033.aspx .
The Office 2007 rollout has begun! With the new Office suite, comes new file formats which result in backwards compatability issues with previous versions of Word, Excel, and PowerPoint. Fortunately, there is a free tool from Microsoft that will allow previous versions of these programs to open, edit, save and create files using these new formats.For more information, and a link to download the compatibility pack, visit Microsoft’s website at http://office.microsoft.com/en-us/products/HA101686761033.aspx�
