Providence College
     Information Technology – Training

 

Administrative Services

Help Desk

Information Security

Network Services

Telecommunications

Training

 

 

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

 

 

Create a newsletter using Publisher. Learn to add and reposition text and graphics. Customize your work using Publisher designs and layouts.

3/4/2010

9:30 - 10:45
Accinno 202

 

 

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.

3/9/2010

9:30 - 10:30
Accinno 202

 

 

Learn how the new features can help you get more organized. View mail, calendar and tasks all on one screen using the To-Do Bar. Use the new options for calendar sharing and viewing. A key focus will be on calendar and task management.

3/11/2010

2:00 - 3:30
Accinno 207

 

 

Work with various formulas, subtotals, pivot tables, conditional formatting, linking and graphs.

3/16/2010

9:30 - 11:00
Accinno 202
The following is a list of additional workshops. Feel free to request as needed. Click on the title to view/print the handout.

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.

Create mail merge letters & labels using data from Excel and Word. Create an email merge using email addresses from Excel and Outlook contacts.
Excel Pivot Tables 2007
 Do you have rows and rows of data to analyze?  Do you spend time sorting your data then generating totals by group?  Learn to use pivot tables to quickly get a summary view of your data including calculations and filters.
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.

Work with various formulas, subtotals, pivot tables, conditional formatting, linking and graphs.

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.
Learn many new shortcuts including moving & inserting columns, adjusting columns and using the fill series.  Use formulas for mathematical calculations as well as manipulating text.

Learn to create and manage your lists using Excel. Set up your data as a table and filter data based on criteria. Summarize your data by using subtotals and a pivot table.
Learn how the new features can help you get more organized. View mail, calendar and tasks all on one screen using the To-Do Bar. Use the new options for calendar sharing and viewing. A key focus will be on calendar and task management.

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.

 

 

 

Create a newsletter using Publisher. Learn to add and reposition text and graphics. Customize your work using Publisher designs and layouts.

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.

 

Learn about essential security practices and disk maintenance. Check options for McAfee VirusScan and critical Windows updates. Learn about spyware utilities.

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.

Create queries using the wizard and design view. Export your query results to Excel. Create and edit reports using the wizard.
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.