ITRS|Loyola University Chicago

ITRS

searchform
This siteLUC.edu

Office Application Workshops


ONLINE REGISTRATION

Please visit our online registration page to register for any of the workshops listed on this page.

1. All registrations will be confirmed via e-mail and are on a first-come, first-served basis.  If, when you attempt to register, you receive a message that a course is full, you can contact us at ITRS@luc.edu to see if there are any available openings. If there are not openings, you can request to be put on a waiting list.

2. If you are not able to attend a session, please send an email to ITRS@luc.edu at as soon as possible.  This will allow individuals on the waiting list an opportunity to participate in the workshops.


Office Applications Workshops 

ITS offers free technology workshops for Loyola students, faculty, and staff several times a year, alternating campuses between Lakeshore and Water Tower. Select workshops are now offered online via Adobe Connect, as well as in person. You have the opportunity to select which mode of training you would like when you register.  If you select Online, you will be sent login information and links to prepare your computer for the session.

Microsoft Office workshops are led by George Rumsey of the Computer Resource Center, (http://www.computer-resource.com), an organization which provides training for a number of institutions in the Chicago area.  Handouts for some of the Computer Resource Center's workshops can be found at General Class Handouts.

If you need immediate help, please check out Microsoft's free online tutorials for Office 2010.  The next considered time for MS Office training will be in October during fall break.  If you have any questions about classes, please e-mail ITRS@luc.edu.

 

Workshop Descriptions

 

What’s New in MS Office 2013

The bad news: It’s time to upgrade again. The good news: It’s not TOO big of a deal. Microsoft Office 2013 is a fairly easy transition from Office 2010. There are a few differences—a few new additions and some things have moved around. Most importantly, this session will review how to change those annoying default settings you changed in 2010 will need to be changed again and learn where key commands have been positioned on the “File” tab.

 The class will also cover the new “Design” tab in Word, which takes the concept of “Themes” to a new level, including an option to define a theme as your default. Formerly, Themes were ways to set fonts, colors, and effects (“designs”). Word now includes paragraph spacing, watermarks, page color, and borders as part of the “design.”

In Excel, you will learn how to use the new “Recommended Charts” feature, as well as the new “Quick Analysis” button (a terrific addition to Excel).

PowerPoint has some of the best improvements, including a new slide size (16:9 ratio for wide screens). There are also new “Views,” including a “Notes” view, which maximizes the notes area, and a “Comments” view, to review notes embedded in the presentation. Best of all is the new feature called “Use Presenter View,” where you have an option to split your screen into a dashboard, with notes, laser pointers, zoom commands, and more.

Finally, Access seems to have changed the least of any of the Microsoft products, with some minor revisions to the table “field types.” You will also need to re-set your Trusted Locations.

 

Excel 101

In this workshop, you will learn how to use an Excel spreadsheet for data calculations and tables.  You will create basic formulas (PEMDAS), use simple functions (Sum, Average, Count, Today), edit and format cells, and format and link workbook sheets.  You will also learn how to customize the layout of the Excel window and how to print the contents of a worksheet.  Other topics include learning how to use borders, shades, headers and footers, and other fundamental formats.

 

Excel 102

This workshop will BUILD on your existing Excel skills — make sure you are comfortable with the basic skills listed in Excel 101. The first half of the class will cover additional functions (including “text” functions), creating and formatting charts, linking tables and charts to other programs (such as Word), and conditional formatting (writing and clearing rules). The second part of the class will work with more advanced commands, including scenarios, consolidation, and pivot tables/pivot charts.

  

Tips & Tricks for Microsoft Word

 There is no program on the computer used as poorly as Microsoft Word. This class will show you how the “pros” use Word. From text shortcuts such as Autocorrect and QuickParts, to formatting shortcuts such as the format painter, styles, and templates, this 3-hour session will help you become a more effective and efficient Word user. Course will cover how to use the ruler to set tabs (left, center, right, decimal, bar, and leader) , indents, margins, and tables. It will cover the importance of “section breaks,” particularly with reference to margins, paper orientation, headers/footers and page numbers. The class will also cover how to use the “References” tab to generate a Table of Contents, bibliography, figure captions, and even a Table of Authorities, with emphasis on the importance of styles (how to use, modify, and save styles so Word operates correctly). As time permits, the session will end with templates and macros, particularly how to use macros to create your own commands on the Quick Access toolbar. (Note: Students are encouraged to bring questions and problems to this session!)


 

Please note:

1. All registrations will be confirmed via e-mail and are on a first-come, first-served basis.  If, when you attempt to register, you receive a message that courses are full, you can contact us at ITRS@luc.edu to see if there are any available openings. If there are not openings, you can request to be put on a waiting list.

2. If you are not able to attend a session, please send an email to ITRS@luc.edu as soon as possible.  This will allow individuals on the waiting list an opportunity to participate in the workshops.

For information about other training resources, click here.

Contact our Training Department with any questions about our training schedule or our current workshops.

For a list of workshops from the Office of Learning Technologies and Assessment, click here

Previous Workshop Descriptions

 

Microsoft Access 2010: Introduction

Microsoft Access is the relational database system widely used by professionals. In this workshop, you will learn how to create tables and relationships from which query searches and selection, simple forms and reports can be created.  This workshop will focus on building reports and developing queries. You may also learn some useful tips and strategies for customizing it to your specific department.

The Microsoft Access sessions will be held on 2 separate days to best accommodate faculty and staff’s work schedules. You MUST be able to attend both sessions. 

 

Excel 2010: Introduction

In this workshop, you will learn how to use an Excel spreadsheet for data calculations and reports.  You will learn how to create basic formulas (PEMDAS), use simple functions (Sum, Average, Count, Today), edit and format cells, and format and link workbook sheets.  You will also learn how to customize the layout of the Excel window and how to print the contents of a worksheet.  Other topics include learning how to use borders, shades, headers and footers and other fundamental formats.

Here is detail of what is covered:

Getting Around

  • By Keyboard:
  • By Mouse:
  • Entering Data
  • Entering Text
  • Editing Within a Cell (F2)

Ranges

  • Selecting
  • Iterating (fill)
  • Moving
  • Non-contiguous Ranges

Formulas

  • PEMDAS
  • Nesting
  • Exponents

Function

  • Sum Function/More Functions
  • Fx
  • Formulas on Ribbon

Using Multiple Worksheets

  • Concepts of worksheets
  • Cut and paste across sheets (paste special)

Basic Formatting

  • Number, Currency, Accounting
  • Font
  • Border
  • Patterns
  • Widening columns and rows
  • Centering across columns

 

Excel 2010: Intermediate

In this workshop, you'll BUILD on your existing Excel skills - make sure you are comfortable with the basic skills listed in the Excel: Introduction workshop before signing up.  Topics include: more math functions ("if" statements, sumif, count/countif/counta, standard deviations, calculating interests, standard deviations), creating and formatting charts, links tables and charts to other programs (such as Word), and conditional formatting (writing and clearing rules).

Here is detail of what is covered:

Review: Formulas & Functions

  • Sum, SumIf
  • Average
  • Count, CountA, CountIf
  • Standard Deviation (P and A)
  • If
  • Calculating Percentages
  • Absolute Cell References

More Functions

  • Date (today, now)
  • Financial (ipmt, ppmt, db)
  • Printing functions and equations

Charting

  • Selecting data
  • Moving to worksheet
  • Formatting
  • Taking to Word

Print Preview and Page Layout View

  • Headers, footers, etc.
  • Scaling
  • Print row/column, grids
  • Repeat rows and columns
  • Print formulas

More Formatting

  • Extended Cell Formats (Borders, Fills, etc.)
  • Freeze Panes
  • Merging Cells
  • Conditional Formatting

Links across Spreadsheets

  • Formulas vs. Paste Special

 

Excel 2010: Advanced

This workshop will introduce MORE Excel functions such as VLookup. Class will include a review of charting and graphics. Then students will learn how to build pivot tables and pivot charts from databases, as well as use the consolidate and subtotal features to get grouped summary information. Students will also work with Goal Seek, scenarios, and other “what-if analyses” such as validate.

Here is detail of what is covered:

Charting & Graphics (Review)

  • Switching Chart Types
  • Axis Options
  • Trendlines
  • Themes
  • Inserting Objects (SmartArt)

Text Functions

  • Text to columns
  • Concatenate
  • Proper
  • Upper and Lower
  • Left and Right
  • Len

Database Features

  • Sort
  • Filter
  • Consolidate
  • Subtotal
  • Validation
  • Pivot Tables and Pivot Charts
  • Vlookups and Hlookups

“What If” Analysis

  • Scenarios
  • Goal seek

Other Excel Options

  • Protecting a Sheet (Review)
  • Password Protecting a Workbook
  • Templates

 

Using Microsoft Word 2010 Effectively: Tips and Shortcuts

This 3-hour intermediate-to-advanced class in Word 2010 focuses on those aspects of Word that are often overlooked or not used well. The course begins with text shortcuts such as Autocorrect, adding characters to your keyboard, and Quick Parts. Then, there will be an overview of formatting concepts in Word, such as paragraph spacing, bullets and numbering, tab sets (left, right, center, decimal, bar, and leader tabs) and indents, and section breaks (used with columns, headers/footers, page numbers, paper orientation). Tables, graphics, and text boxes will also be covered. Then students will learn how to use “Styles” for formatting, and how important styles are for features such as Tables of Contents and Tables of Authorities. Finally, the class will work with “Themes” and Styles to design templates for re-use.

 

Microsoft Powerpoint 2010 Bells and Whistles

This course in PowerPoint 2010 assumes basic familiarity with the program. It will emphasize efficient use of layouts, grids and guides, color schemes and themes, and graphic features such as charts and videos. This class will include key concepts behind “master pages,” including global design decisions such as colors and fonts for seamless presentations. SmartArt, photos, and videos will also be reviewed. Finally, the course will conclude with how to create self-running presentations with animation, then “package” the presentation for CD or flash disk or for zipping and emailing.

 

What's New in MS Office 2010

The transition from Microsoft Office 2003 to Office 2007 was major; the transition from 2007 to 2010 is not nearly as drastic. This session will focus on the significant changes in Word, Excel, and PowerPoint, from the 2007 version to the 2010 version, but it will start with a brief overview for those who are upgrading from Office 2003.

 Beginning with Word, students will learn about the new “File” tab, with version control and file sharing (and even recovering unsaved documents). Changes in graphic capabilities and improved themes will be explored, along with overlooked features such as Quick Parts  and selection panes.  Some class time will be devoted to “fixing” the defaults (especially for fonts and spacing), and to customizing the “ribbon” (which was not an option in 2007).

In the Excel section, the new “File” tab has added a much easier-to-use print preview. Excel continues to make it easier to create sophisticated charts, and has added interesting new features such as “sparklines.”

PowerPoint has added more graphical capabilities, including Screenshot commands and improved SmartArt. It also has more “artisitc effects,” such as picture corrections, picture colorization, and picture filters. Students will experiment with the extended themes, new transitions, and a new animation tab with more effects. The “File” menu has added “Save and Send” and “Publish” commands, along with “Package”; it also now offers a new way to do Handouts, embedding PowerPoint slides into Word.

Finally, the session will conclude with a brief overview of Microsoft One Note. This handy note-taking program can be used to create notebooks, sections, and pages, and its various toolbars can be used to generate text, charts, and even simple calculations on the fly.

Adobe Photoshop Overview

The course introduces basic concepts of Adobe Photoshop, such as modes (Gray, CMYK, RGB), and pixel vs. dot resolution when printing and for web design; and then works with basic photo editing (brighten, contrast, lighten, darken, sharpen, crop, straighten). Students will use basic tools in the complex Photoshop toolbox, such as paint, dodge/burn, smudge/sharpen/blur, zoom/pan, and text. This course will teach you how to coordinate your tools from the toolbox with the toolbar and the multiple palettes provided in Photoshop (including navigation/view, swatches, and history). Emphasis will be on learning how to “select” and “control” areas of your picture for detailed editing (such as redeye correction).

Edit this page