View Site Map!
 AWC INDEX
a b c d e f g h i j k l m
n o p q r s t u v w x y z
Header Photo
Continuing Education
Web Advisor

SECTION LINKS

+ Continuing Education 


QUICK LINKS

Icon Web Advisor WebAdvisor/Register
Icon Class Schedule Schedule of Classes
Academic Library Academic Library
Course Catalog Icon Course Catalog
Tuition Icon Tuition & Fees
Blackboard Icon Blackboard
Directory Icon Directory
Webmail Icon Webmail
Webmail Icon Help

Computer TRAINING

These courses are scheduled throughout the year and also available for delivery. Group rates available. Email or call 928-317-6150 for a free quote!

Microsoft Access

Introduction: Work with and create the following:

  • Database files, definitions of objects, navigating tabbed documents, adding, deleting and editing records and fields, undoing changes
  • Datasheet windows, create, modify and sort tables, optimize data collection using masks,create a queryWork with the datasheet windows, create, modify, create a query
  • Forms and reports using wizard, group database objects, rename and delete groups, compact database files, customize and back up a database

Intermediate: 

  • Creating complex parameter queries using multiple tables, statistical queries, and manual reports
  • Creating and customizing forms and sub-forms
  • Importing and exporting data to and from Access
  • Merging data with a Word document
  • Setting and removing primary keys, table/query relationships, single and multiple field indexes, validating data, creating expressions with functions
  • Using sub-datasheets: inserting, expanding,collapsing, and removing

Advanced: This is a targeted skill level for those already proficient in the basics of Access. You will now visualize all the results you would like to achieve using its powerful, flexible, relational database engine.

  • Understanding Relationships
  • Advanced queries
  • Custom forms
  • Custom reports
  • Mail merge with Word
  • Macros
  • Visual basic 

Microsoft Excel

Introduction: Get a firm understanding of basic spreadsheet concepts to perform calculations and manage data lists. Covers entering, editing, and basic formatting of cells, text, formulas, and functions. Learn about cell ranges and references as well as simple formulas and functions using auto fill. Explore the chart and graph functions in Excel and proper printing guidelines.

Intermediate: This course covers worksheet protection, data validation and using the auditing toolbar. Explore inserting subtotals and using data outlines. You will manage multiple worksheets using formulas and explore data consolidation and linking. Create IF functions and nested IF functions to display data as well as insert comments in cells. Previous Excel experience is recommended.

Advanced (Shortcuts): This course has been developed to help you learn shortcuts to improve your skills and boost productivity. Useful tips include:

  • Navigate inside worksheets
  • Work with data selections
  • Insert and edit data
  • Format data
  • Formulas and names
  • Manage multiple worksheets
  • Manage multiple workbooks
  • Various Excel features
  • Data forms
  • Pivot Tables

Microsoft Outlook

This course presents the beginning concepts of Outlook. Outlook mail is great for your personal and business needs. You will receive information regarding the additional components of Outlook and how to integrate them together. Learn:

  • Calendaring
  • Email
  • Note taking
  • Personal information management
  • Tasks (to-do lists)

Microsoft Windows

Windows is an operating system that runs programs and your computer’s filing system. You will learn:

  • Control panel functions
  • Create files, folders & shortcuts
  • Desktop preferences
  • Keyboard tips

Microsoft Word

Introduction: Learn to produce professional looking documents by providing a comprehensive set of tools for creating and formatting your document. Gather and manage feedback from colleagues. Features demonstrated are:

  • Alignment
  • Basic formatting
  • Bullets/numbering
  • Cut/copy/paste
  • Headers/footers
  • Introduction to graphics

Intermediate: Assists you with the intermediate levels of this application. Formatting features covered in this workshop are:

  • Automatic formatting
  • Breaks – (paragraph and page breaks)
  • Changing defaults
  • Find and replace text
  • Indentation
  • Line spacing
  • Page layout- columns
  • Tables
  • Tabs
  • Various lists

Advanced: Mastery of advanced concepts of this application. Formatting features covered in this workshop are:

  • Document comparison
  • Embedding objects
  • Fill forms
  • Footnotes/endnote
  • Headings/bookmarks
  • Mail merge
  • Outlining
  • Page/ section breaks
  • Table of contents
  • Templates
  • Using and creating styles
  • Watermarks

Contact us continuinged@azwestern.edu for more information.

Future Students | Current Students | Distance Education | Community Partners | AWC Foundation
About AWC | Admissions | Financial Aid | Online Services | Athletics | Student Life | Employment
 © 2014 Arizona Western College Disclaimers | EEOC | Site Map | Comments