www.bpg.butlercc
|
Computer & IT Training
Our capacity to deliver customized computer training covers the gamut from workplace computer basics to advanced information technology skills. In addition to customized training specific to the needs of your organization, many of these classes are offered for public enrollment. Click here for a current schedule of public courses.
 Microsoft Windows
Prereqs: None
|
Designed to introduce participants to the basic concepts and features of Windows XP, they'll learn to navigate the Windows XP environment and save, open, and print documents in typical Windows applications. Topics include using the Help utility; customizing the desktop and taskbar; exploring multimedia features, including sound, video clips and audio CDs; managing files and folders with My Computer and Windows Explorer; creating shortcuts to customize the Start Menu and the desktop; using the clipboard to perform object linking and embedding operations; managing your system with tools (error-checking, disk cleanup, backup, system restore, disk defragmenter).
|
| Price: $129.00 |
Prereqs: None
|
This course teaches the core features and functions of Windows Vista. You will learn how to use the Start menu, move and resize windows, manage files and folders, work with the Sidebar and gadgets, and perform content searches. You will also create shortcuts, change system settings, and browse the Web with Internet Explorer 7.
|
| Price: $129.00 |
Prereqs: None
|
This course is intended to accelerate the transition from Windows XP or Windows 2000 and teaches those features and functions of Windows Vista that are new. You will learn how to work with the Sidebar, control gadgets, perform content searches, and browse the Web with Internet Explorer 7. You will also learn how to configure the Phishing Filter, view an RSS news feed, use Windows Meeting Space, scan for spyware, and more!
|
| Price: $129.00 |
Adobe Acrobat 7
Prereqs: Introduction to Windows XP
|
Participants learn how to share electronic versions of their documents with others, who may not have the software used to create them, by converting them to PDF. Sharing documents as PDF allows the implementation of electronic document review in which reviewers can add all their feedback directly to copies of a PDF document. Topics include navigating a PDF document, using bookmarks, links, searching, and exporting text and graphics; converting several types of documents to PDF; creating and batch processing PDF documents that are optimized for electronic use; arranging pages, adding headers and footers, customizing page numbering; creating interactive forms with text fields, predefined option fields, buttons, tables, and calculations; organizing PDF documents into document collections; and implementing a document review workflow, an email-based document review, or a browser-based review.
|
| Price: $159.00 |
Prereqs: Acrobat 7 Level 1
|
As a workplace professional with some experience using Adobe Acrobat, you're now ready to further develop your PDF documents. In this course, you'll use Adobe Acrobat 7® Professional to convert technical documents to PDF files, enhance and control PDF content accessibility, create and customize PDF documents for interactive use online, and create composite and color separation prints from a PDF document.
|
| Price: $159.00 |
Microsoft Office
Word
Prereqs: Introduction to Windows XP
|
Word Level 1 is designed to help you become proficient in creating, opening, formatting, saving, and printing documents. You'll explore and practice Word features including the Help system, document navigation, automated tasks, and editing techniques that help you change the appearance of a document by applying character formats, setting tabs, aligning paragraphs, and creating lists.
|
| Price: $129.00 |
Prereqs: Word Level 1
|
Designed for Word users who want to learn more features and functions such as creating columns and sections; formatting tables, importing table data, and applying styles; using the drawing canvas; creating templates; printing labels and envelopes; adding graphics, objects, and watermarks; and managing document revisions by change tracking.
|
| Price: $129.00 |
Prereqs: Word Level 2
|
This course teaches advanced-level functions and features of Word 2003 and 2007. Participants learn how to perform a mail merge, create and modify forms, work with large documents, and create macros. They'll also learn how to customize menus and toolbars, and they'll work with Word's XML-based features. Topics include using the Mail Merge task pane to create form letters, a data source, work with records, and create mailing-label documents; creating forms, modifying and rearranging fields in forms, protecting and printing forms, and discussing digital signatures; creating a master document that includes a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references, and Web frames; automating tasks by recording, running, modifying, copying macros, using macros in a form; and creating an XML document, attaching an XML schema, modifying XML options, applying a transform, and discussing smart documents.
|
| Price: $79.00 |
Prereqs: Introduction to Windows XP
|
Word Level 1 is designed to help you become proficient in creating, opening, formatting, saving, and printing documents. You'll explore and practice Word features including the Help system, document navigation, automated tasks, and editing techniques that help you change the appearance of a document by applying character formats, setting tabs, aligning paragraphs, and creating lists.
|
| Price: $129.00 |
Prereqs: Word Level 1
|
Designed for Word users who want to learn more features and functions such as creating columns and sections; formatting tables, importing table data, and applying styles; using the drawing canvas; creating templates; printing labels and envelopes; adding graphics, objects, and watermarks; and managing document revisions by change tracking.
|
| Price: $129.00 |
Prereqs: Word Level 2
|
This course teaches advanced-level functions and features of Word 2003 and 2007. Participants learn how to perform a mail merge, create and modify forms, work with large documents, and create macros. They'll also learn how to customize menus and toolbars, and they'll work with Word's XML-based features. Topics include using the Mail Merge task pane to create form letters, a data source, work with records, and create mailing-label documents; creating forms, modifying and rearranging fields in forms, protecting and printing forms, and discussing digital signatures; creating a master document that includes a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references, and Web frames; automating tasks by recording, running, modifying, copying macros, using macros in a form; and creating an XML document, attaching an XML schema, modifying XML options, applying a transform, and discussing smart documents.
|
| Price: $79.00 |
Prereqs: Windows, Word 2000 or 2003
|
This course is designed for experienced Word users who have worked with earlier versions of Microsoft® Word, ideally Microsoft® Word 2003, and who have upgraded to Microsoft Office Word 2007 In this course, you will be introduced to the commonly used new and enhanced features available in Microsoft Office Word 2007. Upon successful completion of this course, you should be able to: customize the interface to suit your requirements; use the tools available in Word 2007 to create professional looking documents that are visually appealing; compare different versions of a document; and finalize and secure your document before it reaches its target audience.
|
| Price: $79.00 |
Excel
Prereqs: None
|
This course teaches the basic functions and features of Excel. You'll learn how to enter and edit data, labels, and perform calculations like SUM, AVERAGE, MIN, and MAX in a worksheet; work with functions; format cells; print worksheets; create charts; and save a workbook as a Web page. This course is designed for those with little or no Excel experience.
|
| Price: $129.00 |
Prereqs: Excel Level 1
|
This course is designed for those with basic Excel knowledge who want to learn intermediate Excel features, such as customizing toolbars and menus; consolidating data; using advanced chart formatting options; sorting and filtering lists; using special formatting options; using templates; using error tracking features and protecting worksheets; sorting lists by columns; filtering lists based on complex criteria; formatting data points; creating combination charts and trendlines; adding and formatting graphic elements; using auditing features; adding comments and text boxes; and protecting a worksheet or part of a worksheet.
|
| Price: $129.00 |
Prereqs: Excel Level 2
|
This course covers advanced-level features and functions of Excel 2003 and Excel 2007. Participants learn how to create nested functions, export/import data, perform what-if analyses, use the Goal Seek and Solver utilities, record and run macros, and use SharePoint services. Topics include summarizing worksheet data by creating automatic subtotals; using the Data Validation feature to validate data entered in cells; using database functions to summarize list values that meet specified criteria ; using data forms to add data; using the PivotTable and PivotChart Wizard to create a PivotTable for analyzing and comparing large amounts of data; changing PivotTable view by moving fields and by hiding and showing details; improving the appearance of a PivotTable by changing its field settings and applying a format; and creating a PivotChart to graphically display data from a PivotTable; exporting data from Excel to a text file and importing data from a text file into an Excel workbook; importing XML data into a workbook and exporting data from a workbook to an XML data file; using Microsoft Query and the Web query feature to import data from external databases; recording and running macros to perform tasks automatically; assigning a macro to a button and using the button to run the macro; editing a macro by editing VBA code; creating a custom function to perform calculations when built-in functions are not available; publishing a worksheet as an interactive Web page; changing the source data; publishing a PivotTable as a Web page; adding fields to a PivotTable after publishing it by using a Web browser; using the Goal Seek and Solver utilities to meet a target output for a formula by adjusting the values in the input cells; installing and using Analysis ToolPak to perform statistical analysis; creating scenarios to save various sets of input values that produce different results; and creating views to save different sets of worksheet display and print settings.
|
| Price: $129.00 |
Prereqs: Excel 2003 Level 3
|
This course is designed to help experienced Excel 2003 users acquire advanced proficiency in using formulas, functions, arrays, and add-ins for manipulating and analyzing data. You'll learn to paste only certain parts of cell data; select cells containing particular kinds of data or formatting; use advanced formatting techniques; use built-in custom chart types to represent data in unusual ways; create user-defined chart types; use wizards to add commands and functions to Excel; use advanced Solver features; use various Analysis ToolPak tools to analyze data; embed and link objects in a worksheet; use AutoRecover, AutoCorrect, and smart tags; create custom lists; and more!
|
| Price: $139.00 |
Prereqs: None
|
This course teaches the basic functions and features of Excel. You'll learn how to enter and edit data, labels, and perform calculations like SUM, AVERAGE, MIN, and MAX in a worksheet; work with functions; format cells; print worksheets; create charts; and save a workbook as a Web page. This course is designed for those with little or no Excel experience.
|
| Price: $129.00 |
Prereqs: Excel Level 1
|
This course is designed for those with basic Excel knowledge who want to learn intermediate Excel features, such as customizing toolbars and menus; consolidating data; using advanced chart formatting options; sorting and filtering lists; using special formatting options; using templates; using error tracking features and protecting worksheets; sorting lists by columns; filtering lists based on complex criteria; formatting data points; creating combination charts and trendlines; adding and formatting graphic elements; using auditing features; adding comments and text boxes; and protecting a worksheet or part of a worksheet.
|
| Price: $129.00 |
Prereqs: Excel Level 2
|
This course covers advanced-level features and functions of Excel 2003 and Excel 2007. Participants learn how to create nested functions, export/import data, perform what-if analyses, use the Goal Seek and Solver utilities, record and run macros, and use SharePoint services. Topics include summarizing worksheet data by creating automatic subtotals; using the Data Validation feature to validate data entered in cells; using database functions to summarize list values that meet specified criteria ; using data forms to add data; using the PivotTable and PivotChart Wizard to create a PivotTable for analyzing and comparing large amounts of data; changing PivotTable view by moving fields and by hiding and showing details; improving the appearance of a PivotTable by changing its field settings and applying a format; and creating a PivotChart to graphically display data from a PivotTable; exporting data from Excel to a text file and importing data from a text file into an Excel workbook; importing XML data into a workbook and exporting data from a workbook to an XML data file; using Microsoft Query and the Web query feature to import data from external databases; recording and running macros to perform tasks automatically; assigning a macro to a button and using the button to run the macro; editing a macro by editing VBA code; creating a custom function to perform calculations when built-in functions are not available; publishing a worksheet as an interactive Web page; changing the source data; publishing a PivotTable as a Web page; adding fields to a PivotTable after publishing it by using a Web browser; using the Goal Seek and Solver utilities to meet a target output for a formula by adjusting the values in the input cells; installing and using Analysis ToolPak to perform statistical analysis; creating scenarios to save various sets of input values that produce different results; and creating views to save different sets of worksheet display and print settings.
|
| Price: $129.00 |
| Prereqs: Windows, Excel 2000 or 2003 |
| This course is designed for experienced Excel users who have worked with earlier versions of Microsoft Excel, ideally Microsoft Excel 2003, and who have upgraded to Microsoft Excel 2007. In this course, you will work with commonly used new and enhanced features in Excel 2007 that will help improve the management, presentation, and distribution of spreadsheets. Upon successful completion of this course, you should be able to: organize data in Excel worksheets using enhanced tables and table formats; analyze Excel data by applying enhanced conditional formatting, and generate specific information using the sort and filter options; present Excel data using enhanced charts and illustrations; and work with the enhanced options of PivotTables and PivotCharts for conducting selective analysis. |
| Price: $79.00 |
Power Point
Prereqs: Windows 98 or XP
|
In the past, you've used paper-based overhead systems to give presentations. Now, you want to upgrade those presentations to an electronic format. You can use PowerPoint 2003 or 2007 to give electronic presentations. You'll create effective presentations for delivery in front of an audience. Topics include: manipulating an existing PowerPoint presentation; creating a new presentation; formatting text slides; adding tables to a presentation; charting data in a presentation; modifying objects on slides; adding images to a presentation; and preparing to deliver a presentation.
|
| Price: $129.00 |
Prereqs: Windows 98 or XP
|
In the past, you've used paper-based overhead systems to give presentations. Now, you want to upgrade those presentations to an electronic format. You can use PowerPoint 2003 or 2007 to give electronic presentations. You'll create effective presentations for delivery in front of an audience. Topics include: manipulating an existing PowerPoint presentation; creating a new presentation; formatting text slides; adding tables to a presentation; charting data in a presentation; modifying objects on slides; adding images to a presentation; and preparing to deliver a presentation.
|
| Price: $129.00 |
Prereqs: Windows, PowerPoint 2000 or 2003
|
This course is designed for experienced PowerPoint users who have worked with earlier versions of Microsoft® PowerPoint, ideally Microsoft® PowerPoint 2003, and who have upgraded to Microsoft® PowerPoint 2007. In this course, you will work with the commonly used new and enhanced features available in Microsoft® PowerPoint 2007. Upon successful completion of this course, you should be able to: customize the interface to suit your requirements; identify and use the new and enhanced features of PowerPoint 2007 to create dynamic and visually appealing presentations; and finalize a presentation and secure it with a digital signature to authenticate its validity.
|
| Price: $79.00 |
Access
Prereqs: Introduction to Windows XP
|
Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, participants are introduced to the concept of the relational database by using the Microsoft® Office Access 2003 relational database application and its information management tools. Topics include modifying a table’s design; using the Find feature and the spelling checker; sorting, filtering, and deleting records; setting field properties; creating input masks; setting validation rules; creating single- and multiple-field indexes; creating queries, and sorting and filtering the results; modifying queries; performing operations in queries; creating, modifying, and working with forms; and using them to find, sort, and filter records.
|
| Price: $129.00 |
Prereqs: Access 2003 Level 1
|
Participants should have the basic skills needed to work with Microsoft Office Access 2003 databases. This includes working with Access tables, relationships, queries, forms, and reports. In this course, participants will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications. They will design and create a new Access database; improve queries, forms, and reports; and integrate Microsoft® Office Access 2003 with other applications. Topics include following the steps required to properly design a simple database; creating a new database with related tables; controlling data entry by modifying the design of a table to streamline data entry and maintain data integrity; finding and retrieving desired data by using filters and joins between tables and within a single table; creating flexible queries to display specified records; allowing for user-determined query criteria; and adding, updating, and deleting data with queries; enhancing the appearance, data entry, and data access capabilities of forms; customizing reports to better organize the displayed information; producing specific print layouts such as mailing labels; and using Access data in other applications, including Microsoft Word and Excel.
|
| Price: $129.00 |
Prereqs: Access 2003 Level 2
|
This course is designed for participants who wish to learn intermediate and advanced operations of the Microsoft® Office Access 2003 database program. The Level 3 course is for those whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. To ensure the successful completion of Microsoft® Office Access 2003 Level 3, we recommend completion of Level 1 and 2, or equivalent knowledge (familiarity with basic and intermediate features of Access tables, relationships, queries, forms, and reports) from another source.
Topics include restructuring an existing set of data to improve the design of a database; using a variety of techniques to summarize and present data with queries; creating and revising basic Access macros; creating macros that improve data entry efficiency and integrity; improving the effectiveness of data entry in forms; improving the effectiveness of data displayed in reports; and maintaining an Access database by using various utility tools.
|
| Price: $129.00 |
Prereqs: Access Levels 1-3 or equivalent experience
|
Access 2003 Level 4 is for those with a thorough understanding of the basic and advanced user features of the Access program who are interested in learning introductory level administrator skillsets. The course is also for those that work in a web-based environment and need to adapt Access applications to the environment. In this course, participants will be introduced to the advanced features of the Access application and also the VBA programming language. Participants learn remote database management, how to exchange data with XML and other types of applications, and how to automate business processes. Topics include developing a data access page, a PivotTable, and a PivotChart; importing XML data and exporting Access data; using VBA to automate business processes; creating and modifying a database switchboard, and setting and modifying startup options; distributing a database and adding security features to it.
|
| Price: $179.00 |
Prereqs: Windows XP or Vista
|
This first course in the series introduces new users to the concept of the relational database, used by many organizations to maintain and manage large amounts of information. You will learn how to design and create new relational databases, tables, and relationships; enter and update records; create queries to locate records; create data entry forms and produce reports based on the information in the database. This course provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.
|
| Price: $129.00 |
Prereqs: Access 2007 Level 1
|
In this second course in the series, users with basic Access skills will learn how to control and streamline data entry while maintaining data integrity, create flexible queries that allow for user-determined query criteria and modify data using queries, enhance the capabilities of forms, customize reports, and how to share Access data with other applications.
|
| Price: $129.00 |
Prereqs: Windows, Access 2000 or 2003
|
This course is designed for experienced Access users who have worked with earlier versions of Microsoft Access, ideally Microsoft Access 2003, and who have upgraded to Microsoft Access 2007. In this course, you will be introduced to the commonly used new features available in Microsoft® Office Access™ 2007. Upon successful completion of this course, you should be able to: explore the Microsoft Office Access 2007 interface; work with tables and forms; create queries and reports using the enhanced features of Access 2007; and work with external data.™
|
| Price: $79.00 |
Microsoft Project
Prereqs: Introduction to Windows XP and Project Management Fundamentals or equivalent experience
|
This course is the first in a series of two courses where you'll use Microsoft Project as a tool to manage projects. You'll learn the critical skills necessary to create and modify a project that contains tasks, resources, and resource assignments; create a work breakdown structure; assign project resources and resolve conflicts; print reports and update a project plan that has entered the project implementation phase. You should already have an understanding of project management concepts.
|
| Price: $199.00 |
Prereqs: Microsoft Project Level 1
|
This is the second course in the Microsoft Project series and builds upon the knowledge from the first course. You'll learn how to exchange project plan data with other applications, create and re-use custom tables, reports, views, and filters, build templates, share resources with multiple projects, work with master projects, and more!
|
| Price: $149.00 |
Web Design
Dreamweaver
Prereqs: HTML: Introduction
|
|
This course is designed to help you become proficient in using Dreamweaver to create web sites. Participants should already be familiar with basic markup (HTML and XHTML) and Cascading Style Sheets. You will learn how to plan and define a site; format text with basic structural elements; add visual impact to content with CSS and graphics; create hyperlinks and image maps; create data tables; and publish a web site.
|
| Price: $149.00 |
Prereqs: Dreamweaver: Introduction
|
This course is the second in a two-part series designed to increase your proficiency with Dreamweaver to create and manage Web sites that meet current web standards. Participants should be comfortable using the Dreamweaver interface to define sites and create basic web pages. You will learn how to use the positioning properties of Cascading Style Sheets (CSS) styles to layout Web page content, define content sections and apply ID styles, link and edit external style sheets, and work with Dreamweaver layers; create templates and libraries, and add keywords and descriptions; create interactive forms; create rollovers and apply JavaScript behaviors; add Flash elements and other multimedia content; and more!
|
| Price: $149.00 |
HTML
Prereqs: Introduction to Windows XP
|
This is the first of two courses designed to present the basics of Hypertext Markup Language (HTML), the foundation Web technology for creating Web pages. In this course, you will learn how to create a simple Web page; add structural elements like headings, paragraphs, and lists to content; work with graphics and create hyperlinks to local and remote web pages; use Cascading Style Sheets (CSS) to modify the appearance of text; and work with data tables. Participants should be comfortable working in the Windows environment and using a Web browser.
|
| Price: $149.00 |
Prereqs: HTML: Introduction
(HTML Level 1)
|
In this course, participants use HTML tables to lay out the contents of Web pages. Participants will create new and different kinds of hypertext links, expanding on their existing understanding of links between Web pages. They will create forms and add dynamic and multimedia content to pages in order to increase the interactivity and appeal of their Web pages. They will apply Cascading Style Sheets (CSS) formatting to elements in new ways and harness the true power of CSS by applying the same styles to multiple documents. Topics include positioning content on a Web page by using tables; creating links used to navigate and communicate; separating the stylistic elements of a Web page from its structure and apply Cascading Style Sheets (CSS) formatting to those elements; creating Web forms; and adding dynamic content to a Web page.
|
| Price: $149.00 |
Cascading Style Sheets
Prereqs: HTML Level 2
|
This course introduces you to the concepts, techniques, properties, and values of CSS. You'll learn to control color and typography; create style sheets that cascade according to established guidelines; design content sections using box properties; learn how to control your page layouts with positioning; enhance and existing design; and create alternate style sheets and link your pages to them in an order that enhances the accessibility and functionality of your Web sites. Participants must have a good working knowledge of HTML to attend this training.
|
| Price: $269.00 |
Publisher
Prereqs: Windows, Word
|
Microsoft® Publisher is an easy to use, flexible program for creating many types of publications including newsletters, brochures, and flyers. In this course, you will learn how to create a publication from scratch or use one of the many business and personal designs available in Publisher. This course was designed for persons with a basic understanding of Microsoft Word who need to learn how to use Microsoft® Publisher to create, layout, and edit publications. Topics include: creating a one-page publication; modifying a publication's layout and structure; editing content; formatting text and pictures; identifying distribution options; and more.
|
| Price: $239.00 |
QuickBooks
Prereqs: Windows 98 or XP
|
In this course, you'll be introduced to QuickBooks' basic features and will learn about the types of information needed to track business operations and enter that information and track it in QuickBooks. By the end of the course, you'll have a good idea of all that QuickBooks offers, you'll be familiar with the most common tasks, and you'll know where to find information about more advanced features.
|
| Price: $249.00 |
Information Technology
Prereqs: None
|
The Basic Fiber Optics Networking Course is designed for anyone interested in learning basic fiber optic networking and becoming a Certified Fiber Optics Technician. Additionally, the course assumes a basic working knowledge of computers, the ability to see and identify small items, and be able to speak and understand the English language.
See More
|
| Price: $700.00 |
Prereqs: Certified Fiber Optics Technician Courses (CFOT)
|
| The Advanced Fiber Optics Network Testing and Maintenance Course is designed for students who seek advanced training with the testing and maintenance of fiber optics networks. The course assumes knowledge covered in a CFOT or equivalent course within the preceding 6 months, or 1 year Fiber Optics related experience.
See More
|
| Price: $675.00 |
Prereqs: CFOT Course or other formal fiber optics training course within previous 6 months, or 1 year fiber optics related experience. If the student is not a CFOT registered with the FOA, he/she must pass the Basic CFOT Exam prior to registering for the Splicing Specialist (CFOS/S) certification with the FOA. If the student is successful in passing the CFOS/S exam after completion of this course and does not wish to be registered as a Specialist with the FOA, a Certificate of Completion will be issued. The student MUST be a member of the FOA as a CFOT prior to registering any Specialist Certifications sanctioned by the FOA. All exams are closed book.
|
This 2-day Splicing Specialist training highlights the importance of high performance splicing and further explains the points necessary to achieve them. An overview of OTDR functions and trace understanding is also provided. This 75% hands-on class will provide training in both fusion and mechanical splicing of single and multi mode fiber optic cables. Both inside and outside plant fiber optic cable types will be utilized along with inside and outside plant enclosures and splice trays. Participants will be responsible for successfully making and testing both single mode and multi mode mechanical and fusion splices as well as correctly and efficiently installing spliced fibers into splice trays and trays in enclosures. These enclosures will include rack and wall mounted splice enclosures and outside plant enclosures. In addition, participants will be required to achieve a splice loss of less than 0.15 dB for all splices and demonstrate proficiency in interpretation of splice loss using OTDR splice traces.
See More
|
| Price: $675.00 |
If the software you need is not listed, please call us at 316.218.6118. With our team of experienced trainers, we can offer classes in almost any software you need. We'll be happy to work with you to schedule additional classes.
|
