logo


816 28th Avenue, Suite 100 
Fairbanks, Alaska 99701 
Phone: (907) 452-7325 
Fax: (907) 452-6717 
Email: lisa@nsctraining.com 


Course Descriptons

 

Course Descriptions

 

Accounting Courses

QuickBooks Online (up to 9 Hours)
Recommended Prerequisite: Computer Basics
Price: $540 or 5 vouchers

After completing the QuickBooks course, you will be able to login online, create a new QuickBooks file and change account settings. Get practice with Online help. Create accounts, add, and edit items, and run reports on items. Add customers, create invoices, sales receipts, receive payments, and give refunds. Work with customer lists and add or change their information. Write checks and make deposits from QuickBooks. Learn to use QuickBooks to download transactions to bank accounts. Transfer funds and reconcile accounts. Learn to search for transactions, delete and void transactions. Learn to run various reports in QuickBooks. QuickBooks will show you where your money is coming from and where it’s going; let us help you get the most out of it!

QuickBooks Desktop Complete (up to 9 Hours)
Recommended Prerequisite: Computer Basics
Price: $540 or 5 vouchers

After completing the QuickBooks course, you will be able to create a new QuickBooks file from scratch or work with a pre-existing file. Learn to use forms, lists, and registers. Learn how to navigate through QuickBooks quickly and efficiently. Get practice with the help tool while using QuickBooks and learn to use the quick start center. Move between company files with ease and learn how to close QuickBooks. Create new companies and add company information, enter new accounts, also sub accounts with balances and tax account information. Add new vendors, customers, and jobs. Enter historical transactions. Create invoices, estimates and sales receipts for customer billing. Work with customers and job lists and add or change their information. Print out checks from QuickBooks.

Learn to use QuickBooks bank account register to track payments. Locate specific transactions with ease. Add company credit cards for tracking usage and to make payments. Record payments for single jobs or apply a single payment to multiple jobs. Learn how to receive payments, partial payments, prepayments and make deposits. Enter bills and pay them with QuickBooks. Create quick reports and learn how to print, edit, customize, and filter them. Also learn how to send reports to excel. Create purchase orders. Learn how to indicate and add taxes to items or services rendered. Add new employees and set up employee payroll with standard wages, overtime, and vacation/sick time. Print payroll checks from the comfort of your office. QuickBooks will show you where your money is coming from and where it’s going; let us help you get the most out of it!

Beginners

Computer Basics (up to 6 Hours)
Price: $215 or 2 vouchers

Students will learn the fundamentals of a computer. Learn how to start and log into windows, use the mouse and keyboard, the help and support, and turning your computer on and off properly. Learn how to use windows: opening, closing, resizing, moving, arranging and switching between windows. Learn how to use various programs: The menu, toolbar, controls, entering and editing a text. Opening, saving, selecting and replacing text. Using undo, redo, cutting, copying, printing, and getting help with a program. Learn about folders and files: Know what’s in your computer, learn how to: create, copy, move, open, and rename files and folders.

Know how to change the window layout and views. Learn how to customize: the taskbar, desktop, and windows. Learn about the free programs that come with windows. Understand how to use the internet: connecting, displaying, browsing, searching, downloading, using favorites, and the information bar. Learn how to use E-mail: Composing, sending, saving, deleting, forwarding, replying, adding contacts, printing, and controlling junk e-mail. These materials may vary slightly due to software upgrades and book updates.

Database Courses

Access Complete (up to 9 Hours)
Recommended Prerequisite: Computer Basics, Excel Unit 1
Price: $540 or 5 vouchers

This course introduces Access and discusses structure for good database design. Students will learn the fundamentals of Access: how to start, open, close, and understand the program screen, commands, and using help. The database basics, is working with database objects, selecting, cutting, pasting, adding, editing, deleting, and copying data, tour tables, forms, query, and reports. Also preview and print objects. Learn how to create and work with a database: plan, modify, sort, and convert; the database, tables, queries, and reports. Learn how to find, filter, and format data: Finding, replacing, sorting, creating, and changing the data, records, and forms. Understand how to use tables and fields: Use indexing, inserting, deleting, and recording fields. Learn to format text, numbers, currencies, and the date/time fields. We will show you how to validate data, optimize data type usage, input masks, and lookup fields.

