Computer Applications

Whether it's for e-mail, organizing meetings or updating spreadsheets, Northwestern employees are almost always near a computer. Keep up-to-date with the latest software and tips for mastering your machine by attending the following workshops.  

Meet Cynthia Manika, our computer workshop facilitator PDF Document. In addition to the hands-on workshops, Cynthia is available for individual and custom group coaching. To learn more, please contact Learning & Organization Development at 847-467-5081 or workplace-learning@northwestern.edu.

Did you know that all Northwestern staff, faculty, and students have unlimited, 24/7 access to online training for most major software and computer application topics through lynda.com at no additlogo of lynda.comional cost? Go to Northwestern’s lynda.com log in page to get started and set up your account with your NetID and NetID password. Learn more about Northwestern's partnership with lynda.com.

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

HRD116- Access 2010: Building a Database

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

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 or equivalent experience/skills. If you have not completed Access 2010: Building a Database, please contact the Learning & Organization Development team to verify equivalent experience/skills.

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

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

HRD252- Dreamweaver

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. Mac users are encouraged to sign up as long as they are comfortable working in a Windows environment or would like to bring their 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

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.

Prerequisite: HRD252: Dreamweaver or equivalent experience/skills. If you have not completed HRD252: Dreamweaver, please contact the Learning & Organization Development team to verify equivalent experience/skills.

Key Points

  • Create pages with tables with layouts
  • Insert images with an absolute reference
  • Insert links
  • Preview in browser

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: HRD252: Dreamweaver or equivalent experience/skills. If you have not completed HRD252: Dreamweaver, please contact the Learning & Organization Development team to verify equivalent experience/skills.

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

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. 

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

HRD186- Excel 2010: Sorting, Filtering, Subtotals, 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.

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

HRD176- Excel 2010: Charts and Dashboards

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 experience/skills. If you have not completed Excel 2010: Beyond the Basics, please contact the Learning & Organization Development team to verify equivalent experience/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

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 the 2010 environment.

Prerequisite: Excel 2010: Beyond the Basics or equivalent experience/skills. If you have not completed Excel 2010: Beyond the Basics, please contact the Learning & Organization Development team to verify equivalent experience/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

HRD215- Illustrator

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

HRD208- InDesign

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.

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

HRD209- InDesign: Advanced

This course will explore advanced features and functions of InDesign CS5 and pick up where the basic InDesign workshop ended. You will learn how to work with large publications, involving multiple masters, page numbering, and table of contents. We will work with a 4-page newsletter project and a book project during class. Feel free to bring a project or text files to work with in class.

Prerequisite: HRD208: InDesign or equivalent experience/skills. If you have not completed HRD208: InDesign, please contact the Learning & Organization Development team to verify equivalent experience/skills.

Key Points

  • Create a large document
  • Work with multiple masters
  • Character and paragraph styles
  • Explore text frame options
  • Thread text frames with “continued” from and to page numbers
  • Working with tables
  • Page numbering and page number options
  • Generate a table of contents
  • Assemble a book

Prerequisite: <name of class here> or equivalent experience/skills. If you have not completed <insert name of class>, please contact the Learning & Organization Development team to verify equivalent experience/skills.

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 experience/skills. If you have not completed Word/Excel and PowerPoint 2010 Beyond the Basics, please contact the Learning & Organization Development team to verify equivalent experience/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

HRD219- Lync

Learn to use the Microsoft Lync program to communicate with co-workers via instant message, voice or video conferencing. In this workshop, you will learn how to create a contact list, set your presence indicator, and see how Lync interacts with Microsoft Outlook. Plus learn how to share your desktop or program with others or set-up an online meeting.

Prerequisite: Experience with Outlook Calendars or comparable knowledge.

Key Points

  • Start an instant message and presence settings
  • Build your contact list
  • Use voice and video for communication
  • Set up, start and join an online meeting
  • Share your desktop or a program with others

HRD218- 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

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 and 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 App)

HRD328- Connecting with Northwestern Collaboration Services: Calendars, Outlook Web App, Lync, and Unified Messaging

Get to know your suite of collaboration tools that come with your Northwestern Collaboration Services account. Get loads of tips and tricks to help manage the Outlook Web App, calendaring, Lync and unified messaging.

Key Points

  • Organize your commitments and activities in your calendar
  • Schedule meetings and rooms
  • Access your email, calendar, tasks and contact lists on the web using OWA (Outlook Web App)
  • Send instant messages via Lync
  • Get to know the new unified messaging (integrated voicemail) system

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

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

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: Introduction or equivalent experience/skills. If you have not completed PowerPoint 2010: Introduction, please contact the Learning & Organization Development team to verify equivalent experience/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.

Prerequisite: Project Management Essentials, Foundations of Project Management (SCS), or equivalent experience/skills. If you have not completed Project Management Essentials or the Foundations of Project Management program from the School of Continuing Studies, please contact the Learning & Organization Development team to verify equivalent experience/skills.

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

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 and printing your publication

HRD235- SharePoint

This class is designed for those new to SharePoint. In this workshop, participants will explore basic navigation and learn how to add new information to SharePoint in a training environment (not live, departmental sites).

Key Points

  • Navigate the SharePoint environment
  • Post an announcement to an existing page
  • Upload files to an existing page
  • Learn how to create a Sub Site
  • Change Site Theme
  • Create a Picture Library and add images
  • Create a Document Library and  add files
  • Create a Link Library and post links
  • Create a Discussion Board

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 and cross-functions flowchart
  • Create an organization chart
  • Create an office floor plan to scale
  • Saving and printing your drawings

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. 

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

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.

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

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.

Prerequisite: Word 2010: Beyond the Basics or equivalent experience/skills. If you have not completed Word 2010: Beyond the Basics, please contact the Learning & Organization Development team to verify equivalent experience/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

HRD409- Word 2010: Editing, Reviewing, Formatting

This advanced-level workshop is for those who work with long reports, lengthy research papers, and documents requiring multiple revisions.

Prerequisite: Word 2010: Beyond the Basics or equivalent experience/skills. If you have not completed Word 2010: Beyond the Basics, please contact the Learning & Organization Development team to verify equivalent experience/skills.

Key Points

  • Learn Styles and themes for quick and consistent formatting
  • Add a Title Page
  • Learn to create a Table of Contents and index for your document
  • Add footnotes and endnotes that automatically renumber with changes
  • 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
  • Learn about the new navigation pane view for documents that will be viewed online
  • Add hyperlinks for documents that will be viewed online

Plenty of time to answer your specific questions. Bring your files if desired.

HRD411- Word 2011 for Mac: Editing, Reviewing, Formatting

This advanced-level workshop is for those who work with long reports, lengthy research papers, and documents requiring multiple revisions.

Prerequisite: Word 2011 for Mac: Beyond the Basics or equivalent experience/skills. If you have not completed Word 2011 for Mac: Beyond the Basics, please contact the Learning & Organization Development team to verify equivalent experience/skills.

Key Points

  • Learn Styles and themes for quick and consistent formatting
  • Add a Title Page
  • Learn to create a Table of Contents and index for your document
  • Add footnotes and endnotes that automatically renumber with changes
  • 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
  • Learn about the new navigation pane view for documents that will be viewed online
  • Add hyperlinks for documents that will be viewed online

Plenty of time to answer your specific questions. Bring your files if desired.