Computer Applications

Online Microsoft Office Training Options

Microsoft Office 2010 is now available to NU faculty and staff at no additional cost. Students can purchase software at a significantly reduced rate. Find out how to obtain Microsoft Office 2010 and other software at http://www.it.northwestern.edu/software. For more information on the Northwestern University Collaboration Services initiative, visit http://www.it.northwestern.edu/strategic-plan/collaboration/index.html.

In addition to Northwestern University’s hands-on computer applications workshops, learn about free, online Pre-Collaboration Training options to get your skills up to speed.

Meet Cynthia Manika, our computer workshop facilitator

HRD106 - Access 2010: Enter/View/Find Data

This workshop is designed for those who need to use an existing database to enter and find data. Please note that this course does not cover how to create a database.

Key Points

• Quick overview of tables, queries, forms, and reports in the Office 2010 Suite environment
• Using existing tables and forms for data entry and to view data
• Open and use existing queries and reports
• Using the Find and Instant Search feature
• Creating Select Queries from scratch and Reports using the Wizard

Workshop Locations	Back to top

HRD116 - Access 2010: Building a Database - Design, Tables, Queries, Forms, and Reports

This two-day workshop is designed for both those who wish to create a database from scratch and to make design changes to an existing database.

Day 1 Objectives

2010 Environment

•  Become comfortable in the new Access 2010 environment of Tabs & Ribbons

Database Design & Relationships

• Define a structured purpose, scope, and objectives for the database
• Learn data-gathering techniques that enable quicker starts, clarify the types if information needed from the database, and help in naming fields, grouping them into tables, and relating tables to each other
• Consolidate data into user friendly critical content areas
• Understand and implement three types of table relationships (one-to-one, one-to-many, and many-to-many) and eliminate weak relationships with a junction table
• Apply normalization tests to evaluate the integrity of the database design

Tables

• Create relationships between tables
• Enforce referential integrity between tables to keep records in related fields valid and accurate; view sub-datasheets to related tables
• Create lookup lists and set different properties of a field in the Design view of a table
• Create an input mask for data entry
• Set validation rules and text for a field

Day 2 Objectives

Queries

• Understand the purpose of various queries
• Create a query from scratch and specify criteria
• Create queries that are based on more than one table and create a calculated field
• Use queries to summarized data from tables

Forms and Reports

• Create forms & reports using the wizards and modify those forms with styles
• Reorganize the form layout by moving fields to change the order in which they appear on the form
• Modify properties to define an object's appearance, behavior, and characteristics
• Customize headers and footers to prepare for printing

Date Time Campus Location NU Employees Non NU Registrants Fee   Fee   4/11 4/12/12 9am - 4pm Chicago Wieboldt, 415 $260 Register Online $375 Register Here 5/15 5/16/12 9am - 4pm Evanston Parkes, 127 $260 Register Online $375 Register Here   Workshop Locations Back to top HRD126 - Access 2010 Advanced This workshop is designed for those who have a strong, functioning database and wish to add some advanced features. Prerequisite: Access 2010: Building a Database. Key Points Create advanced forms and reports Add a calculated field to a report or form Modify data with Action queries Create a Make Table Query Import/Export Data from/to Excel Create single and multi-field parameter queries Use Database Documenter Time allowed for discussion of issues you may have with current database and how to resolve Date Time Campus Location NU Employees Non NU Registrants Fee   Fee   2/14/12 9am - 4pm Evanston Parkes, 127 $145 Registration Closed $215 Registration Closed 3/12/12 9am - 4pm Chicago Wieboldt, 415 $145 Register Online $215 Register Here

