Skip To Main Content

Computer Applications Training

Saturday, May 30, 2020
Due to an abundance of caution in response to the developing international health crisis related to coronavirus, or COVID-19, all University of Arkansas – Pulaski Technical College Community Education face-to-face classes have been cancelled.

Computer Applications Training

University of Arkansas - Pulaski Technical College’s Business and Industry Center offers computer training to individuals, businesses, and local governments. Courses include Microsoft Office, Windows operating systems, and essential computing skills. These intensive short courses will give you or your employees the skills and knowledge needed to complete projects efficiently and effectively, maximizing productivity. Customized courses or private, company-only courses are also available. On-site training can also be arranged. Contact Molly Mitchell at (501) 907-6670 ext. 3403 or e-mail [email protected] for pricing and details.

Online Computer Classes

ALL classes listed below will be offered online through Zoom. Once you have registered for a class, the instructor will send an e-mail with a link to the Zoom meeting room, along with the password.

Excel Fundamentals – 3 Part Series

Part 1 (SOLD OUT)

In this class you will learn about fundamental Excel features to create and modify simple worksheets. Specifically, you will learn Excel terminology and how to navigate a workbook, the different ways to enter data, how to format cells, rows, and columns, and how to write basic formulas.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.

Part 2 (SOLD OUT)

In this course you will learn about managing and organizing worksheets to insert, delete, or even hide date and make your data easier to find. You will also learn about using functions in your formulas and the difference between relative and absolute cell references. Finally, we will finish with how to create basic charts.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.

Part 3 (SOLD OUT)

In this course you will learn about managing large amounts of data and how to utilize different sources of date. You will learn some of the more advanced Excel tools used for organizing data, performing calculations, and restricting data entry. Specifically, you will learn how to import data, how to adjust the worksheet view, how to sort and filter, and how to perform some advanced calculations.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.


Intermediate Excel – 3 Part Series

Part 1

In this course you learn how to use various tools that are useful when you want to customize your workbook to suit your own specific needs. You will learn about ways to set up and adjust your worksheet to look consistent, professional, and presentable. Specifically, you will learn how to format worksheets with themes and styles, how to create custom number formats, how to insert images, how to use conditional formatting and zoom tools.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.

Part 2

In this class you will use a variety of methods to work with an important type of data in Excel: date and time information. You will also learn new functions that give you greater ability for analysis and decision making. They include functions that either sum or count values that meet certain criteria. You will explore functions that can be used to clean up or rearrange text on your worksheet, as well as learn what you can do when you find formula errors in your worksheet.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.

Part 3

In this class you will explore functions used to find data, either from a large database or a small lookup table. You will also learn about the Outline feature, which can be used to group information or create subtotals. It is also a handy tool for data analysis.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.


Advanced Excel – 3 Part Series

Part 1

In this class you will explore the tools that you can use with tables in Excel and discover the advantages of creating tables. You will also learn how to create formulas that use structured references.
This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.

Part 2

In this class you will learn some of the basic financial functions that are frequently used in Excel. You will also learn how to use those functions to analyze potentially changing circumstances based on altering the variable inputs used in financial functions such as the interest rate.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.

Part 3

In this class you will learn how to summarize data using PivotTables and PivotCharts and work with the important tools needed to create both PivotTables and PivotCharts.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.


Microsoft Word for Beginners

In this class, you will learn the fundamental skills used in creating documents in Microsoft Word. Specific skills include different ways to navigate a document, entering and formatting text, how to save documents, and how to create and modify tables. This class is perfect for novice computer users.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.


Mail Merge in Microsoft Word

Mail Merge is a great feature where you can turn generic letters into personalized correspondence. The data source (which is a list of variable information, such as names and addresses) and the main document (form letter) only need to be set up and proofed once! Then using Mail Merge, you can generate hundreds of letters, envelopes, labels or emails without having to check each one. In this class, you will learn the ins and outs of this great feature.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.


Advanced Microsoft Word

In this class you will learn some of the more advanced features in Microsoft Word. Specifically, you will learn how to use and create your own templates, how to create multiple headers and footers, Table of Contents, Indexes, how to track changes and restrict editing.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.


Microsoft Teams

Learn how to use Microsoft Teams in the ever-growing age of digital collaboration. Microsoft Teams intertwines with almost the entire Microsoft Office Suite. Learn how to increase productivity and organization with this all-inclusive application.

This class will be offered online through Zoom. Once you have registered for the class, the instructor will send out an e-mail with the link to the Zoom meeting room, along with the password and instructions on how to join the class.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.


Outlook

Learn how to use Microsoft Outlook for more than just email. Microsoft Outlook has a ton of other features that will help with organization and make your productivity skyrocket!

This class will be offered online through Zoom. Once you have registered for the class, the instructor will send out an e-mail with the link to the Zoom meeting room, along with the password and instructions on how to join the class.

This session will have a live instructor who will show you how to use Excel to its fullest potential. At the end of this session, there will be time for questions and answers. The lecture will also be recorded and sent to participants after the class is completed.

Become a Community Education Instructor

Community Education seeks instructors, with professional experience and notable success in a given field, to teach quality, non-credit courses and workshops.

Community Education Course Proposal

Customized Learning

Many courses can be tailored to meet the individual needs of organizations. Curriculum as well as the day/time format can be easily altered. Courses can be taught at UA-PTC’s Business and Industry Center, or on-site at the client’s location. A computer lab with all necessary software and internet connections are required. Testing software to rate participants’ skills is available.