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 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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.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: $99.00 |
Prereqs: Access 2007 Level 2
|
Designed for those wishing to learn advanced operations of Microsoft® Access, in this course you’ll learn how to restructure table data to ensure data dependency and minimize redundancy, write advanced queries to analyze and summarize data, write macros to automate common tasks and improve data entry efficiency and integrity, display data more effectively in forms with controls and tab pages, create more effective custom reports, and perform general database maintenance. To ensure successful completion, 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).
|
| Price: $99.00 |
Prereqs: Access 2007 Level 3
|
Access 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: $99.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: None
|
This course is designed to help you become proficient in using Dreamweaver to create and manage Web sites that meet current web standards. Participants should already be familiar with basic markup (HTML and XHTML), and Cascading Style Sheets (CSS). 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. You will also learn how to define content sections, apply ID styles, and use the positioning properties of CSS styles to layout Web page content; link to and edit external style sheets; create templates and libraries; create interactive forms; and work with Spry widgets and elements, and more! To ensure successful completion, we recommend completion of Learning Web Design with XHTML & CSS, or equivalent knowledge.
|
| Price: $199.00 |
HTML
Prereqs: None
|
This course introduces the basics of Hypertext Markup Language (HTML), Extensible Markup Language (XHTML), and Cascading Style Sheets (CSS), the foundation Web technologies for creating Web sites. Whether you're just getting started, or need to understand the code generated by Dreamweaver or other WYSIWYG editors, this class will teach you how to use a simple text editor to create standards-based Web pages. You'll learn how to create and manage multiple page Web sites; add structural elements like headings, paragraphs, and lists to content; insert graphics and create hyper-links; use Cascading Style Sheets (CSS) to modify the appearance of page elements and create multi-column page layouts; and work with data tables and Web forms. Participants should be comfortable working in the Windows environment and using a Web browser .
|
| Price: $199.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: $99.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: $219.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.
|