Workshop Locations Back to top     HRD205 - Acrobat This workshop provides the knowledge and skills needed to use Adobe Acrobat effectively.  Participants learn how to create, modify, and distribute PDF (Portable Document Format) files and fill-in forms. Feel free to bring a project to work on. Key Points Become familiar in the Acrobat environment by using tools and palettes Page through a PDF document using Acrobat's built-in navigational controls Create and edit links to different areas within a document Create a form for distribution and learn how to collect the results in an Excel file Convert different types of files to PDF Create a new PDF portfolio Date Time Campus Location NU Employees Non NU Registrants Fee   Fee           $145 Registration Closed $215 Registration Closed   Workshop Locations Back to top Dreamweaver Fundamentals Dreamweaver Advanced Dreamweaver Newsletter   HRD21 - Dreamweaver Fundamentals This workshop introduces the fundamentals of creating and maintaining a web page with Macromedia Dreamweaver, a tool requiring no programming knowledge. Participants examine the three main steps in the web publishing process: plan content and design; create a web site; and transfer files to the web. *Special Note: All Dreamweaver classes are held in a Windows lab. However, the concepts are platform independent. Macintosh users are encouraged to sign up so long as they are comfortable working in a Windows environment, or you may bring your own MAC laptop. Key Points Become familiar with basic HTML and Internet concepts Plan and define a site Create, save, edit, and set properties for documents Build a table structure for Text and Image placement Add, delete, format, and import text and images Create basic CSS styles Add hyperlinks, named anchors, and e-mail links to text and graphics Discuss maintaining a site with updates, deletions, and other modifications     Date Time Campus Location NU Employees Non NU Registrants Fee   Fee   3/8/12 9am - 4pm Evanston Parkes, 127 $145 Register online $215 Register here 4/19/12 9am - 4pm Evanston Parkes, 127 $145 Register online $215 Register here Workshop Locations Back to top HRD261 - Dreamweaver Advanced This workshop explores Dreamweaver features that are easy to incorporate into new and existing web pages.  Participants learn to create effective meta tags; use styles to consistently format web pages; create forms with text fields, lists, radio buttons, and check boxes; plus create rollovers to enhance web pages. Prerequisite: Dreamweaver Fundamentals or consent of instructor. Key Points CSS – Cascading Style sheets and understand all 3 types of styles Create Library items Create, use, and edit a page Template Create a rollover images and navigational bars Work with Flash text and Flash button objects Build an HTML form that gathers data from a site visitor (binding to a database is discussed only) Insert multimedia content Insert meta tags to describe the content of a site, making it easier for search engines to find   Date Time Campus Location NU Employees Non NU Registrants Fee   Fee   2/2/12 9am - 4pm Evanston Parkes, 127 $145 Register Online $215 Register here 5/3/12 9am - 4pm Evanston Parkes, 127 $145 Register Online $215 Register here   HRD271 - Dreamweaver: Newsletters This workshop will teach you how to use Dreamweaver to write the HTML needed to create email newsletters.  Learn how to incorporate links and images and how it differs from creating a web page.  Key Points Create pages with tables with layouts Insert images with an absolute reference Insert links Preview in browser Prerequisite: Dreamweaver fundamentals or equivalent skills Date Time Campus Location NU Employees Non NU Registrants Fee   Fee   5/1/12 9am - noon Evanston Parkes, 127 $90 Register Online $125 Register here   Workshop Locations Back to top   Workshop Locations Back to top

Workshop Locations	Back to top

HRD156 - Excel 2010: Beyond the Basics

This full-day workshop is ideal for self-taught users of Microsoft Excel who would like to fill in the gaps in their know-how as well as learn time-saving tips and tricks. Techniques to produce reliable Excel workbooks are covered, including how to display, format, edit existing worksheets and develop new ones plus how to make the most of Excel by creating formulas to analyze data quickly. Prerequisite: Office 2010: Fundamentals or equivalent experience.

Key Points

• Quick tour of the Excel 2010 Environment
• Enter and edit labels, values, and formulas in a worksheet
• Use Autofil to quickly fill in predefined labels and to copy text, numbers and formulas
• Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas
• Understand function syntax and use functions such as SUM, AVERAGE, MIN, MAX, and COUNT to perform calculations in a worksheet
• Format text, numbers, rows, and columns in a worksheet to make them more prominent and easier to read
• Preview, control Page Setup options for, and print worksheets and set and clear a print area
• Try the new SmartArt

	Workshop Locations	Back to top

HRD176 - Excel 2010: Working with Charts and Multiple Worksheets

This workshop provides the techniques needed for mastering Excel's charting capabilities and working with multiple workbooks to illustrate data, relationships, and trends. Participants learn to quickly transform hard-to-read numbers from a table or spreadsheet into professional-looking charts, to update several worksheets at once using 3-D formulas, and to effectively manage large workbooks with multiple worksheets. Prerequisite: Excel 2010 - Beyond the Basics or equivalent skills.

Key Points