Learn to create relational databases: Understand relationship tables, and how to print and delete them. Learn to work with queries: Create, summarize, display, locate, update, use crosstab, append, and delete queries. Generate single and multi-table queries and use the query wizard. Learn to work with forms and reports: modifying, grouping, changing, creating, and designing forms and reports. Learn how to work in layout and design view. Know how to insert a logo to forms. We will work with forms, explore form sections, bind controls and data, and work with calculated and other types of controls. Also understand how to format forms and reports: Changing colors, fonts, lines, alignments, and adding pictures and themes. Students will also learn about using macros: how to create, run, edit, and assign a macro. We will go over some advanced topics like how to import, export, compact and repair a database, and link information. Students will also learn how to use the hyperlink fields and discuss setting passwords.

Desktop Publishing Courses

Adobe Illustrator (up to 9 Hours)
Recommended Prerequisite: Computer Basics
Price: $540 or 5 vouchers

In this course, explore the Illustrator environment, navigate an Illustrator document, and use the Adobe Help Center. Learn to create a simple illustration; by creating and saving a new document, using the shape tool and keyboard shortcuts to create shapes, selecting shapes by using several techniques, and scale, duplicate, align and distribute, merge, group, rotate, and adjust the stacking order for shapes. Also learn how to export an illustration. Learn to apply basic color; use the Swatches palette and color palette to apply colors to shapes. Know how to save new colors in the Swatch’s palette. Learn to set basic stroke attributes for shapes and create a dashed line effect.

Understand how to use the eyedropper tool to sample colors and apply them to shapes. Learn to draw paths; import a raster image into a document using the place command, draw complex shapes and paths by learning to use the pencil, smooth, and pen tools. Know how to adjust paths by manipulating direction handles. Learn to use the average and join commands. Learn to work texts; adding text to an illustration by using the type tool, importing, and using the place command. Understand how to use the commands and text tools to convert, format, and position shapes to a path or outline. Learn to create, organize, duplicate, change stacking order, hide and lock layers using the layers palette.

Adobe InDesign (up to 9 Hours)
Recommended Prerequisite: Computer Basics
Price: $540 or 5 vouchers

Learn to create printable publications from one-page flyers to magazines and books. Learn to create new basic documents, text frames, placing and altering graphics and files. Also learn to place graphics and pages from other InDesign documents into your work. Know how to use objects; like how to position, modify, transform, and maintain proper object consistency. Learn to utilize the guides and control panel effectively. Learn about multi-page documents; like master pages, how to insert, delete, and move pages. Learn to create layers and assign objects to those layers. Know how to work with text; text formatting, different text styles and flows.

Learn to format text with tabs, indents, tracking, kerning, drop caps, and paragraph spacing. Use styles to format text and create bulleted and numbered lists. Learn to thread between text frames, add jump lines, set hyphenation and justification, add text wrap, vertical spacing, and keep options, and change the number of columns in a text frame. Understand how to use graphics and colors; how to adjust graphic formats, and create, apply, load, and save custom colors. Learn how to preflight documents, prepare them for final output, and how to export them to a PDF. Learn to prepare documents for commercial printing and printing booklets.

Adobe Photoshop (up to 9 Hours)
Recommended Prerequisite: Computer Basics
Price: $540 or 5 vouchers

In this course we will customize the Photoshop environment to appear the way you want; by magnifying and scrolling images; setting up rulers, guides, and grids. Understand the different file types, tool options, and export tool presets used in Photoshop. You will learn how to use various tools to select, modify, and manipulate image selections. You will create empty layers, create layers based on a selection, arrange, and move layers from one image to another. Transform layers by using commands, use type layers to add and format text, use opacity, and layer styles to apply effects to layers.

Learn how to make basic image adjustments by utilizing automatic adjustments to maximize image contrast, locate image shadows and highlights, and set target points. Learn to repair and retouch images; repair using the red eye, spot healing brush, and patch tools. Retouch images using burn, blur, content-aware move, clone stamp, and history brush tools. Learn to remove, erase, and filter images. You will learn how to resize and change canvas images using the crop tool and canvas size dialog box. Understand how to manage, import, navigate, and review folders and files in Bridge.

