Computer Applications

computer training students

Introduction to Computers

COURSE LENGTH: 7 HOURS
This course is for participants who have little or no experience with personal computers and who
want to learn the basics. Participants will learn about the main components of a typical computer
system and the basic elements of the Windows interface. Participants will learn how to navigate in
Windows Explorer, organize files and folders, search for items on their computers, and personalize
Windows. Participants will also learn how to browse the Web with Internet Explorer and how to
protect their computers from malware.

 

MS Excel Essentials and Potentials Level 1, Level 2, Level3, Level 4

COURSE LENGTH: 4 HOURS EACH LEVEL

Excel Essentials and Potentials Participant Learning Outcomes: To build on existing Excel knowledge, introduce and polish intermediate Excel knowledge and introduce the newest and exciting features. The class will have a brief introduction of Excel to understand the importance of data integrity and expand and polish uses such as spreadsheets, formulas, functions and pivot tables. Data manipulation and efficiency is stressed through out the training. Participants are provided scenarios to use formulas and functions effectively. The class spends optimal time on tables with filters, calculations, slicers, and timelines. Training on pivot tables includes building, formatting, slicers, timelines and calculations. All of the above-mentioned training will give the participants plenty of hands on experience that will lead in to introduction of Power Query and Power Pivot. These options to Excel are known at Microsoft as “Extract TransForm and Load” where “you’ll spend less time manipulating data and more time driving impact”. Each level is a 4-hour session.  Offered on East Campus in Lagrange in November and Coweta Campus in December.

Each session is $85.00 per person, including materials.
For more information contact Leigh Newman at leigh.newman@westgatech.edu
Or 706-756-4613

 

MS Word · Basic

COURSE LENGTH: 7 HOURS
This course covers the basic skills and concepts students need to use Microsoft Word productively
and efficiently. After an introduction to Word’s window components, students will learn how to
create and save documents and how to navigate documents. Then they will edit, copy and paste, and
find and replace text. They will also learn how to enhance the appearance of a document by using
various formatting options. In addition, they will create tables, adjust page layout, work with
graphics, use styles and outlines, and proof
and print documents.

 

MS Word · Intermediate

COURSE LENGTH: 7 HOURS
In this course, students will further build on the skills acquired in the Microsoft Word basic
course. Students will learn to use styles and outlines, and how to format tables. Then they will
insert SmartArt diagrams, work with shapes, and format text graphically. They will also learn how
to format a document by adding sections, columns, and design elements such as watermarks and
themes. In addition, they will use Track Changes and prepare documents for sharing and exporting.
Finally, students will learn how to work with fields and perform a mail merge.

 

MS Word · Advanced

COURSE LENGTH: 7 HOURS
This course covers advanced skills and concepts students need to use Microsoft Word productively
and efficiently. Students will learn how to work with fields and perform a mail merge. Then they
will insert SmartArt diagrams, work with shapes, and format text graphically. They will also learn
how to format a document by adding sections, columns, and design elements such as watermarks and
themes. In addition, they will learn how to use document references such as citations, indexes, and
tables of contents. They will use Track Changes and prepare documents for sharing and exporting.
Finally, they will add interactive elements such as forms and content from other applications, and
they will learn to work more efficiently in Word by customizing the ribbon, creating macros, using
building blocks, and inserting sub-documents.

 

MS Access · Basic

COURSE LENGTH: 7 HOURS
This course covers the basic skills and concepts students need to use Microsoft Access productively
and efficiently. After an introduction to the Access environment, students will learn how to plan
databases and create tables. Then they will learn to organize fields and records, and to work with
data entry rules. They will learn how to create basic queries, and how to work with forms and
reports.

 

MS Access · Intermediate

COURSE LENGTH: 7 HOURS
This course provides students with additional skills and concepts needed to use Microsoft Access
productively and efficiently. They will learn to normalize data, join tables while observing
referential integrity, query multiple tables, format forms and reports, insert background images
and charts; and create specialized objects such as lookup fields, sub-forms and sub-reports,
navigation forms, and calculated fields.

 

MS Access · Advanced

COURSE LENGTH: 7 HOURS
This course builds on the skills and concepts taught in Access-Intermediate. Participants will
learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import,
export, and link database objects; interact with XML documents; create hyperlink fields; optimize,
split, and back up databases; password- protect and encrypt databases; and set Access options and
properties.

 

MS PowerPoint · Basic

COURSE LENGTH: 7 HOURS
This course covers the basic functions and features of PowerPoint. After an introduction to
PowerPoint’s window components, students will open and run a presentation and switch between views.
They’ll create a basic presentation and add content; arrange, insert, and delete slides; and apply
templates and design themes. Then, they’ll learn how to create and edit shapes, insert and modify
WordArt objects and pictures, and work with tables, charts, and diagrams. Finally, they’ll learn
how to proof a presentation, create speaker notes, and present and share their presentations.

 

MS PowerPoint · Advanced

COURSE LENGTH: 7 HOURS
This course builds on the skills and concepts taught in PowerPoint Basic. Students will learn to
control global settings by using slide masters, and to apply effects such as transitions and
timings. They’ll learn more about working with images, and how to include media files, animation,
and a photo album in a presentation. Next, they’ll explore advanced tools for working with
SmartArt, tables, and charts, and then learn how to create action buttons and equations. Students
will also integrate other Microsoft Office files, embed and link external resources, and create
hyperlinks and much
more…

Contact us at wgtccorporatetraining@westgatech.edu or 706-756-4613 for more
information on business solutions for your organization.