• Create different types of charts
• Format charts with themes and styles
• Add titles, gridlines, annotations, and a data table to a chart
• Work with a 3-D chart
• Change viewing options, hide and display data, and print large worksheets
• Insert, delete, rename, move, and copy multiple worksheets
• Summarize data from different worksheets using the Consolidate command
• Use 3-D formulas and external links to perform calculations on data from multiple worksheets and workbooks

	Workshop Locations	Back to top

HRD186 - Excel 2010: Sorting, Filtering, Subtotals and Pivot Tables

This workshop provides the techniques for mastering some of Microsoft Excel's data-management and analysis features. Participants learn to create a list in Excel to keep track of related data. After a list is created, it is easy to find, organize, and analyze its information with Excel's rich set of list-management features. Feel free to bring your own files to practice with.

Prerequisite: Excel 2010- Beyond the Basics or equivalent skills.

Key Points

• Create a structured list to maximize current and future data productivity
• Format as a Table - new list capabilities
• Sort a list using several techniques
• Add subtotals to worksheets without writing any formulas
• Use the AutoFilter to display only the records that meet one's criteria
• Examine the new filtering options for Dates and Numbers
• Create a powerful and flexible custom filter
• Create Pivot tables and Pivot Charts to summarize a data list
• Protect a workbook by enabling a password and locking cells to prevent unauthorized changes

Workshop Locations	Back to top

HRD166 - Excel 2010: Advanced Functions

Participants learn to use Excel's built-in computational and analytical tools to make complex calculations quickly and easily. Learn tips and tricks from the expert to make your spreadsheets efficient in this new 2010 environment.

Prerequisite: Excel 2010- Beyond the Basics or equivalent skills.

Key Points

• Use additional Statistical functions not previously covered
• Use Logical functions
• Nest multiple functions
• Lookup function and naming ranges for pulling in data
• How and when to use Error functions
• Format and calculate date and time functions
• Calculate investments using financial functions
• Concatenate, left, right, middle and other text functions
• Plenty of time to answer your specific questions - Bring your files if desired
• Loads of Tips and Tricks
  

Date	Time	Campus	Location	NU Employees		Non NU Registrants
				Fee		Fee
2/16/12	9pm - 4pm	Evanston	Parkes, 127	$145	Register online	$215	Register here
3/20/12	9pm - 4pm	Chicago	Wieboldt, 415	$145	Register online	$215	Register here
Back to top

HRD157 - Mac Excel 2011: Beyond the Basics This full-day workshop is ideal for self-taught users of Microsoft Excel who would like to fill in the gaps in their know-how as well as learn time-saving tips and tricks. Techniques to produce reliable Excel workbooks are covered, including how to display, format, edit existing worksheets and develop new ones plus how to make the most of Excel by creating formulas to analyze data quickly. Key Points Quick tour of the Excel 2011 Environment Enter and edit labels, values, and formulas in a worksheet Use Auto Fill to quickly fill in predefined labels and to copy text, numbers and formulas Move and copy data, insert and delete ranges, and work with relative and absolute references when creating and copying formulas Understand function syntax and use functions such as SUM, AVERAGE, MIN, MAX, and COUNT to perform calculations in a worksheet Format text, numbers, rows, and columns in a worksheet to make them more prominent and easier to read Preview, control Page Setup options for, and print worksheets and set and clear a print area   Date Time Campus Location NU Employees Non NU Registrants Fee   Fee   3/9/12 9am - 4pm Evanston Parkes, 127 $145 Register online $215 Register here
Workshop Locations	Back to top

HRD177 - Mac Excel 2010: Working with Charts and Multiple Worksheets

This workshop provides the techniques needed for mastering Excel's charting capabilities and working with multiple workbooks to illustrate data, relationships, and trends. Participants learn to quickly transform hard-to-read numbers from a table or spreadsheet into professional-looking charts, to update several worksheets at once using 3-D formulas, and to effectively manage large workbooks with multiple worksheets. Prerequisite: Excel 2010 - Beyond the Basics or equivalent skills.

Key Points

• Create different types of charts
• Format charts with themes and styles
• Add titles, gridlines, annotations, and a data table to a chart
• Work with a 3-D chart
• Change viewing options, hide and display data, and print large worksheets
• Insert, delete, rename, move, and copy multiple worksheets
• Summarize data from different worksheets using the Consolidate command
• Use 3-D formulas and external links to perform calculations on data from multiple worksheets and workbooks

