COVID-19 Information

See the latest updates and information regarding the COVID-19 pandemic, including a list of University contact information at

Microsoft Desktop Software


Access 2013 Basics Part 1
This training is perfect for beginners. It will cover creating databases, populating fields, and the basics of datasheet view.

Access 2013 Basics Part 2
The second part of the beginner training will explain how to create forms to enter data, how to import data from an Excel spreadsheet, and sorting and filtering data.

Access 2013 Simple Queries
Learn how to use simple queries, which can display data from across multiple tables and how to use the design view.

Access 2013 Duplicate and Unmatched Queries
Tired of repeated or incomplete data entries? Take this training to find out how to solve that problem!

Access 2013 Crosstab Queries
Learn how to use the crosstab query to both drill down into your data and find new information from your database!

Access 2013 Validation Rules
Tired of people saying they’re 200 years old? Learn how to set validation rules on your database and never have an incorrect entry again!


Excel 2013 Data Validation Form
Learn how to make sure that names are names and numbers are numbers with Data Validation.

Excel 2013 Formatting
Make your data look the way you want it to with these formatting tips.

Excel 2013 Pivot Charts
Make your demonstration interesting and interactive using Pivot Charts.

Excel 2013 Concatenate
Piece names, mailing addresses, and anything else together with this handy function!

Excel 2013 Drop Down List and Duplicates
Learn how to create a multiple-choice drop-down list and get rid of duplicate entries in this demonstration.

Excel 2013 Group Data
Make your data presentable and organized with subtotals and charts!

Excel 2013 If Function
Learn how to use the IF function to control your data set.

Excel 2013 Macros
Learn how to use Macros so you never have to do the same thing twice.

Excel 2013 Sparklines
Learn how to use sparklines in Excel 2013 to create miniature graphs for your data.

Excel 2013 Printing
Learn how to print in Excel 2013.


PowerPoint 2013 Themes
Keep your presentation interesting by customizing it with a theme.

PowerPoint 2013 SmartArt
Learn how to create an organizational chart using Smart Art in Powerpoint 2013.

Getting to Know PowerPoint
Learn the ins and outs of creating a presentation and using Powerpoint’s many features and tools to keep things organized.

PowerPoint 2013 Saving and Printing
Learn how to save and print your presentations in Powerpoint 2013.


Introduction to Word 2013
Dive into Word with this presentation over text, paragraphs, tabs, tables, and other miscellaneous tasks.

Word 2013 Commonly Used Tasks
Learn the fundamentals of Word; saving, opening, closing and undoing mistakes, all in one demonstration.

Word 2013 Header, Footer & Page Numbers
Learn how to use headers and footers to name, number, and include any extra information you need in your document.

Word 2013 Indents and Tabs
Tabs too small? This presentation covers modifying your indent and tab length.

Word 2013 Page Layout
Make your Word documents look even better with the Page Layout tab! This training covers the features of the Page Layout tab such as: Page Size, Indents, Text Wrap, and more!

Word 2013 Sources, Citations, and Table of Contents
Learn how to use Word to create citations, bibliographies, and even insert a table of contents into your document.

Word 2013 Text Effects
Personalize your document with fonts and text effects.

Word 2013 Input Boxes and Templates
Learn how to use checkboxes, text boxes, and templates to make creating a printable form easy.

Word 2013 Commonly Used Tasks
Learn the fundamentals of Word; saving, opening, closing and undoing mistakes, all in one demonstration.

Word 2013 Tracking Changes
Use the Track Changes and Review features to make peer editing quick and easy!


New Features in Outlook 2013
Get caught up on the new features introduced in Outlook 2013.

Outlook 2013 Calendar
Get acquainted with Outlook 2013’s new calendar.

Outlook 2013 Archiving
Tired of running out of e-mail space? Learn how to archive so you don’t have to delete important e-mails.


Publisher 2013 Building Blocks
Learn how to use the premade templates in Publisher to create a quick and organized document.

Publisher 2013 Mail and E-Mail Merges
Create personalized flyers and attachments for your customers with merges.

Publisher 2013 Ribbon
Learn how to use word art to stylize and draw attention to your Publisher document.

Publisher 2013 Word Art
Learn how to use word art to stylize and draw attention to your Publisher document.


IT Help Desk

(573) 651-4357
Memorial Hall 107

IT Office

(573) 651-2217
One University Plaza
Cape Girardeau, Missouri 63701