Employee of the Month
Organizational Development to Offer Shorter, Topic-Based Classes
Is it difficult for you to get away from the office to attend a 1 or 2 day class? Do you only need to know one or two things about a software program and you would rather not sit through an entire class? Our shorter, topic-based classes may be just for you. We recognize that many UAB employees may not be able to attend our regular training sessions, so we have created some classes that focus on specific things that many UAB employees need. The new shorter classes are all less than 4 hours in length and still provide hands-on training. The classes and their descriptions are listed below. These classes begin in April and are available for registration now in the UAB Faculty & Staff Learning System.
Presentation Basics in PowerPoint 2010NEW!
Long gone are the days of the flip chart and overhead projector. Contemporary presentations are professional and attractive and created with Microsoft PowerPoint 2010. In this introductory class, you will learn PowerPoint tools and presentation techniques that will help you create informative, exciting presentations. During this one day course you will learn the fundamentals of the program, how to create and organize a presentation, how to add, edit and modify text, how to format slides, and how to use PowerPoint’s specialized on-screen presentation tools.
Working with Objects in PowerPoint 2010NEW!
PowerPoint 2010 offers you a lot of liberty when it comes to sprucing up slides with visual aids. But how much is too much? This class features hands-on exercises that will help inspire your creativity and guide your design skills. Learn all about images, clip art and other graphics, including how to manage, format, resize, and position them; how to group and manipulate objects; and how to add special effects to images. You will also learn how to work with tables, SmartArt, WordArt, and how to incorporate Charts and Microsoft Excel 2010 into your presentation.
Multimedia, Animation and Presentation Delivery in PowerPoint 2010NEW!
Go beyond basics to maximize the effects of your PowerPoint presentations by adding multimedia and animations. No presentation is complete without understanding the finer points of animations, transitions, videos and video compression, and other actions. Learn these tools and techniques, as well as how to pack a presentation for remote viewing.
Essentials for Creating an Access 2010 Database
Consider the data and information you work with every day. Has it become unmanageable? If so, consider using an Access database to organize and manage related information. A database can help you manage and analyze data by organizing it into easily navigable objects, like tables that store your information, queries that help you extract information, forms that provide a way to enter or view data, and reports that display the information in an organized, printable layout. By the end of this class you will have a general understanding of the basic terminology and the essential knowledge to plan and create a new Access database. You will be able to easily create a simple tables, queries, forms and reports, and get control of your data!.
Working with Tables in Access 2010
Tables are the foundation of any database and in a relational database there can be many tables. If your tables contain common information, it pays to connect them via relationships. Once your tables are related, you can work in a whole new world of queries and reports. Come discover best practices for tables and table properties. Learn how to import data into a table as well as export data so that it can be shared with others. You too will harness the power of efficient information storage and retrieval!
Getting Results with Queries in Access 2010NEW!
Do you have information stored in a database and you don’t know what to do with it? Have you tried using a filter but it doesn’t provide the desired results? Gain the upper hand by using queries! A query is a powerful tool that allows you to “question” your data, and use the answers to provide consistent analysis. After this class, you will be able to ask big questions and get powerful answers.
Topics include: different types of queries, multiple table queries, parameter queries, creating an calculated field and parameter queries.
Forms and Reports in Access 2010NEW!
Data entry can be tedious and confusing. Streamline the process by using a form. In this class, you’ll perform hands-on exercises that help to familiarize you with many convenient tools for form-building. And when your data is complete, but needs to make an appearance in the real world? Some of the same tools can help you build attractive, easy to read reports. Give your database new life with this class. Topics include: Form views, Form Design View Basics, Working with Form Properties, Creating a Report, Working in Design View and Grouping and Sorting on a Report.
Basic Formulas and Functions in Excel 2010
Learn to work quicker, smarter and more efficiently with formulas and functions in Excel 2010! In this course you will learn how to make use of a variety of different formulas and functions designed to make working with your data easier. Sum columns of data, quickly copy existing formulas, combine text contained in multiple cells, troubleshoot common formula errors, and more!
Charting in Excel 2010
Does your data get overlooked because people don’t take the time to read it? You may spend the majority of your time in Excel working with your data, but when it comes time to present and share your data, nothing beats a chart. Charts make your data simpler to digest, easier to compare, and all around more pleasing to look at. Capture the attention of your audience and get your data to standout with eye-catching charts in
Formatting and Printing Worksheets in Excel 2010NEW!
Are you spreadsheets hard to read? Does all of your data seem to run together? In this course you will learn how to effectively format your data to make it easier to read and interpret. Learn to apply themes and styles to give your spreadsheet a consistent look. Employ conditional formatting to find specific data quickly. Learn to print long or complicated documents. Keep your audience engaged by making your spreadsheets standout!
Data Entry and Lists in Excel 2010NEW!
Do you find working with long spreadsheets to be a time consuming and tedious task? In this course you will learn helpful techniques designed to make managing large spreadsheets quicker and easier. Learn shortcuts for navigating, moving and duplicating data that will speed up the data entry process. Optimize your spreadsheet view for working with long spreadsheets. Create and manage multiple sheets in a workbook. Efficiently organize your lists of data by sorting and filters. Employ tables to streamline list formatting
Basic Word Processing with Word 2010
This class is Everything You Wanted To Know About The Basics Of Document Creation But Never Thought To Ask. If you are new to computers, to word processing, or to document creation and management, this class will immerse you in the fundamental aspects of the Microsoft Word and insure that you go on to bigger and better things comfortable and confidence in your use. In fact, many of the skills you learn in this introductory course will translate to other Microsoft Office programs!
Character, Paragraph, and Document Formatting with Word 2010
If you are familiar with basic word processing, you know that the next natural step is to make your document more attractive. This class will help facilitate both your learning and your creativity. Learn how to format documents from a single character all the way up to a 50 (or more) page document. You will learn how to modify the type, size, and color of text for maximum impact and attractiveness as well as modify the background of the document using styles and themes to create a cohesive, attractive look. You will also learn how to manage the document as a series of pages, either one that will be read electronically or be printed. For instance, you’ll learn how to section a document for ease of navigation and formatting, how to create page breaks, and how to hyphenate a document. Finally, you’ll learn detailed methods for making precision edits at the paragraph level so that indents and tabs are smooth and consistent. You'll be on your way to creating great-looking documents!
Adding Visual Interest to Documents with Word 2010
Every document can benefit from well-placed graphics. But how do you know what type of graphic to use to enhance your document? And how do you manipulate it and the text around it? This class answers those questions and more by reviewing the basics of images and image formatting as well as introducing users to Microsoft Office graphics like WordArt and SmartArt. If you need to take your documents to the next level, this is the class for you. During this class you will familiarize yourself with the different kinds of graphics Microsoft Word supports, including images, clip art, WordArt, shapes, and SmartArt. Once you have determined what the best graphic for your document is, this class will also help you place or import that graphic, then modify it with Word’s elaborate built-in special effects menus. Take this class to explore this exciting topic which uses technology to stimulate creativity.
Advanced Document Editing with Word 2010NEW!
As a document gets longer, it gets more complex. But that doesn’t mean you must be at the mercy of primitive editing tools. Let this class guide you in the advanced tools and techniques that will make creating, editing, and maintaining long and complex documents a breeze. Need a table of contents? Couple clicks and there you go. Need to integrate seven independent documents into one master narrative? We cover that. This class will show you all the things you never thought you could do, like automatically comparing and combining documents. You will explore the uses of outline view—a fantastic tool for working with both long documents and collaborative documents. You will experience first-hand the wonder of the track changes function, which makes editing a breeze. Finally, you will see just how simple it can be to automatically generate so many document parts which have, in the past, been troublesome, like tables of contents, indices, footnotes , endnotes, and bibliographies. This class is a must for anyone who works with documents for publication!
Creating Tables and Forms with Word 2010NEW!
There are times when nothing but a table will do for presenting information. And other times when information needs to be collected rather than displayed. Enter the Table and Form tools native to Microsoft Word 2010. Use these powerful tools to communicate well! This class will enable you to create and manage tables of all sizes and row and column configuration. You’ll learn how format tables manually and with Word’s many built-in styles, as well as using basic sorting and formulas. You will also explore how Word can create professional looking simple forms, with familiar content controls, which you can then prepare and distribute as you would any other form. These topics might be low on the list of things you think you need to learn, but you’ll be glad you did.
Mail Merge Using Word 2010NEW!
Sooner or later everyone needs to know how to use Mail Merge. Don’t wait until you’re buried in an overwhelming project to take this class, which takes you step-by-step through what you need to know to create and successfully mail merge a document. During practical, hands-on exercises you’ll explore and create data sources, add merge fields to a regular document, edit those fields, add and edit rules fields and preview your merged document. Add a lesson on envelopes and labels and when you’re done, you’ll know everything there is to know about Mail Merge.