Workshop Locations	Back to top

HRD187 - Mac Excel 2010: Sorting, Filtering, Subtotals and Pivot Tables

This workshop provides the techniques for mastering some of Microsoft Excel's data-management and analysis features in the Mac envirment. Participants learn to create a list in Excel to keep track of related data. After a list is created, it is easy to find, organize, and analyze its information with Excel's rich set of list-management features. Feel free to bring your own files to practice with.

Prerequisite: Excel 2010- Beyond the Basics or equivalent skills.

Key Points

• Create a structured list to maximize current and future data productivity
• Format as a Table - new list capabilities
• Sort a list using several techniques
• Add subtotals to worksheets without writing any formulas
• Use the AutoFilter to display only the records that meet one's criteria
• Examine the new filtering options for Dates and Numbers
• Create a powerful and flexible custom filter
• Create Pivot tables and Pivot Charts to summarize a data list
• Protect a workbook by enabling a password and locking cells to prevent unauthorized changes

Workshop Locations	Back to top

HRD158 - Mac Excel 2010: Advanced Functions

Participants learn to use Excel's built-in computational and analytical tools to make complex calculations quickly and easily. Learn tips and tricks from the expert to make your spreadsheets efficient in this new 2010 environment.

Prerequisite: Excel 2010- Beyond the Basics or equivalent skills.

Key Points

• Use additional Statistical functions not previously covered
• Use Logical functions
• Nest multiple functions
• Lookup function and naming ranges for pulling in data
• How and when to use Error functions
• Format and calculate date and time functions
• Calculate investments using financial functions
• Concatenate, left, right, middle and other text functions
• Plenty of time to answer your specific questions - Bring your files if desired
• Loads of Tips and Tricks
  

Date	Time	Campus	Location	NU Employees		Non NU Registrants
				Fee		Fee
				$145		$215
Back to top

HRD306 - Office 2010 Fundamentals

This workshop is ideal for new users and those who haven’t worked in Microsoft Office on a frequent basis. It covers the basics of Microsoft Office's Word, Excel and PowerPoint applications. Participants learn how to display, format, and edit new and existing Word documents, Excel spreadsheets, and PowerPoint presentations.

Key Points

• Tour of the Office Suite 2010 Environment
• Open, edit, save, and navigate through files in all of these applications
• Use templates to create new documents, workbooks, and presentations
• Add, delete, and format text; change font type, color, and size
• Use the Undo, Redo, and Repeat commands
• Run the Spelling, Grammar, and Thesaurus features
• Find answers quickly using the application’s built-in help function

Workshop Locations	Back to top

HRD341 - Transitioning to Microsoft Office 2010

Learn what's NEW in Word, Excel, and PowerPoint 2010. This class is for experienced Office users wanting to know the difference. Need more basic training or learning at a slower pace? Sign up for Office 2010 Fundamentals. Need to focus on just one program? Ttry the Beyond the Basic level of that application.

Key Points

• Tour of the Office Suite 2010 Environment
• Learn to navigate & customize the new Tabs and Ribbons
• Add your favorite commands to the Quick Access Toolbar
• Learn what will and will not work in "Compatibility Mode"
• Learn what’s been added, changed and removed from these new versions
• Plenty of time to answer your specific questions - bring your files if desired

Back to top

HRD326- Windows Outlook 2010: Email, Calendar, Tasks & OWA

Learn how calendaring works in Outlook! This class covers ALL aspects of Outlook 2010 for Windows - mail, contacts, calendar, and tasks. It is ideal for those who are new to the Outlook environment or wish to use Outlook more effectively. Learn best practices for organizing your time commitments, scheduling meetings with others, and blocking time to accomplish your work thereby reducing stress and work overload. Loads of tips and tricks to help manage your email & calendar more effectively.

Key Points

• Overview of Outlook 2010 environment and preferences
• Manage your e-mail & communications with an efficient system
• Create personal folders and rules to store and organize your mail
• Organize your commitments & activities in your calendar
• Schedule meetings
• Manage contacts with categories
• Use tasks to plan your projects/to-do list
• Learn how to turn on your “Out of Office” message
• Access your email, calendar, tasks and contact lists on the web using OWA (Outlook Web Access)
  
  

