Texas State University Logo
Banner Image
Technology Resources (TR)
601 University Drive, JCK 720
San Marcos, TX 78666

TR: 512.245.2501
ITAC: 512.245.ITAC (4822)

Quick Links

IT Assistance Center (ITAC)

Join the Conversation

adjust type sizemake font smallermake font largerreset font size

ITAC Training Courses

We offer training to faculty and staff that focuses on enhancing job-related technology skills. Training is offered in person or online. In addition, on-demand classes can be developed for individual work units. The goal is to help faculty and staff get the job done! 

Course dates, times, and registration:  Go to SAP - Training and Development


Click a subject area below for courses and descriptions.

Expand or Collapse all.

Access 2013

Access Getting Started - Access 2013 (6 hours)

Overview
This course is 1.5 hours per week for 4 weeks.

Participants will learn the following:

  • Create reports in Microsoft Access and manage data in existing databases
  • Create their own new databases
  • Maintain data consistency,
  • Share Access data with other applications

Who Should Attend
Those new to working with Microsoft Access.

 

Access Access 2013 - Queries and Reports (1.5 hours)

Overview
Queries and reports are used in Access to convert data into useful information and are an essential part of any database application. Access has a Query Wizard which simplifies the process and provides methods of creating reports to present summarized information easily and effectively. This course explores the use of the Query Wizard and shows how to create or change a query in Design view to achieve specific results. This course also covers Expression Builder, calculated fields, grouping options for displaying query results, and crosstab, unmatched, and duplicate queries. The use of the Report, Report Wizard, Blank Report, Report Design, and Label options are covered. 

Who Should Attend
Those seeking to gain competency in Access 2013

Prerequisites
Getting Started with Access 2013, Access 2013 Essential Training via lynda.com, or one year working with Access

 

 

Excel 2013

Excel Getting Started - Excel 2013 (4.5 hours)

Overview
This course is 1.5 hours per week for 3 weeks.

In this course, students create and edit basic Excel worksheets and workbooks.

Who Should Attend
Those who need the skills necessary to create, edit, format, and print basic Excel worksheets.

 

Excel Excel 2013 - Functions and Formulas (1.5 hours) 

Overview
Excel provides many functions and formulas for performing simple and complex calculations on workbook data. The Ribbon's Formulas tab provides convenient access to groups of data analysis and calculation tools, such as the Function Library, Named Cells, Formula Auditing, and Calculation groups. This course teaches how to create and edit formulas, use references and names, and work with tables in Excel. Basic, logical, financial, and date functions are also covered.

Who Should Attend
Those seeking competency in the use of Microsoft Excel.

Prerequisites
Getting Started with Excel 2013, Excel 2013 Essential Training via lynda.com, one year experience using Excel.

 

Excel Excel 2013 - Managing Data (1.5 hours)

Overview
Excel provides improved tools and new features that allow you to improve the appearance of sheets and workbooks. Cells, rows, columns, sheets, and workbooks can be manipulated and customized using various positioning and formatting features. This course explores copying and moving cells, columns, rows, and sheets, as well as inserting or removing sheets and changing workbooks. Formatting tables, textual data, and numerical data, as well as conditional formatting, is also covered. 

Who Should Attend
Those seeking competency in the use of Excel.

Prerequisites
Getting Started with Excel 2013, Excel 2013 Essential Training via lynda.com, or one year experience using Excel.

 

Excel Excel 2013 - Pivot Tables and Charts (1.5 hours)

Overview
Excel provides powerful data analysis tools that enable you to explore large amounts of data and to make educated business decisions based on that data. With PivotTable reports you can interactively summarize data, making it easier to analyze and present the results. PivotChart reports provide a graphical view of PivotTable report data. Using Goal Seek and Solver enables you to retrieve needed results from formulas by finding out the data the formula needs. You can also use added what-if analysis items, data tables and scenarios, to view how value changes in formulas affect the formula results and to forecast worksheet outcome models respectively. This course covers advanced data analysis features, such as PivotTable and PivotChart reports, Goal Seek, Solver, scenarios, data tables, and OLAP.

Who Should Attend
Those seeking competency in the use of Excel.

Prerequisites
Getting Started with Excel 2013, Excel 2013 Essential Training via lynda.com, or one year experience using Excel.

 

 

Lync 2013

Lync Getting Started - Lync 2013 (1.5 hours)

 

Overview
In this course, students will learn how to navigate Lync, build contact lists, manage presence, upload a photo, make a Lync call, and collaborate with others using online meetings and screen sharing.

 

Who Should Attend
Those who need the skills necessary to become comfortable with Lync interface and functionality

 

 

 

 

Outlook 2013

Outlook Outlook 2013 - Alerts and Rules (1.5 hours)

Overview
Microsoft Outlook provides you with the tools you need to manage your e-mail messages. By using predefined or custom rules and alerts, you can organize your messages by moving, deleting, and forwarding them correctly, and you can even choose to send an automatic reply to incoming e-mail.  This course teaches how to configure rules and alerts to help organize e-mail messages.

Who Should Attend
Those seeking competency in the use of Outlook.

