IT Training and Events Calendar

Please click on the title of an event to view details such as links to a registration form.

Tomorrow - Fri, Feb 22, 2019

Intro to Google Calendar

We will offer 30 minute introduction to Google Calendar trainings on the half hour from 10 a.m. to 3 p.m. with a break for lunch 12-12:30 p.m. No registration is needed.
The location is Seeley Mudd 115 on the first floor.
You may bring your phone or tablet, but if your device(s) have never been on campus before or not recently you will need to visit the IT Help Desk down the hall Seeley Mudd first floor before or after the training to get those devices set up. There will not be time during the training to network register or troubleshoot device network connection issues.

Mon, Feb 25, 2019

Intro to Google Calendar

We will offer 30 minute introduction to Google Calendar trainings on the half hour from 10 a.m. to 3 p.m. with a break for lunch 12-12:30 p.m. No registration is needed.
The location is Seeley Mudd 115 on the first floor.
You may bring your phone or tablet, but if your device(s) have never been on campus before or not recently you will need to visit the IT Help Desk down the hall Seeley Mudd first floor before or after the training to get those devices set up. There will not be time during the training to network register or troubleshoot device network connection issues.

Tue, Feb 26, 2019

CMS Content Management System Logo

Create and Edit Content on the Amherst Website

Learn the basics of creating and editing content on the Amherst Website using the Content Management System (CMS).

Tue, Mar 5, 2019

CMS Content Management System Logo

Using Webforms on the Amherst Website

Learn to create and edit forms on the Amherst College Website using the Content Management System (CMS).

Wed, Mar 6, 2019

Microsoft Excel 2016 - Tips & Tricks Part 1

This workshop contains a variety of quick tips and tricks in Microsoft Excel that will save you hours of time! You'll learn how to add buttons to the Quick Access Toolbar, so the commands you want are at your fingertips. You'll learn how to view all the formulas in a worksheet and how to freeze rows and columns for easier viewing and navigation. You'll practice time-saving shortcuts for selecting, moving, and copying cell, and you'll learn how to use AutFill to create a series of numbers or dates or to copy formulas. You'll review basic formulas and functions, including the order of operations, absolute references, and AutoSum. You'll learn to fix formatting problems easily with the Format Painter, and how to deal with formatting annoyances like zip codes, centering titles, date formats, etc. The class will also cover sorting and filtering lists, including custom sorts on more than one level. You'll also practice using Excel's extensive (and sometimes confusing) cut and paste options and learn how to copy from Excel to Word as text or as a link that updates automatically. You'll practice preparing a spreadsheet for printing, including setting the print area, scaling, and adding headers and footers. The workshop will also cover new features, such as Flash Fill, Quick Analysis, and "Tell Me" Help. A complete list of keyboard shortcuts is also included.

The trainer will be Mannie White from Pioneer Training.

Tue, Mar 12, 2019

Microsoft Word 2016 - Tips & Tricks Part 1

This workshop contains a variety of quick tips and tricks in Microsoft Word that will save you hours of time! You'll learn to add buttons to the Quick Access Toolbar, shortcuts for selecting words, sentences and paragraphs, and how (and why) to display non-printing characters in your document.
You'll practice using the Format Painter to copy formatting and fix problems with numbered and bulleted lists. You learn to create AutoCorrect entries to correct common typos, and AutoText entries and Quick Parts to easily enter frequently-used text. You'll learn how to set indents with the ruler and the ribbon, and how to use tabs, set tab types and set tab leaders. You'll practice creating and formatting tables with borders and shading, as well as creating a Quick Table for reuse.
You'll learn how to create a word template to create routine documents and how to share the template with co-workers across a network. You'll also learn how to PDF files directly in Word. The class will also review common Word Annoyances, such as unwanted automatic formatting, and how to avoid them. A complete list of keyboard shortcuts is also included.

The trainer will be Mannie White from Pioneer Training.

Wed, Mar 13, 2019

Microsoft Excel 2016 - Tips & Tricks Part 2

This class will present a series of tips and shortcuts that will help you work more efficiently and complete more complex tasks with Microsoft Excel. You’ll learn how to assign range names to groups of cells and how to use range names in formulas and functions. You'll practice working with multiple spreadsheets in a workbook, including navigating large workbooks, grouping sheets for quick editing and formatting, and creating 3-D formulas that span several sheets. You'll learn how to lock and protect a sheet and how to add comments for review. The class will also cover converting lists to tables, concatenating and separating text, and creating a drop-down list for data entry. The class will then focus on several useful Excel functions: Payment, If, Iferror, Vlookup, Round, CountIf and SumIf. Finally, you'll learn how to record a simple macro to automate repetitive tasks, and how to assign it to a button the Quick Access Toolbar. A complete list of keyboard shortcuts is also included.

The trainer will be Don Lesser from Pioneer Training.

Tue, Mar 19, 2019

Microsoft Word 2016 - Tips & Tricks Part 2

This class will present a series of tips and shortcuts that will help you work more efficiently and complete more complex tasks with Microsoft Word. The class will start with a review of quick tips for solving common problems in Word—Quick Access Toolbar, paragraph spacing, Format Painter, numbered and bulleted lists. Then you'll practice using styles to make global formatting changes in a document. You'll also learn how to create a custom style and save it in a template.
You'll practice adding section breaks, page numbers, and headers and footers to long documents, and you'll learn how to generate and update a table of contents automatically. The class will also cover how to use Track Changes to allow multiple reviewers to edit a document, how to add comments to a document, how to compare and combine similar documents, and how to inspect a final document to remove all markup.
You'll learn how to create a template as a more efficient alternative to "Save As" when creating routine documents, as well as how to share a custom template with co-workers over a network. Finally, you'll learn how to record a simple macro to automate repetitive tasks, and how to assign it to a button the Quick Access Toolbar. A complete list of keyboard shortcuts is also included.

The trainer will be Mannie White from Pioneer Training.