Back to top HRD327- Mac Outlook 2011: Email, Calendar, Tasks & OWA Learn how calendaring works in Outlook! This class covers ALL aspects of Outlook 2011 for Mac - mail, contacts, calendar, and tasks. It is ideal for those who are new to the Outlook environment or wish to use Outlook more effectively. Learn best practices for organizing your time commitments, scheduling meetings with others, and blocking time to accomplish your work thereby reducing stress and work overload. Loads of tips and tricks to help manage your email & calendar more effectively. Key Points Overview of Outlook 2011 environment and preferences Manage your e-mail & communications with an efficient system Create personal folders and rules to store and organize your mail Organize your commitments & activities in your calendar Schedule meetings Manage contacts with categories Use tasks to plan your projects/to-do list Learn how to turn on your “Out of Office” message Access your email, calendar, tasks and contact lists on the web using OWA (Outlook Web Access)   Date Time Campus Location NU Employees Fee   2/3/12 9am - 4pm Evanston Parkes, 127 $145 Register online   4/13/12 9am - 4pm Evanston Parkes, 127 $145 Register online       . HRD328 Windows Outlook 2010: Just Calendars & OWA (1/2 day) Learn how calendaring works in Outlook! This class is dedicated for those currently comfortable with emailing in Outlook 2010 but will be migrating from Meeting Making to Outlook for scheduling. Loads of tips and tricks to help manage your calendar more effectively. Key Points •  Organize your commitments & activities in your calendar •  Schedule meetings & rooms •  Access your email, calendar, tasks and contact lists on the web using OWA (Outlook Web Access)   . Date Time Campus Location NU Employees Fee   3/14/12 9am - noon Chicago Wieboldt, 415 $90 Register online   3/22/12 9am - noon Evanston Parkes, 127 $90 Register online   *
Workshop Locations	Back to top

.

HRD329 Mac Outlook 2011: Just Calendars & OWA (1/2 day)

Learn how calendaring works in Outlook! This class is dedicated for those currently comfortable with emailing in Outlook 2010 but will be migrating from Meeting Making to Outlook for scheduling. Loads of tips and tricks to help manage your calendar more effectively.

Key Points

•  Organize your commitments & activities in your calendar
•  Schedule meetings & rooms
•  Access your email, calendar, tasks and contact lists on the web using OWA (Outlook Web Access)

HRD210 - Photoshop

This workshop explains how to use Photoshop to optimize images. Participants work with digital or scanned images and save them as PSDs, JPGs and GIFs - formats that are widely used in printing and web-based environments. Prerequisite: Intermediate computer skills. Feel free to bring your own files to practice with.

Key Points

• Get to know the Photoshop environment by using tools and palettes
• Resize and crop images
• Optimize and adjust the resolution of images based on the output medium, such as Web or print
• Use selection techniques to change specific parts of an image
• Darken, lighten, and clean-up photos
• Work with layers and flatten images
• Create a composite image for image maps or flyers
• Explore the many filter options to give an artistic look to you image
• Create buttons images for rollovers for website design
• .

Workshop Locations	Back to top

HRD356 - PowerPoint 2010 Introduction

This full-day workshop provides the techniques to turn ideas into professional presentations. Learn the foundations and technical aspects of Microsoft PowerPoint to create electronic slideshows.  Feel free to bring your own ideas and images to incorporate in the final class project.

Key Points

• Explore the PowerPoint 2010 Environment
• Learn elements of a good presentation
• Create, edit and save a new presentation
• Manipulate slides- layout, add, move, and delete
• Work in various views: Normal, Slide Sorter, Outline, Notes, and Slide Show
• Format text and backgrounds with the new Slide Designs
• Insert images, create charts, diagrams, SmartArt and tables
• Learn about Slide Masters

Workshop Locations	Back to top

HRD446 - PowerPoint 2010 Advanced

PowerPoint can be used for much more than just to replace “transparencies” for stand-up presentations. This full-day workshop builds upon the lessons learned in the Fundamentals class.  Examples on how best to convey your messages depending on the audience and location, focusing on streamlining information for impact without losing anything important. Plus, learn how to take that presentation/course and create handouts for students and a manual for the presenter/instructor. Feel free to bring your own ideas and images to incorporate in the final class project.

