The current Information Technology Services training catalog includes sessions for:

Banner

Excel

Group Wise

Power Point

Visio

Word

Below you will find detailed information about the classes available in each program including:  topics covered, prerequisites and information on the Reference Sheets for each program.

For more information about Training including schedule and online registration please click here.

Banner Training

Banner is an application suite of software for higher education providing solutions for all major components of the campus including: Finance, Human Resources and Student Services.     The software is based on current technology database tools accessible through the web to serve all university constituents (faculty, staff, student, administrator and alumni). 

• Banner Basic 1 (BB1)

Use of Banner Navigation tools & environment, how to access information,

Creating a Personal menu, most frequently used forms, customizing forms,

Banner transactions codes, and how to do search

 go top

Excel Training

Microsoft Excel is one of the most powerful tools to turn your data into useable information.  Excel helps you analyze, communicate and share information in a more efficient way. We provide a large number of classes to help you learn exactly what will impact you the most. 

 

• Excel Basic 1  (EB1)

Creating worksheets with Data entry: text vs numbers, Editing data, Selecting cells,

Selecting and Inserting columns and rows, Column width and Row height, Use of the

Formatting toolbar, Formating cells, Numbers, fFnts, Aligments, Borders

& Patterns, Undo and Redo functions, Opening  & Saving, Page setup, and Printing &

Previewing a worksheet

Prerequisite: None

•  Excel Basic 2  (EB2)

Entering sequences of data, using; Cut, Copy and Paste, Drag & Drop,

Entering Formulas & Functions, Autosum, Absolute vs. Relative references,

Inserting columns and rows, Auto formatting, and Conditional Formatting

Prerequisite: None

• Excel Basic 3  (EB3)

Using Sheet Features: Renaming, Moving, Copying, Selecting, Linking worksheets,

Copying Data and Formatting to Multiple Worksheets, Header & Footers, Print area,

and Printing options

Prerequisite: None

• Excel Functions 1  (EF1)

Working with functions: SUM, ROUND, AVERAGE, DAY, WEEKDAY, TODAY, NOW

Prerequisite: People attending should understand concepts of Excel Basic 1 & 2

• Excel Functions 2  (EF2)

Working with functions: CONCATENATE, LEFT/RIGHT, FIXED; IF

Prerequisite: People attending should understand concepts of Excel Basic 1 & 2

• Excel Functions 3  (EF3)

Working with & combining functions: IF, VLOOKUP, SUMIF, COUNTIF

Creating a catalog that automatically updates information in an invoice

Prerequisite: People attending should understand concepts of Excel Basic 1 & 2

• Excel Charts 1  (ECh1)

Creating a Chart with the Wizard, Resizing and Moving Chart Objects,

Changing Chart Type, Charting Non-Adjacent Data, Adjusting Scale. 

Adding, Removing and Formatting: Legend, Gridlines Data Series, and  Data Labels

Prerequisite: People attending should understand concepts of Excel Basic 1 & 2

• Excel Charts 2  (ECh2)

Creating a Graph with one Keystroke, Adding Custom Chart Types to the List,

Changing Chart Locations (Chart Object vs. Chart Sheet),

Adding a Projection to a Data Series, Explanatory Text and Objects

Prerequisite: People attending should understand concepts of Excel Basic 1 & 2

• Excel Med 1: Databases  (EM1)

Working with Databases: Sorting, Filters,  Subtotals, Forms, and Consolidating

Prerequisite: People attending should understand concepts of Excel Basic 1 & 2

• Excel Med 2 : Pivot Tables   (EM2)

Pivot Tables: Creating, Defining, Redesigning, Updating

Prerequisite: People attending should understand concepts of Excel Basic 1 & 2

• Excel Med 3: Protecting & more (EM3)

Working with large tables, Creating Titles, Adding Comments,  Conditional Formatting,

Hiding Columns or Rows, Goal Seek, Protecting cells, worksheets, and files

Prerequisite: People attending should understand concepts of Excel Basic 1 & 2

•  Excel Advanced 1: Scenarios & views  (EA1)   By Demand!

Exploring Range Names, Scenarios, Views

Prerequisite: People attending should understand concepts of Excel Basic 1 & 2

• Excel Advanced 2 : Macros  (EA2)   By Demand!

Macros: Recording & Running, Naming, Documenting, Relative vs. Absolute

Recording, Automatic Macro Execution, and Assigning to Menus

Prerequisite: People attending should understand concepts of Excel Basic 1 & 2

Reference Sheet: Excel Advanced & Macros (Available soon)

go top

Group Wise Training

GroupWise is the email program we use at Hamline as part of the Novell Enterprise family. GroupWise is a premier communication and collaboration tool that ensures connectivity and security. We offer two types of classes in the area of Group Wise.

• Group Wise 1: Email  (GW1)

Group Wise Emails: Everything about email:  Creating,  Sending, Printing,  Using

Attachments, and more 

Prerequisite: None

• Group Wise 2: Tools  (GW2)

Group Wise Tools: Using the Calendar Features for: Appointments, Task list, To Do List,

Reminders, Phone messages

Preequisite: None

• Group Wise 3: Web Access  (GW3)     

How to use Group Wise using through a web conection for email, calendar, appointments.

This session will be specially valuable for adjunct Faculty

Preequisite: None

• Group Wise 4: GW Rules  (GW4)     

How to create rules to automatically do things like: file emails to a folder, forward emails

to a third person, auto reply when on vacation or filter emails to an Spam folder

Preequisite: People attending should understand concepts of Group Wise 1 

go top

Microsoft Power Point is the easiest program of the Office suite to learn and use. The 2003 version helps you create high-impact presentations with enhanced multimedia capabilities. We provide three classes according to your need in the area of Power Point.

