workshops and webinars
Educational Technology and Training offers group training via webinars and in-class workshops. Here's the schedule for Spring 2020.
These hands-on workshops are open to both faculty and staff. They are limited to 12 attendees and a reservation is required. Contact Sharon.Benoit@wne.edu to reserve your seat
Introduction to Excel
14 Feb 2-4pm
19 Feb 2-4pm
20 Mar 1:30-3:30pm
This is a general introduction to Microsoft Excel. Example topics include basic layout and navigation, information types, entering and editing information, the quick access toolbar, password protection, entering formulas, using the fill handle and autofill, formatting data, fonts and text sizing. This workshop is recommended for both new Excel users as well as anyone who could use a refresher. It is the foundation for other intermediate to advanced Excel workshops to follow.
21 Feb 2-4pm
3 Apr 1:30-3:30pm
Using Excel to format a block of data as a table makes it easy to carry out a variety of tasks on the table data without affecting other data in the worksheet. Once you have defined your table, you can sort, filter, and summarize the information. Excel tables are the foundation for Pivot Tables. We will learn to create a table, sort, filter, extract and summarize data.
Excel Pivot Tables
6 Mar 2-4pm
10 Apr 1:30-3:30pm
Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set. And they let you group your data together in different ways so you can draw helpful conclusions more easily.
17 Apr 1:30-3:30pm
A function is a predefined formula that performs calculations using specific values in a particular order. Excel includes many common functions that can be used to quickly find the sum, average, count, maximum value, and minimum value for a range of cells. In addition to these functions we will learn the If and Vookup functions, relative and absolute referencing, and named ranges.
Word Mail Merge
13 Mar 1:30-3:30pm
Using Mail Merge is an efficient way to create and send form letters to multiple recipients. Create one document and merge it with a file that contains the names and addresses of the various intended recipients. Join us to learn how to generate letters, envelopes, mailing labels, email blasts, and lists by merging an Excel list with a Word document.
Word Styles and Building Blocks
24 Apr 1:30-3:30pm
Styles and Building Blocks are tools that enable you to quickly create and format Word documents. Building blocks in Microsoft Word are pieces of document content or pre-defined items, like tables, lists, headers, and text boxes that can be used again and again in Word files. You can create and save your own building blocks for that content you use regularly.
Designing an Effective PowerPoint
27 Mar 1:30-3:30pm
Join us as we learn to create presentations that go beyond simple text and bullets. We will add graphics, SmartArt, video, and hyperlinks. We will learn to generate handouts and even see how easily we can narrate and record our presentation to create an MP4 file.
Learn something new without leaving your office! These half hour sessions are delivered completely online and links to recordings of the sessions will appear below shortly after the date of the live event. No reservations are necessary. Use this URL to attend the live event. http://wne.adobeconnect.com/webinar or Email Sharon.Benoit@wne.edu for the URL (web address) to attend live. Log in as a guest with your name.
Echo360 Universal Capture
11 Feb 12:30-1:00pm
Echo360 is a system for creating and streaming instructional videos and audio-only podcasts. Echo360's Universal Capture software allows you to use any computer (Windows or Mac) to create screencasts and publish them to the Echo360 system.
Narrate and record a PowerPoint presentation
25 Feb 12:30-1:00pm
Did you know that you can create a screen recording in PowerPoint? Not only can you record your screen, but the recording can be saved as a video file and distributed outside of PowerPoint. Additionally, you can record your entire PowerPoint presentation (narrations and animations included) and save that recording as a video file and then distribute it.
Intro to Excel Pivot tables
10 Mar 1:30-2:00pm
A brief look at one of Microsoft Excel's most powerful features. We will see how to filter and summarize large data sets.
Setting and Using Tabs in Word
24 Mar 1:30-2:00pm
Tabs are a paragraph-formatting feature used to align text. Did you know that Word has five differenct types of tabs? It is a powerful feature that every Word user needs to master.
Word Styles and Building blocks
7 Apr 1:30-2:00pm
Building blocks in Microsoft Word are pieces of document content or pre-defined items, like tables, lists, headers, and text boxes. They can be used again and again in Word files on your computer.
Word Mail Merge
21 Apr 1:30-2:00pm
Create letters, envelopes, labels, email blasts and lists.