Prerequisite: PowerPoint 2010 Fundamentals or equivalent skills.

Key Points

• What makes a GREAT stand-up presentation
• Build a presentation in Wide-Screen format with Hi-Resolution
• Custom Animation with Motion paths
• Edit existing and create new Slide Masters
• Using PowerPoint on a stand-alone kiosk or to create a course for the classroom
• Use Multiple Masters for a long presentation or course
• Create custom layouts and templates to use in the future with your customs Theme
• Create different handout types and instructor's coordinating manual
• Insert Multimedia and learn the pitfalls when transferring to another computer
• Compact your presentation to take on the road or give to others
• Loads of Tips and Tricks

HRD357 - Mac PowerPoint 2011: Introduction This full-day workshop provides the techniques to turn ideas into professional presentations. Learn the foundations and technical aspects of Microsoft PowerPoint to create electronic slideshows.  Feel free to bring your own ideas and images to incorporate in the final class project. Key Points Explore the PowerPoint 2011 Environment Learn elements of a good presentation Create, edit and save a new presentation Manipulate slides- layout, add, move, and delete Work in various views: Normal, Slide Sorter, Outline, Notes, and Slide Show Format text and backgrounds with the new Slide Designs Insert images, create charts, diagrams, SmartArt and tables Learn about Slide Masters Date Time Campus Location NU Employees Non NU Registrants Fee   Fee   5/4/12 9am - 4pm Evanston Parkes, 127 $170 Register Online $255 Register Here
Workshop Locations	Back to top

HRD358 - Mac PowerPoint 2010 Advanced

PowerPoint can be used for much more than just to replace “transparencies” for stand-up presentations. This full-day workshop builds upon the lessons learned in the Fundamentals class.  Examples on how best to convey your messages depending on the audience and location, focusing on streamlining information for impact without losing anything important. Plus, learn how to take that presentation/course and create handouts for students and a manual for the presenter/instructor. Feel free to bring your own ideas and images to incorporate in the final class project.

Prerequisite: PowerPoint 2010 Fundamentals or equivalent skills.

Key Points

• What makes a GREAT stand-up presentation
• Build a presentation in Wide-Screen format with Hi-Resolution
• Custom Animation with Motion paths
• Edit existing and create new Slide Masters
• Using PowerPoint on a stand-alone kiosk or to create a course for the classroom
• Use Multiple Masters for a long presentation or course
• Create custom layouts and templates to use in the future with your customs Theme
• Create different handout types and instructor's coordinating manual
• Insert Multimedia and learn the pitfalls when transferring to another computer
• Compact your presentation to take on the road or give to others
• Loads of Tips and Tricks

HRD336 - Project 2010

This workshop is designed to help project managers coordinate a variety of tasks that need to be completed within a time frame and a set amount of resources. It can help keep track of all of the project details, resources, and costs so that project goals are met.

Pre-requisite:  Project Management Essentials or Foundations of Project Management (SCS).

Key Points

• Create project schedule, calendar and custom reports
• Create and assign resources
• Outline tasks and link dependencies between tasks
• Update project plan data with others

Pre-requisite:  Project Management Essentials or Foundations of Project Management (SCS).
Workshop Locations	Back to top

HRD221 - Publisher 2010

In this course you will learn the core features and functions of Publisher 2010. You will learn how to create and edit publications, arrange text and graphics, work with master pages, and create and format tables. You will also learn how to flow text across text boxes, create a facing-pages layout, and prepare publications for printing. Feel free to bring a project to work on in class.

Key Points

• Explore the publication templates available
• Navigate in a Publisher publication document and explore the Publisher environment
• Create a Flyer and understand object positioning
• Create a multipage booklet
• Working with text boxes and text box linking
• Inserting graphics then resize, rotate, align and wrap text options
• Create and format basic tables
• Stacking and grouping objects
• Master pages and guides
• Saving & printing your publication

Workshop Locations	Back to top

HRD231 - Visio 2010

In this course you will learn the fundamentals of working with the most common applications of Visio 2010. You will create five types of diagrams: a direction map, workflow chart, cross-functional flowchart, an organization chart and a floor plan. By using multitudes of templates and stencils, you will get a broad understand of creating graphics or drawing in this powerful, yet user-friendly application. Feel free to bring a project to work on in class.

