Faculty and Staff Training
Upcoming Training Opportunities/
Register for Training
Training Calendar - The training calendar allows faculty and staff to register for training opportunities.
Faculty Training Opportunities
Visit the IDWT web site to view upcoming training opportunities. Register using the Training Calendar .
Microsoft Office Resources
Using the Help Feature in Office
- Click on the help button in any program in the Office Suite.
- Type in your search term in the box or look at the available tutorials on the office.com web site.
[created by Microsoft]
- Word for New Users
This article presents basic concepts in Microsoft Word 2010 to help new users get started in creating sophisticated, professional-looking documents
- Create Your First Word Document I
Learn how to create your first document in Word: type where you want to on a page, fix spelling errors, make a list, change page margins, add emphasis to some words, quickly add some style, and save your work.
- Create Your First Word Document II
Part two of the “Create your first Word 2010 document” series for those who are new to Word. Learn to move around in the document, use formatting marks, move text by using Cut and Paste, and change line spacing and alignment in Word 2010.
- Using the Navigation Pane to Search and Move Around in Your Document
In this course, find out how the Navigation Pane enables you to view all of your document’s headings and pages in a clear, top-to-bottom format; locate and restructure chunks of content just by dragging headings; and find all instances of specific words, phrases, or items such as figures and tables – without having to scroll through the search results.
- Creating Visually Compelling Documents in Word 2010
Effective documents convey important information in a well-designed way — and Word 2010 offers several options to assist you in designing your information so that it really stands out. In this course, we’ll show you how to be your own graphic designer and get your text and images noticed.
- Get Control of Page Numbers Headers and Footers
Get a solid grasp on how to create and control headers and footers—including page numbers, text, and images--in Word 2010.
- Customizing a Table of Contents
Create a table of contents (TOC) in Word 2010. Prepare document headings so that Word will generate the TOC automatically, and customize the look and settings for the TOC.
- Creating Accessible Word Documents
Create Word 2010 documents that are more accessible to people with disabilities. Learn how to format your document using Styles, add alternative text to images, and other tips to make your document easier for users and assistive technologies to navigate.
- Word 2010 Tips and Tricks
You’ve created tons of Word documents. But perhaps you need some timesaving techniques to help you work faster. This short course will do just that: give you tips and tricks for working with Word 2010.
- Word 2010 Keyboard Shortcuts
Learn Word 2010 keyboard shortcuts. Find out how to access almost any button using the ALT key. And, learn handy shortcuts that use the CTRL key.
- Mail Merge Made Easy
- Mail Merge for Word and Outlook
[created by Microsoft]
- Basic Task in Excel 2010
Learn how to perform common tasks with Excel 2010
- Create your first spreadsheet
Lean how to create a spreadsheet, do basic math in Excel, add and delete columns and rows, keep column titles in sight as you scroll, and prepare a spreadsheet for printing
- Create formulas
Learn to use formulas to do math, update formula results automatically, and use predefined formulas (functions0 to calculate things like monthly payments.
- Use Excel tables to manage information
Manage information by usign Excel tables, which make it easy to format date, sort, filter, add totals, and use formulas.
What it is, and when to use it Learn how to use VLOOKUP to look up a value you want to find in an Excel list or table.
- The IF function:
What it is, and how to use it Overview the IF function checks to see if a condition you speify is true or false. If true one thing happens; if false, something else happens.
- How to Create a Basic Chart
Learn how to create a chart and how to make changes to a chart after you creat it.
[created by Microsoft]
[created by Microsoft]
- Getting started with Access 2010
- Design the tables for a new database
Learn how to use Access 2010 by designing and creating a database. You'll start by learning how to design the tables and relationships for a new database. A good design ensures your database captures all your data accurately. This is the first course in a series that teaches beginners how to use Access 2010.
- Create tables for a new database
Learn how to build the tables for a new database. Tables are the essential component of any database. Without them, you don’t have a database. If you're feeling intimidated, relax. We assume you're a beginner, and we’ll show you how to create tables step by step. Just make sure you've taken the first course in this series, or that you're familiar with basic database concepts such as fields and primary keys.
- Create relationships for a new database
Learn how to create table relationships for a new Access 2010 database. Relationships are essential because they bring the data in your tables together so you can extract meaningful information. This course explains the different types of relationships and shows you how to create them. This is the third course in a series that teaches beginners how to use Access 2010.
- Create queries for a new database
Learn how to create queries for an Access database. Queries are an essential part of any database. They’re how you answer extract meaningful information from your database and answer key business questions. This is the fourth course in a series that teaches beginners how to use Access 2010.
- Create forms for a new database
Learn how to create forms. Forms provide a window into your data, make your database look polished and professional, and help you enter data more accurately. This is the fifth course in a series that teaches beginners how to use Access 2010.
- Create reports for a new database
Learn how to create reports. Reports present information visually, help others understand your data, and answer critical business questions. This is the sixth and final course in a series that teaches beginners how to use Access 2010.
- Build and publish web databases
This course explains how to create and publish an Access 2010 web database that runs on SharePoint 2010. You’ll also learn how to save a changed web database to SharePoint, and how to create a web database from scratch using a blank template.
Content on this page was compiled and provided by the SU Training & Development Committee of the University Technology Council. October 2011.