Publisher (up to 7 Hours)
Recommended Prerequisite: Computer Basics, Word Unit 1
Price: $540 or 5 vouchers

In this course we will learn how to start, close, save, delete, and navigate through Publisher. You will learn to create a new publication and add basic elements to a layout. Use the guides and the measurement task pane to position elements precisely. Learn to create a multi-page publication: by using a facing-page layout, inserting pages, and moving items between publications. Understand how to create master pages and apply them to a layout.

You will understand how to work with text; you will link and unlink text boxes and add continuation notices. Set tab stops, format paragraphs, control indents and spacing, and create drop caps. You will learn how to create, modify, and format tables. Learn layout and design techniques; positioning text in text boxes, applying text box styles and effects, and adding columns to text boxes. Learn to adjust and modify stacking orders, group items, and text wraps for pictures. Understand how to finalize a publication; export and print publications in PFD format, check spelling, design and prepare a publication for commercial printing.

Hospitality Courses

Hospitality Service Principles (up to 35 Hours)
Recommended Prerequisite: Computer Basics, Word Unit 1
Price: $1,150 (this class is not eligible for vouchers)

This course is designed to explore, challenge, and refine the principles of guest-services management in any service organization.  Hospitality service strategy, staff, and systems are discussed in depth through fourteen basic "service principles".  Section I of the course covers hospitality service strategy, including:  the guest knows best, meeting guest expectations through planning, setting the scene for the guest experience, and understanding the hospitality culture.  Section II of the course discusses the hospitality service staff and the importance of interacting with guests, developing a training program, serving with a smile, and empowering guests to help create their own experience.  Section III of the course discusses service systems, including:  communicating for service, delivery of great service, fixing service problems, striving for perfection in service, and leading others to excel.

Students will read the major works on the topic and apply the concepts to their own work experiences. The course will be run as a discussion group, with students accountable for reading the assigned material prior to class and coming to class prepared to discuss the meaning and implications of the assigned readings.  Students will also submit written assignments and special projects.

Human Resource Courses

The Basics in Human Resouces (up to 18 Hours)
Other Recommended Classes: Computer Basics, Excel, Outlook, Word & QuickBooks
Price: $960 (this class not eligible for vouchers)

Learn how to create a personnel file. Learn what paperwork might go in a personnel file and how to track what is in the file. The student will learn that during the process of hiring an employee there is a series of paperwork that is shuffled from the employer to the employee and sometimes to other agencies and how to keep track.

Learn how to conduct productive interviews. Learn to prepare and set the tone of the interview. Learn how to use effective communication techniques when interviewing. Learn about the top six kinds of questions that should be included in your interviews and know the top 10 mistakes interviewers make. Understand how to word and sequence your questions to get the most out of an interview. What are inappropriate questions, including those that are not permissible according to the law. Learn how to conduct and control an interview.

Learn the fundamentals of conducting a meeting; having a purpose, plan, participation, and knowing how to open and close a meeting. Learn how to manage a meeting; the role of the leader, decisions, and ideas, eliminating group think. Learn how to deal with conflict, difficult personalities, and a negative atmosphere in meetings. Understand what steps to take to have a positive meeting. Identify how to have clear communication with participants of a meeting and know what communication styles to avoid. Learn the common barriers to effective listening and learn the steps to become an active listener. Learn about the four types of questions that are helpful in conducting an effective meeting. Understand how to avoid and improve nonverbal communication in your meetings.

Learn the task of dealing with difficult employees; those who often come in late, don't work hard, procrastinate, or keep morale low. You will learn how to determine the causes of employee performance problems and learn what interventions steps to take. Rather than dictate performance changes, learn how to give constructive feedback to help employees improve work ethic and morale. A six-step Intervention Model will offer good suggestions about communication, a plan of improvement, and problem resolution. The Intervention Model also shows how to deal effectively with discipline and termination situations. All employee performance issues, including management responsibility, are discussed in detailed case studies.

Learn the principles of time management; productivity cycles, setting goals, and prioritizing. Learn how to create effective daily plans that will help avoid obstacles. Learn how to use technology to save time. Learn how to identify unnecessary information overloads, know how to control your paperwork, and increase your productivity. Understand how to handle meetings and interruptions without affecting your productivity. Come find out how you can maintain a reasonable workload and manage your time.