Key Points

• Explore the various templates available for creating a Visio document
• Navigate in a Visio document and explore the Visio environment
• Drag shapes from Visio stencils, then resize, rotate, align and transform them
• Create a direction map
• Create a flowchart & cross-functions flowchart
• Create an organization chart
• Create an office floor plan to scale
• Saving & printing your drawings

Workshop Locations	Back to top

.

HRD406 - Word 2010: Beyond the Basics

A complete guided tour of Microsoft Word's best features, this workshop is ideal for self-taught Word users who would like to hone their skills and improve their efficiency. It covers how to display, format, and edit existing documents and create new ones. Participants learn all the techniques necessary to produce professional-looking word processing documents. Prerequisite: Office 2010: Fundamentals or equivalent experience.

Key Points

• Tour of the Word 2010 Environment
• Lots of tips and tricks to make working in Word fast and efficient
• Add, delete, and format text in documents
• Use the Undo, Redo, and Repeat commands
• Change font type, color, and size; copy formats with the Format Painter
• Create bulleted and numbered lists
• Create and format Word tables
• Adjust margins and tabs and control where a page breaks
• Add page numbering to documents
• Add borders to tables, paragraphs and pages
• Align and indent text in paragraphs and adjust paragraph spacing
• Use Word styles and built-in templates

Workshop Locations	Back to top

HRD316 - Word 2010: Mail Merge

This workshop provides the techniques to master one of Microsoft Office's greatest features for automating routine and time-consuming tasks. Participants learn step by step to use Word's Mail Merge feature in conjunction with data sources such as Microsoft Excel and Access files to create letters, envelopes, and labels for mass mailings. Feel free to bring your own files to practice with.

Prerequisite: Word 2010 - Beyond the Basics or equivalent skills.

.

Key Points

• Create form letters, labels, envelopes and lists
• Discuss broadcast emails using Outlook contacts as your data source
• Attach different data sources, such as Excel, Access and Word tables
• Understand how different data sources required a different method of inserting the field placeholders
• Edit a data source
• Preview and merge documents

Date	Time	Campus	Location	NU Employees		Non NU Registrants
				Fee		Fee
2/6/12	9am - noon	Chicago	Wieboldt, 415	$90	Registration Closed	$125	Registration Closed
3/22/12	1pm - 4pm	Evanston	Parkes, 127	$90	Register Online	$125	Register Here
Workshop Locations Back to top

HRD416 - Word 2010: Advanced

This advanced-level workshop is for those who work with long reports, lengthy research papers, and documents requiring multiple revisions. Feel free to bring your own files to practice with.

Prerequisites: Word 2010- Beyond the Basics or equivalent skills.

.

Key points

• Learn Quick Styles and Themes for quick and consistent formatting
• Learn to use the Outline Mode in Word
• Mark words for a Table of Contents and Index, then generate both
• Add Footnotes and Endnotes that automatically renumber with changes
• Add Bookmarks and Hyperlinks to be able to jump to locations quickly
• Insert sections breaks, change document settings such as orientation and different odd/even page numbering
• Track changes with Word's built-in reviewing tools
• Insert, edit, print, and delete reviewer comments and use the Highlight tool to mark text
• Plenty of time to answer your specific questions - Bring your files if desired
  

Date	Time	Campus	Location	NU Employees		Non NU Registrants
				Fee		Fee
2/6/12	1pm - 4pm	Chicago	Wieboldt, 415	$90	Registration Closed	$125	Registration Closed
Back to top