• Power Point 1: Creating  (PP1)

Creating presentations: Beginning a New Presentation, Adding a New Slide,

Slide Setup, Entering Text, Text Formatting using: Font, Size, Bullets, Rearranging Slides.

Applying Design Templates, Changing Backgrounds, Using the Slide Master,

Adding Clip Art, Running a Slide Show, Basic Slide Transition Effects,  and Printing slides

Prerequisite: None

• Power Point 2: Improving  (PP2)

Improving presentations: using: Editing images & pictures,

Copying tables & charts, Custom shapes, Custom templates, Inserting WordArt,

Changing ClipArts, Importing Slides, Animations & Sounds, and Rehearsing timing

& minutes

Prerequisite: People attending should understand concepts of Power Point 1

• Power Point 3: Special Needs  (PP3)   

Switching from Color to Black & White, Hidden Slides, Animating Objects,

Self Running Presentations, Setting Timings, Recording Narrations,

Creating a Photo Slide Show, Saving Different Slide Orders, and Packaging Presentations 

Prerequisite: People attending should understand concepts of Power Point 2

  go top

Visio Training

Visio is a program that helps you create diagrams easily. Visio allows you to communicate information clearly and effectively using tools like flowcharts, building plans, networks, timelines, organization charts, etc.

• Visio Basics  (Vis)   By Demand!

Creating, Opening, Adding Shapes to a Drawing,

Selecting, Moving, Resizing and Editing Shapes and Text,

Formatting Shapes, Aligning, Distributing, Rotating and Flipping Shapes,

Using Connectors, Changing Connection Point Types, Creating/Modifying Layers,

Assigning Shapes to Layers, Grouping/Ungrouping, Using Guides,

Working with Pages, Printer Paper vs. Drawing Page,

Pan and Zoom, Drawing Explorer, Custom Properties, Size and Position

Prerequisite: None

  go top

Word Training

Microsoft Word is the best-selling word processor. The 2003 version takes you to create impressive-looking documents easily improving people connection and information-sharing. We provide a large number of classes to help you learn exactly what you need.

• Word Basic 1  (WB1)

Creating, Opening & Saving Documents, Text Highlighting & Editing, Page Setup,

Undo and Repeat, Formatting toolbars: Font, Size, Enhancements, Alignment,

Quick Spelling check, Views, Zoom, Reveal Formatting, Previewing and Printing.

Prerequisite: None

• Word Basic 2  (WB2)

Special characters & symbols, AutoCorrect, Spelling & Grammar, Translations,

AutoText, Page Breaks, Moving and Copying Text, Copying Format, Find & Replace

Prerequisite: None

• Word Format 1: Font, Bullets & Paragraphs  (WF1)

Fonts, Line & paragraph spacing, Indents, Change case, Default font,

Bulleted & numbered lists, Multilevel numbered lists, Protecting documents

Prerequisite: People attending should understand concepts of Word Basic 1 & 2

• Word Format 2: Creative format  (WF2)

Borders and Shading, Page Breaks, Background & Themes, Using Tabs

Includes objects: pictures, Animating Text, Text Box, Inserting Hyperlinks

Prerequisite: People attending should understand concepts of Word Basic 1 & 2

• Word Med 1: Tables  (WM1)

Using Tables: columns & rows; inserting, resizing & formatting cells,

rows & columns; gridlines, borders, autoformat; table properties

Prerequisite: People attending should understand concepts of Word Basic 1 & 2

• Word Med 2: Advanced edition  (WM2)

Page numbers, Footnotes & Endnotes, Headers & Footers, Using Columns,

Section Breaks, Page Setup in a Section, Comparing Documents Side by Side

Prerequisite: People attending should understand concepts of Word Basic 1 & 2

• Word Med 3: Styles & Indexes  (WM3)

Creating & Using Styles, Benefits of using styles, Updating & Deleting Styles,

Adding Styles, Bookmarks and Page References, Generating Table of Contents

Requisite: People attending should understand concepts of Word Basic 1 & 2

• Word Med 4: Labels & Envelopes  (WM4)

Working with Labels & Envelopes

Prerequisite: People attending should understand concepts of Word Basic 1 & 2

• Word Med 5: Mail merge  (WM5)

Mail Merge: Task Pane vs. Toolbar, Merging Form Letters, Preparing a Data Document,

Editing Fields in a Data Document, Data Sources, Merging documents, Mailing Labels,

Merging Envelopes, Merging Email, Merging Selected Records, Sorting Records

Prerequisite: People attending should understand concepts of Word Basic 1, 2 & 4

• Word Advanced 1: Forms  (WA1) 

Forms: Preparing the Form Layout, Inserting  and Setting Form Fields

(Text Boxes, Drop Down Lists, Check Boxes), Creating Help for a Form Field,

Form Field Shading, Protecting and using the Form, Saving Form Field Data Only,

Printing Field Data Only, Making Changes to the Form

Prerequisite: People attending should understand concepts of Word Med 1, 2 & 3

• Word Advanced 2: Templates  (WA2)   By Demand!

Templates: Templates vs. Documents, Using the Supplied Templates,

Changing the Normal Template, Using Template Wizards, Creating New Templates,

Changing which Template is attached, Importing Elements from Other Templates

Prerequisite: People attending should understand concepts of Word Med 1, 2 & 3

• Word Advanced 3: Macros  (WA3)    By Demand!

Macros: Creating a Macro by Recording, Naming & Renaming a Macro, Editing Macros,

Running Macros, Assigning Macros to Toolbar buttons, Shortcut keys, Auto Macros

Menu Commands, Organizing and documenting Macros, Deleting Macros 

Prerequisite: People attending should understand concepts of Word Med 1, 2 & 3

 go top

If you have questions regarding ITS Training, please contact us by email