Basic SHRM (Society of Human Resource Management) Skills (up to 18 Hours)
Other Recommended Classes: Computer Basics, Excel, Outlook, Word & QuickBooks
Price: $960 (this class not eligible for vouchers)

Learn from materials based on the SHRM-CP and SHRM-SCP Exams.

Learn from several materials that include sample test questions. Get an understanding of what you would expect in subject matter when testing, if you so desire to test.

Learn about Leadership & Navigation. Learn about different leadership styles and techniques. How to navigate the organizational hierarchy, processes, systems, and policies.

Learn how the HR Vision is different in organizations. How to embrace the vision and support the values, mission, and goals. Implementation of policies and procedures and how they differ.


Other Topics:

  • How does HR influence employees and colleagues
  • Learn the principles of Ethical Practice
  • Discuss Diversity, Equity & Inclusion
  • Relationship Management & Networking
  • Relationship building, Teamwork, & Negotiation
  • Conflict Management, Communication, & Listening
  • Business and Competitive Awareness
  • Business Analysis, Designing HR Solutions, & Change Management
  • Talent Acquisition, Employee Engagement & Retention, and Learning & Development
  • Workforce Management, Employee & Labor Relations, and Risk Management
Job Readiness Skills

Job Skills (up to 6 Hours)
Price: $540 or 5 vouchers

This course helps students prepare for interviews and create a resume. Learn how to prepare for an interview by dressing appropriately, knowing when to arrive, knowing what employers look for, and learn common mistakes job seekers make in an interview. Sample interview questions and exercises will be given. Learn how to decipher classified advertisements, structure responses, negotiate salary and compensation, and how to follow up after the interview is over.

Customer service, telephone skills, and staying organized are critical components of a successful business. Learn to interact with the public in person and over the telephone. Discover skills for dealing with angry customers and tactics for keeping your composure in stressful situations. We’ll show you how to improve your telephone etiquette; placing customers on hold, transferring callers, voice mail, and working with challenging callers. Maintain and organize files and records properly and make your filing system work for you.

We will review the resume writing process. We will work with Microsoft Word to create or improve a resume, and you will receive a copy to take your resume with you when it is completed for future updates. Learn how to gather information for your resume; evaluate goals and personal characteristics. Select a format, stay consistent in style, and work with section headings. Finished resumes will be evaluated by the instructor. Different ways to submit your resume will be discussed including mailing, hand delivering, and submitting on the web.

Typing (up to 6 Hours)
This course includes software for you to keep!
Price: $215 or 2 vouchers

This course is an interactive course. A pretest is given to evaluate skills; there are progress tests at the end of each exercise, and a final typing test to measure overall improvement. Typing instructions are on a computer keyboard. We will show you proper finger placement, body posture, how to navigate the keyboard, and finger key assignments. Learn tips for increasing your accuracy and speed.

Medical Coding and Terminology

Medical Office Practice (up to 26 Hours)
Recommended Prerequisite: Computer Basics
Price: $1,075 (this class not eligible for vouchers)

This course introduces the student to the medical office. Students will have hands-on experience with actual correspondence, forms, and medical reports selected from the files of practicing physicians. Experience a realistic medical office atmosphere. Learn about HIPAA and the importance of a confidential statement. Learn about administrative functions; making schedules in MOSS, filing procedures, preparing patient files, scheduling regular and specialty appointments, registering patients, looking up patient appointments, creating patient appointment lists, making patient reminder calls, researching drug information, creating travel itineraries, making a physician’s schedule, ordering supplies and making purchase orders, manually making appointments, revise a patient information brochure, and proofreading and preparing final copies from drafts.

Practice basic financial procedures; posting on day sheets, computerized procedure, and payment postings, posting adjustments, collections, and issuing refunds. Understand the concepts of effective communication; taking phone messages, transcriptions, making referrals, scheduling admissions to hospitals, and preparing patients for procedures. Learn how to process insurance claims, enter procedural and diagnostic codes, prepare occupational exposure incident reports, understand how to use material safety data sheets and request for a release of medical information. Learn about employee payroll; completing work records, preparing and proving totals on payroll register. Medical Office Simulation Software is included for students to gain proficiency in working in simulated Practice Management software.