HRD407 - Mac Word 2011: Beyond the Basics A complete guided tour of Microsoft Word's best features, this workshop is ideal for self-taught Word users who would like to hone their skills and improve their efficiency. It covers how to display, format, and edit existing documents and create new ones. Participants learn all the techniques necessary to produce professional-looking word processing documents. Key Points Tour of the Word 2011 Environment Lots of tips and tricks to make working in Word fast and efficient Add, delete, and format text in documents Use the Undo, Redo, and Repeat commands Change font type, color, and size; copy formats with the Format Painter Create bulleted and numbered lists Create and format Word tables Adjust margins and tabs and control where a page breaks Add page numbering to documents Add borders to tables, paragraphs and pages Align and indent text in paragraphs and adjust paragraph spacing Use Word styles and built-in templates Date Time Campus Location NU Employees Non NU Registrants Fee   Fee   4/30/12 9am - 4pm Evanston Parkes, 127 $145 Register Online $215 Register Here   Workshop Locations Back to top   HRD408 - Mac Word 2011: Advanced This advanced-level workshop is for those who work with long reports, lengthy research papers, and documents requiring multiple revisions. Feel free to bring your own files to practice with. Prerequisites: Word 2011- Beyond the Basics or equivalent skills. . Key points Learn Quick Styles and Themes for quick and consistent formatting Learn to use the Outline Mode in Word Mark words for a Table of Contents and Index, then generate both Add Footnotes and Endnotes that automatically renumber with changes Add Bookmarks and Hyperlinks to be able to jump to locations quickly Insert sections breaks, change document settings such as orientation and different odd/even page numbering Track changes with Word's built-in reviewing tools Insert, edit, print, and delete reviewer comments and use the Highlight tool to mark text Plenty of time to answer your specific questions - Bring your files if desired Date Time Campus Location NU Employees Non NU Registrants Fee   Fee           $145 $215 Back to top

HRD426 - Integrating Word, Excel & PowerPoint

This workshop is designed for Office Power Users that need to harness the power of using the Office Applications together - whether it is to link an Excel Chart in PowerPoint or Word; bring a PowerPoint Presentation in Word and format for an instructor/speaker manual; or bring in items built in any other applications.

Prerequisites: Word/Excel and PowerPoint 2010 -Beyond the Basics or equivalent skills

Key points

• Link between Office applications
• Publish a presentation to Word and format for an instructor/speaker or student manual
• Hyperlink to files associated with other applications
• Hyperlink to websites or start an email message
• Bring Visio and Photoshop objects into PowerPoint or Word
• Bring all of the pieces together for a master document
  

Workshop Locations	Back to top

HRD208 - InDesign CS5

This course will explore the core features and functions of InDesign CS5. You will learn how to create and edit different types of publications, arrange text and graphics, work with master pages. You will also learn how to flow text across text boxes, create a facing-pages layout, and prepare publications for printing. Feel free to bring a project to work on in class.

Proficient level of computer skills required

.

Key Points

•  Explore the InDesign environment
•  Create a Flyer and understand object positioning
•  Create a multipage booklet
•  Explore and use templates that come with InDesign
•  Work with text boxes and text box linking
•  Insert graphics then resize, rotate, align and wrap text options
•  Stack and group objects
•  Master pages and guides
•  Save& print setting for your publication

Workshop Locations	Back to top

HRD215 - Illustrator CS5

This course explores the core features and functions of Illustrator CS5. You will learn how to create and edit different types of graphics elements to print or export for use in other applications. Feel free to bring a project idea to work towards in class.

Proficient level of computer skills required

.

Key Points

•  Explore the Illustrator environment and customize your workspace
•  Use the pencil and shape tools with formatting options
•  Use the pen tool and path options
•  Add, format and edit text
•  Explore stroke and fill options
•  Create a logo
•  Learn about layers and grouping objects
•  Save and exportoptions to use in other types of applications
•  Create an ad
•  Get your ad ready for printing

Workshop Locations	Back to top

HRD2218 - OneNote

Microsoft OneNote 2010 gives you the ideal place to store and share your information in a single, easy-to-access location. Learn how to organize all your notes about a project in one easy to search notebook.

Key Points

•  Creating, Navigating, and Saving in OneNote
•  Adding a Section and Pages
•  Creating Text Notes & Tables
•  Sending to OneNote
•  Searching in OneNote
•  Turning Synchronization On/Manual Synchronization
•  Docking OneNote (Taking Linked Notes
   

Workshop Locations	Back to top

One-on-one & Group Coaching

One-on-one and group coaching sessions are available. One-on-one sessions are conducted at our lab or at the participant's desk, around his or her schedule, and focus on how to work successfully on his or her own projects. To schedule one-on-one coaching or to inquire about customized group coaching and fees, please contact us at 847-467-5081 or training@northwestern.edu. We provide coaching for the following:

• Dreamweaver, Photoshop and InDesign
• Microsoft Access, Excel, Outlook, Power Point, Publisher, Word and Visio
• Basic computing skills for Windows and Macintosh
• Database design and web site design

Back to top