Prerequisites
Outlook 2013 Essential Training via lynda.com or one year experience using Outlook.

 

Outlook Outlook 2013 - Managing Calendars and Booking Resources (1.5 hours)

Overview
You will learn how to manage and share your own calendar, manage other people's calendars, and book meetings with resources (rooms).

Who Should Attend
Those seeking competency in the use of Outlook.

Prerequisites
Outlook 2013 Essential Training via lynda.com or one year experience using Outlook.

 

 

PowerPoint 2013

PowerPoint PowerPoint 2013 - SmartArt, Tables, Org Charts, Diagrams (1.5 hours)

Overview
Microsoft PowerPoint is a useful application for creating dynamic slide show presentations. This course teaches how to create visually appealing presentations using PowerPoint's design templates and setting up new Microsoft Office 2013 themes. The course also introduces SmartArt in PowerPoint, a feature that allows you to add some glamour to your presentations by using colors and shapes to highlight text and data. Also covered are the various ways of incorporating diagrams, tables, and charts to increase your presentations' appeal.

Who Should Attend
Those seeking competency in the use of PowerPoint.

Prerequisites
PowerPoint 2013 Essential Training via lynda.com or one year experience using PowerPoint.

 

PowerPoint PowerPoint 2013 - Jazz it Up with Animation & Multimedia (1.5 hours)

Overview
Microsoft’s PowerPoint is one of the world’s most widely used applications for creating presentations. Powerful, high-impact slide shows come to life with the addition of animations and multimedia to your presentations. Engage your audience by keeping things lively and interactive with movie and sound clips, animated slide content, and slide transitions. This course will help you to make the most of all these features.

Who Should Attend
Those seeking competency in the use of PowerPoint.

Prerequisites
PowerPoint 2013 Essential Training via lynda.com or one year experience using PowerPoint.

 

 

SAP

SAP LogoGetting Started - SAP (2 hours)

Overview

This course provides participants with an introduction to SAP at Texas State, basic navigation, and basic reporting.

Who Should Attend

All new hires required to perform duties beyond time keeping using SAP GUI.

Windows 7

WindowsMaking the Transition from XP to Win 7 (1.5 hours)

Overview

This course provides participants with an introduction to the new Windows operating system.

Who Should Attend

Participants looking to gain experience with Windows 7.

Word 2013

Word Word 2013 - Pictures, Graphics, and Tables (1.5 hours)

Overview
By using the table and charting capabilities of Microsoft Office Word, you can format, sort, and analyze data with ease. In Word, you can insert a table by selecting its layout from a list of preformatted tables or by selecting the number of columns and rows that you need. You can insert a table into your regular document layout, or you can nest it within another table for increased complexity. There may also be times when you need to insert Excel data or charts into a Word document, and Word enables you to do so with a few simple steps. This course shows how to create, format, and change Word tables, including inserting and deleting table elements, resizing tables, merging and splitting cells, sorting data, using simple formulas, as well as converting a table to text. Methods of inserting, linking, and embedding Excel objects in Word documents are explained in this course, as well as inserting and formatting charts.

Who Should Attend
Those seeking competency in the use of Word.

Prerequisites
Word 2013 Essential Training via lynda.com or one year experience using Word.

 

Word Word 2013 - Forms and Mail Merge (1.5 hours)

Overview
Word enables you to create forms quickly and easily, so they can be used by other users of Word. Forms contain form fields that you can link to external data sources, and Word contains security features to protect forms from tampering by other users. Inserting fields is simple with built-in commands and content controls. The mail merge feature is also improved in Word.  It enables users to merge content into letters, e-mail messages, envelopes, and labels easily. 

Who Should Attend
Those seeking competency in the use of Word.

Prerequisites
Word 2013 Essential Training via lynda.com or one year experience using Word.

 

Word Word 2013 - Quick Styles, Building Blocks, Themes, and Contents (1.5 hours)

Overview
You will learn about style options, document themes, Word templates, and how to build a table of contents.

Who Should Attend
Those seeking competency in the use of Word.

Prerequisites
Word 2013 Essential Training via lynda.com or one year experience using Word.

 

Word Word 2013 - Formatting Long Documents and Table of Contents (1.5 hours)

Overview
You will learn various tools to format long Word documents including how to use the format painter, set up headers and footers, how to build a table of contents, and much, much more!

Who Should Attend
Those seeking competency in the use of Word.

Prerequisites
Word 2013 Essential Training via lynda.com or one year experience using Word.

 

 

MS Office for Mac 2011

Office for Mac Microsoft Office for Mac 2011 

While the above courses are taught using Windows computers, the features are very much the same on Mac computers.  We invite and encourage both Windows and Mac computer users to attend our ITAC training courses. 

For Microsoft Office for Mac 2011 specific training, visit lynda.com (available to all faculty and staff). 

How to access lynda.com

  1. Go to https://answers.txstate.edu and log in.
  2. Click Go to lynda.com.
  3. Log in with your NetID and password.

Course dates, times, and registration:  Go to SAP - Training and Development

Also see the Professional Development Fall Preview for course dates and times.


Other Training Needs

Contact ITAC to get more information on our workshops or to learn about individual or group training for you or your area.