Step-by-Step Medical Coding (up to 18 Hours)
Price: $1,617   Includes Courseware & Coding Books (this class not eligible for vouchers)

Introduction to medical coding, students will learn about the HCPCS, CPT, ICD-9-CM, and ICD-10-CM codes. Students will learn the basic structure of the Medicare Program; be able to distinguish among Medicare parts A, B, C, and D. The health insurance portability and accountability act; be able to interpret HIPAA, locate information in the federal register, be able to explain the outpatient resource-based relative value scale (RBRVS), understand the framework of the Medicare fraud programs, and identify the major components of managed health care. Students will learn about the development and improvements of the ICD-10-CM. Know how the ICD-10-CM replaces the ICD-9-CM. Understanding the ICD-10-CM; the format, structure of the system, mapping, the index, tabular, and instructional notations. Understand outpatient coding and reporting guidelines.

Learn how to properly use the ICD-10-CM and chapter-specific guidelines; understand how to use specific chapters for specific codes. Understanding and using the ICD-10-CM; the format, index, coding and reporting guidelines, and the chapter-specific guidelines. An introduction to the CPT (Current Procedural Terminology) and HCPCS (Healthcare Common Procedural Coding System) codes. Understand the purpose of modifiers; know how to recognize and assign modifiers. Understand how to use the Evaluation and Management (E/M) codes; know the three factors, the various levels, and analyze the types of E/M codes. Understanding Anesthesia types. Learn about surgery guidelines. Learn about the Radiology, Pathology/Laboratory, and Medicine codes and formats. Learn the differences between inpatient and outpatient coding. Also learn where to find online resources.

Professional Development

Effective Business Writing (up to 9 Hours)
Price: $320 or 3 vouchers (vouchers can only be used for classes on the regular schedule)

Though businesses increasingly rely on technology, technological skills alone do not guarantee success in the workplace. You must still develop your ideas, express them clearly, and persuade others of their viability. This course offers effective strategies to sharpen your writing skills by structuring your ideas logically, exercising diplomacy in letters and reports, and shaping your arguments.

Advanced Business Writing (up to 15 Hours)
Price: $540 or 5 vouchers (vouchers can only be used for classes on the regular schedule)

This course includes all the material covered in our Effective Business Writing class, and takes it a step further.  It is geared toward people who have the responsibility to write business documents that help support the goals of their company. In order to successfully create a variety of business documents, you need to thoroughly understand which documents work best for specific situations and how to produce them. In this course, you will learn how to choose the best document to use and prepare to write the document to help you achieve your business goals.

Conducting Interviews (up to 6 Hours)
Price: $160 or 2 vouchers (vouchers can only be used for classes on the regular schedule)

In this course learn how to conduct productive interviews. Learn what are the best settings, formats, and appropriate duration of an interview. Know about the differences between informal, conversational, standardized, closed, and general types of interviews. Learn how to use effective communication techniques when interviewing.  Learn about the top six kinds of questions should be included in your interviews, and know the top 10 mistakes interviewers make. Understand how to word and sequence your questions to get the most out of an interview. Know the provisions outlined by EEO and identify appropriate and inappropriate questions, including those that are not permissible according to the law. Learn how to conduct and control an interview. Identify the follow-up tasks that should be performed after an interview.

Conducting Meetings (up to 3 Hours)
Price: $105 or 1 voucher (vouchers can only be used for classes on the regular schedule)

In this course you will learn the fundamentals of conducting a meeting; having a purpose, plan, participation, and knowing how to open and close a meeting. Learn how to manage a meeting; the role of the leader, decisions and ideas, eliminating groupthink. Learn how to deal with conflict, difficult personalities, and a negative atmosphere in meetings. Understand what steps to take to having a positive meeting. Identify how to have clear communication with participants of a meeting and know what communication styles to avoid. Learn the common barriers to effective listening and learn the steps to become an active listener. Learn about the four types of questions that are helpful in conducting an effective meeting. Understand how to avoid and improve on nonverbal communication in your meetings.

Dealing with Difficult Employees (up to 6 Hours)
Price: $160 or 2 vouchers (vouchers can only be used for classes on the regular schedule)

