Getting Started with Access 2010 (6 hours)

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

Participants 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 2010 - Queries and Reports (1.5 hours)

Overview
Queries and reports are used in Access 2010 to convert data into useful information and are an essential part of any database application. Access 2010 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 2010

Prerequisites
Getting Started with Access 2010 or one year working with Access

Getting Started with Excel 2010 (4.5 hours)

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

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

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

Excel 2010 - Functions and Formulas (1.5 hours) 

Overview
Excel 2010 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 2010. Basic, logical, financial, and date functions are also covered.

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

Prerequisites
Getting Started with Excel 2010 or one year experience using Excel.

Excel 2010 - Managing Data (1.5 hours)

Overview
Excel 2010 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 2010.

Prerequisites
Getting Started with Excel 2010 or one year experience using Excel.

Excel 2010 - Pivot Tables and Charts (1.5 hours)

Overview
Excel 2010 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 2010.

Prerequisites
Getting Started with Excel 2010 or one year working with Excel.

Outlook - Alerts and Rules (1.5 hours)

Overview
Microsoft Outlook 2010 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 2010.

Prerequisites
The Microsoft Office 2010: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Windows Office environment and a basic understanding of the Internet.

Outlook - 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 2010.

Prerequisites
The Microsoft Office 2010: Beginning Outlook learning path or equivalent; basic knowledge of word processing and computing; familiarity with the Microsoft Windows Office environment and a basic understanding of the Internet.

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

Overview
Microsoft PowerPoint 2010 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 2010 themes. The course also introduces SmartArt in PowerPoint 2010, 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 to gain added competency in PowerPoint 2010

Prerequisites
Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments.

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

Overview
Microsoft’s PowerPoint 2010 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 to gain added competency in PowerPoint 2010

Prerequisites
Knowledge of basic word processing and computing; familiarity with the Microsoft Windows and Office environments.

Getting Started with 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 using the SAP GUI.

Making 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 2010 - Pictures, Graphics, and Tables (1.5 hours)

Overview
By using the table and charting capabilities of Microsoft Office Word 2010, you can format, sort, and analyze data with ease. In Word 2010, 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 2010 enables you to do so with a few simple steps. This course shows how to create, format, and change Word 2010 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 to gain competency in Word 2010

Prerequisites
Getting Started with Word 2010 and some experience of using Microsoft Office or one year experience using Word.

Word 2010 - Forms and Mail Merge (1.5 hours)

Overview
Word 2010 enables you to create forms quickly and easily, so they can be used by other users of Word 2010. Forms contain form fields that you can link to external data sources, and Word 2010 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 2010.  It enables users to merge content into letters, e-mail messages, envelopes, and labels easily. 

Who Should Attend
Those seeking to gain competence in Word 2010.

Prerequisites
Getting started with Word 2010; some experience of using Microsoft Office; competency in the use of Word; an understanding of data sources such as Excel and Access.

Word 2010 - 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 to gain competence in Word 2010.

Prerequisites
Getting started with Word 2010; some experience of using Microsoft Office; competency in the use of Word.

Word 2010 - 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 to gain competence in Word 2010.

Prerequisites
Getting started with Word 2010; some experience of using Microsoft Office; competency in the use of Word.

Microsoft Office for Mac 2011 

E-learning is available online through SkillSoft and Lynda.com.

SkillSoft - faculty and staff have 24/7 access to SkillSoft.  Log into Answers@Texas State to access the SkillSoft button.

Lynda.com - by request, we can set up faculty and staff with two weeks free access to www.Lynda.com.  E-mail ITAC for more details.