MICROSOFT OFFICE WORKSHOPS

Registration: email Diane Smith-Wilks (dwilks).

If you have any questions or topics you would like covered in the workshop, please fee free to include that information in the email.

Click on the workshop title to view/print handout.

 

Workshop	Description	Date	Time	Location
Word Forms 2007	Create a form in Word that can be used to collect information from other users. Add text boxes and drop down lists to your form. Lock the form so only certain sections can be changed.	11/5/09	9:30 - 10:30	Accinno 202
Securing Your PC Securing Your PC slideshow	Learn about essential security practices and disk maintenance. Check options for McAfee VirusScan and critical Windows updates. Learn about spyware utilities.	11/12/09	9:30 - 10:30	Accinno 202
Publisher 2007	Create a newsletter using Publisher. Learn to add and reposition text and graphics. Customize your work using Publisher designs and layouts.	11/20/09	9:30 - 11:00	Accinno 116
The following is a list of additional workshops. Feel free to request as needed. Click on the title to view/print the handout.
Word Merge 2007	Create mail merge letters & labels using data from Excel and Word. Create an email merge using email addresses from Excel and Outlook contacts.
Excel I 2007	Work with the new user interface in Excel 2007. Check out the new changes with tables, filtering, formulas, and graphics. Use common functions that now have a new look and location.
Excel II 2007	Work with various formulas, subtotals, pivot tables, conditional formatting, linking and graphs.
Excel Charts 2007	Work with the chart tools options including design, layout and format to visually define your data. Improve the clarity of your graphs using plot area options and rotations.
Excel: Shortcuts & Formulas	Learn many new shortcuts including moving & inserting columns, adjusting columns and using the fill series.  Use formulas containing relative and absolute referencing, text, conditional functions and lookup.
PowerPoint 2007	Convert your old bullet point slides to new slides containing SmartArt. Use the new options for graphics and shapes. Add themes and animations for a high quality presentation.
Word I 2007	Work with the new user interface in Word 2007. Learn about the new file format. Try out new features including Themes, SmartArt and Galleries. Find out about interactive guides and on-ine training. Great for those who have just made the switch from 2003 to 2007 or for those who planning to upgrade.
Word II 2007	Learn how to add different types of headers & footers in the same document. Set up one document containing both portrait & landscape pages. Create a table of contents. Use footnotes & endnotes.
Document Collaboration / Track Changes	Use reviewing tools in Word to create and update documents needed for team collaboration. Use the track change function to automatically track any additions or changes to the document, add comments and distribute the document for review.
Access I 2007- Tables & Forms	Learn new ways to navigate in Access. Use templates to easily create tables. Create and modify a form using form tools. Work with new options to manage database objects.
Access II 2007- Queries & Reports	Create queries using the wizard and design view. Export your query results to Excel. Create and edit reports using the wizard.
Resource 25	Use Resource 25 (internal campus calendar) Web Viewer to view space availability and campus events by dates and locations. Learn how to use the online request form to request space for special events and view the status of your request.