This course will teach supervisors and managers to face the task of dealing with difficult employees; those who often come in late, don't work hard, procrastinate, or keep the morale low. You will learn how to determine the causes of employee performance problems and learn what interventions steps to take. Rather than dictate performance changes, learn how to give constructive feedback to help employees improve work ethic and morale. A six-step Intervention Model will offer good suggestions about communication, a plan of improvement, and problem resolution. The Intervention Model also shows how to deal effectively with discipline and termination situations. All employee performance issues, including management responsibility are discussed in detailed case studies.

Sexual Harassment (up to 6 Hours)
Price: $160 or 2 vouchers (vouchers can only be used for classes on the regular schedule)

Learn the legal definition of sexual harassment and the effects it can have in your workplace. Understand the legal liabilities an employer has if an employee is being sexually harassed by a non-employee. Be able to identify behaviors that constitute sexual harassment, know how to prevent it in the workplace, and how to respond. Understand how to handle personal conversations in the workplace. Assess the need for a sexual harassment policy in your workplace.

Time Management (up to 6 Hours)
Price: $160 or 2 vouchers (vouchers can only be used for classes on the regular schedule)

Learn the principles of time management; productivity cycles, setting goals, and prioritizing. Learn how to create effective daily plans that will help avoid obstacles. Learn how to use technology to save time. Learn how to identify unnecessary information over loads, know how to control your paperwork, and increase your productivity. Understand how to handle meetings and interruptions without affecting your productivity. Come find out how you can maintain a reasonable workload and manage your time.

Presentation Courses

PowerPoint Complete (up to 7 Hours)
Recommended Prerequisite: Computer Basics, Word Basic
Price: $430 or 4 vouchers

In this course you will learn how to create a complete presentation from start to finish. You will learn the program fundamentals and how to understand the screen, create a blank presentation or from a template, and open a presentation. Learn the difference between save and save as in new file formats. You will learn how to navigate a presentation, print preview, and how to specify printing options. See how to Customize the Quick Access Toolbar. Understand how to Share a Presentation.

Get familiar with Help and how to Work with Presentations. Add and Lay Out Slides, insert a New Slide, Change the Slide Layout, insert a Specific Slide Layout, and Delete a Slide. Add Slides from an Outline or from Another Presentation. Understand how to Cut, Copy, and Paste as well as Undo and Redo. Turn on the Notes Pane, Enter Slide Notes, View the Notes Page, and Print the Notes Page. Learn to format text, change fonts and their size as well as the color and apply text effects. Change the font case and align text. Format lists and columns. Work with hyperlink text or Images. Copy Formatting and work with slide background.

Scheduling Courses

Outlook Complete (up to 6 Hours)
Recommended Prerequisite: Computer Basics
Price: $320 or 3 vouchers

This course will show you how to effectively utilize Outlook in your workplace. Understand the fundamentals; opening and exiting Outlook, the program screen, items, message windows, commands, shortcuts, the navigation pane, reading pane, to-do bar, and using help. Learn how to compose and send emails; specifying message options, formatting text, check your spelling, working with hyperlinks, and attaching files to your messages. Understanding receiving email; receiving and reading, replying to and forwarding, opening attachments, deleting, flagging, view and manage messages, sorting, and printing messages.

Learn about email features; saving unfinished messages, recalling, and resending, using Quicksteps, inserting a signature, dealing with junk e-mails, using the safe and blocked senders list, and inserting screenshots. Learn how to add, delete, edit, sort, and organize your contacts. Use the calendar to schedule appointments and events, set reminders, availability, collaborate and customize your calendar. Work with tasks; adding, changing, sorting, updating, attaching, assigning, and printing tasks. Learn how to use the journal and notes. Use Outlook to manage data information. Customize your Outlook; the ribbon, quick access toolbar, autocorrect, groups, the default options, and accounts. Learn how to use Outlook to organize and find information efficiently.

Project (up to 6 Hours):
Recommended Prerequisite: Computer Basics
Price: $540 or 5 vouchers

In this course you will learn how to efficiently utilize Project in your workplace. Learn the fundamentals of Project; planning the project, understanding Project Management and the Database, the screen, views, creating new Projects and calendars, printing views and reports, and using the Project Guide. Understand how to use the task list; entering a milestone, entering tasks, time durations, linking, editing, notes, hyperlinks, moving and copying, inserting, and deleting, using the Dialog Box, and organizing all your tasks. Understand how to enter and assign resources; like people, equipment, materials, and know how to adjust and assign schedules. Learn how to sort, group, and filter your Projects. Understand how to overlap, delay, set deadlines, and constraints to tasks.

Learn how to enter pay rates, overtime rates, adding pay, and setting fixed costs. Balance your Project resources easily by entering over allocations manually or automatically. Be able to update areas of your Project Progress by updating the entire project, by completion percentage, by actual work, or by actual cost. Learn how to check Project Progress by viewing statistics, costs, and the path of a project. Learn how to create, open, add, sort, and define contents of a report. Understand how to work with multiple Projects by consolidating, linking, and viewing between Projects. Learn how to use Project to organize all your Project needs.

Spreadsheet Courses

Excel Basic & Intermediate (up to 9 Hours)
Recommended Prerequisite: Computer Basics
Price: $540 or 5 vouchers

This is designed to teach you the fundamentals of Excel; starting Excel, understanding the screen, opening workbooks, saving, and closing a workbook, previewing, and printing worksheets, and using help. You will learn how to navigate worksheets, enter labels and values, select, and enter data into cells, enter formulas and content. Understand how to edit and format worksheets; editing, copying, moving, deleting, finding, and replacing, inserting, and using undo/redo. Understand how to work with multiple worksheets; selecting, inserting, deleting, splitting, and freezing, renaming, moving, and hiding worksheets.

You will learn to create, edit, add, remove, change layouts, labels, gridlines, and using charts. Learn how to create headers and footers and know how to print certain areas or certain pages. Learn all about intermediate formulas and functions; absolute references, and conditional formatting. You will learn about Data Ranges; how to sort and filter either by colors, icons or columns, learn how to create a custom auto filter, and know how to use an advanced filter. Using Tables; learn to create a table and add or remove data from it, sort, filter, format, and use Data Validation. You will learn how to protect cells and workbooks.

Excel Advanced (up to 6 Hours)
Recommended Prerequisite: Computer Basics, Excel Basic & Intermediate
Price: $540 or 4 vouchers

This is designed to teach you the advanced features of Excel. Understand how to create, use and change PivotTables; insert a PivotTable, filter and sort a PivotTable, add grouping, update, and format a PivotTable. Learn how to customize themes. You will learn to turn on the developer tab and insert a form control. Learn to troubleshoot formulas and how to customize conditional formatting and how to manage it. You will learn some advanced formulas; IF functions, Nested functions, SUMIF functions and more. Analyze Data using goal seek and consolidate data. Understand how to record, play, edit, and delete a macro.

Training Vouchers

We offer training vouchers to save you money with volume discounts . For a complete listing download our catalog.


Website Design Courses

Adobe Dreamweaver (up to 9 Hours)
Recommended Prerequisite: Computer Basics
Price: $540 or 5 vouchers

In this course we will discuss basic internet, HTML, and XHTML concepts along with learning the components of Dreamweaver CS6 workspace. Learn how to plan, create, and set-up web pages and sites. Understand how to manage your website and website files. Learn how to edit your site; inserting and importing texts, using special characters, adding structure, and creating lists. Understand the basics of CSS (cascade style sheets); know how to create external style sheets, define and apply element styles to texts as well as use class styles. Learn how to work with images, multimedia, and links; like adding graphics, placeholders, rollovers, and defining image attributes. 

Learn to edit images in Dreamweaver, and in an external image editor. Learn how to add multimedia to a webpage using Flash SWF and FLV files. Be able to use hyperlinks, and connect webpages by creating internal and external links. Understand and work with basic codes like HMTL, XHTML, and HTML5. Be able to define a websites keywords and description in the <head> section.  Learn to use the Code Navigator and tag selector to select code elements. Add and modify code in Code View by using the Code Toolbar. Understand how to add and edit HTML tags with the Quick Tag Editor. Learn about performing pre-publishing checks, and finalizing a website to be published by checking downloading time, spelling, and links as well as cloaking files. Learn how to transfer files to a remote server.

Expression Web (up to 9 Hours)
Recommended Prerequisite: Computer Basics
Price: $540 or 5 vouchers

Discuss basic Internet and Web concepts, plan the design and structure of a site, create a new one-page site and add folders and pages, create templates, and apply a template to pages.  Import content into a page, convert line breaks to paragraph breaks, insert non-breaking spaces and symbols, apply structural tags, create lists, create an external style sheet, and establish element and class styles.  Define content sections; create and apply ID styles; apply margins, padding, and borders to an element; create a two-column layout; and control wrapping.  Discuss image file formats, adjust image properties, apply alternate text, and arrange images.  Create links, navigation bars, e-mail links, and bookmarks, customize link styles, create image maps, and link hotspots.  Insert and format tables, rows and columns, create table captions, and work with nested tables in a table. 

Check for spelling errors and broken hyperlinks in a site, identify publishing options, and publish a website. Students will learn to author compliant webpages and choose the right XHTML doctype for your websites. Understand how to use code snippets; correct code and errors, and use IntelliSense to prevent code errors.  Create rollovers and apply behaviors.  Work with layers and create dynamic layers.  Create layout tables and layout cells to build a page layout and apply basic formatting options to layout tables and cells.  Create forms and insert and modify a variety of input fields, create a basic ASP.NET form, and apply ASP.NET input validation controls.  Discuss the basics of dynamic websites; the database connectivity, creating master pages, attaching content pages to a master, and inserting an XML Data View in a webpage.  Apply basic search engine optimization; check for browser compatibility problems, unused and undefined CSS styles, redirecting a browser to an alternate version of a page, optimize a site using Reports, and locate, understand, and fix accessibility problems.

Flash (up to 12 Hours)
Recommended Prerequisite: Computer Basics
Price: $430 or 4 vouchers

In this course students will learn the fundamentals of Flash, its interface, and be able to identify the components and capabilities of Flash CS3 and the files it generates with an application. Learn how to work with basic objects: creating new files from a template, set stage properties, import images into a Flash file, create, format, and manipulate drawing objects and shapes.  Work with the Timeline; adding frames, keyframes, and using layers to manage content in a Flash application. Learn to format objects and create the Soften Fill Edges command to create custom colors and gradients and use a filter to create soft edges for objects.

Use the Timeline animation to create simple frame-by-frame animations, motion tweened animations, and looping animations. Understand how to use the interactive components to create static, rollover, and invisible buttons. Learn how to use the ActionScript code and ActionScript buttons to control music in an application. Understand how to publish a Flash application as a SWF file or insert it into a webpage. Create content that is accessible to screen readers. Test Flash applications to verify that they load in a browser within a reasonable timeframe.

Word Processing Courses

Word Basic & Intermediate (up to 9 Hours)
Recommended Prerequisite: Computer Basics
Price: $540 or 5vouchers

In this course, you will learn how to navigate documents, enter text, and save files. We will show you shortcuts to select text, work with toolbars and menus, use the Office Clipboard, and learn features such as drag-and-drop, find and replace, spell and grammar check. Learn to change fonts, font attributes, align text, and apply character effects. Add pizzazz to your document by using borders and shading, bullets and numbering, and by adding graphics to your page. Learn to use headers and footers and date and time placeholders. Learn about format painter, a quick technique for copying formatting. See how to work with multiple views of your document. To make sure everything is aligned properly, learn how to set margins, indents, print settings, and view non-printing characters. We will work with page setup, borders and shading, and symbols. Save time by using AutoText and AutoCorrect. We’ll set up tabs, automatic page numbering, and styles. Learn how to insert text from another file, work with breaks and spacing, indents, columns, sections, and outline numbered lists. Use and modify graphics, set graphics options, and work with the drawing toolbar and text boxes.

You will insert tables into our document, work with the cells, and change formatting. Prepare and print letters, envelopes, and labels individually or from lists using mail merge. Prepare documents for the Web and create hyperlinks. Learn how to work with different footer sections and explore styles. We will utilize footnotes and endnotes, fields and cross-references, and build an index and table of contents. Discover how to modify paragraphs, change headers and footers, work with text and columns, and use graphics. Learn to use master documents, work with expanded and locked documents, rearrange subdocuments, and split and merge subdocuments. Insert page breaks and set paragraph formatting. Use revision tools, collaborating with work groups, and using the track changes feature. Work with forms and set form options. We’ll show you how to create and run macros.

Return to top of page