CLASS SCHEDULE - Computer Training Classes

CLASS SCHEDULE DECEMBER 2019 to MAY 2020

Training in:

Excel, Access, Project Management Professional

(PMP)?, PowerPoint, QuickBooks,

Photoshop, InDesign and many more...

(Project Management Professional (PMP) and Certified Associate in Project Management (CAPM) are registered trademarks of the Project Management Institute. All other product names, logos, and brands are property of their respective owners. )

VeVrseiorsnio1n0.1

TABLE OF CONTENTS

Microsoft Classes

Page

Access........................................................4

Excel...........................................................3

Outlook....................................................6

PowerPoint..............................................5

Project.......................................................7

Windows..................................................4

Word..........................................................5

SharePoint................................................7

Adobe Classes Photoshop...............................................9 InDesign....................................................8 Illustrator..................................................9 Acrobat.....................................................8

Web Classes CSS............................................................. 11 HTML.........................................................7 MySQL...................................................... 11 Online Marketing................................10 JavaScript................................................. 12 WordPress...............................................10

Project Management Classes PMP?.......................................................... 12 Agile........................................................... 13 ITIL.............................................................. 12 Six Sigma.................................................12 Business Analysis................................. 13 SQL Queries..........................................14 Data Analytics.......................................14 Tableau..................................................... 13

QuickBooks Classes QuickBooks.............................................6

Longer Training Programs WIOA & TAA Programs..................14-18

Instructors

Our instructors are chosen for their knowledge of the software they are teaching as well as their ability to present topics in a clear and concise manner. All instructors are tested before beginning teaching. Our instructors have years of software experience and are patient and knowledgeable. Our instructors consistently receive the highest evaluations from their students.

Student Materials

Student manuals are easy-to-follow and are loaded with practical exercises. Many of our student manuals are Microsoft, Adobe, or QuickBooks approved. All exercise files are provided, and can be accessed online at anytime. Students will receive a Certificate of Completion for each of their classes.

On-Site Training

If you have an appropriate training room, we can conduct training sessions at your location. We can customize the topics to cover the features you need. We have pricing for half-day and fullday On-site classes. Discounts are available for multiple On-site classes. Ask us about supplying computers!

Private Classes & Tutoring

If a group of employees at your organization needs customized training or you need individual training with an instructor, we offer private classes and tutoring! Private training can be done at one of our training centers or at your location. Just call and we can tell you about availability.

Training Room Rental

If you have your own instructor and need a professional computer training room environment, our computer training labs are available for rent. Our conveniently located training facilities can be an economical place to hold your training session.

Free Repeats And After Class Support

Our classes are limited to small groups so that students receive personal attention from their instructor. Free telephone or email support for thirty days is included with your training. Satisfaction guaranteed! Any class you take can be repeated at no charge (as long as there is a seat available in the class you request). Classes can be repeated within six months of the original class date.

TRAINING COUPONS

Business Coupons

Buy a book of Business Coupons to send students to our regularlyscheduled business software classes. One coupon is good for one regularly-scheduled class from the list below.* Coupons can be used by different people in your organization. Save up to 41%!

Creative Coupons

Buy a book of Creative Coupons to send students to our regularlyscheduled creative software classes. One coupon is good for one regularly-scheduled class from the list below.* Coupons can be used by different people in your organization. Save up to 33%!

Coupons are good for one year from purchase date. 10 Coupons ? $2,790 25 Coupons ? $6,500 50 Coupons ? $12,250

Coupons are good for one year from purchase date. 10 Coupons ? $3,190 25 Coupons ? $7,500 50 Coupons ? $14,00

* Please note that the `Business Coupons' can be used for the following classes: Introduction to Windows, Word, Excel and Access (Introduction, Intermediate, or Advanced), PowerPoint and Outlook: Introduction or Intermediate, QuickBooks Pro: Part I, Part 2 or Part 3, SharePoint Part 1 or Part 2..

* Please note that the `Creative Coupons' can be used for the following classes: Adobe classes (Photoshop, Illustrator, InDesign, Acrobat), HTML classes, CSS classes, WordPress classes or Internet Marketing classes.

DECEMBER 2019 - MAY 2020

2 WWW.

MICROSOFT EXCEL

Excel Part 1

Learn to move and copy data, about absolute and relative references, and work with ranges, rows, and columns. Also, how to navigate worksheets and workbooks, enter and edit text, values, formulas, and pictures. This course also covers simple functions used in formulas, basic conditional formatting techniques, and how to create and modify charts.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $299

Tues., Dec. 10 Thurs., Dec. 26 Sat., Jan. 4

Mon., Jan. 27

Tues., Feb. 11 Wed., Feb. 26 Thurs., Mar. 12 Fri., Mar. 27

Mon., Apr. 13 Tues., Apr. 28 Wed., May 13 Thurs., May 28

SCHAUMBURG- Weekdays/Saturadys 9am - 4pm (One Day) - Fee: $299 Mon., Dec. 16 Tues., Jan. 7 Wed., Jan. 29 Thurs., Feb. 20 Sat., Feb. 29 Mon., Mar. 16 Tues., Apr. 7 Wed., Apr. 29 Thurs., May 21

NAPERVILLE- Weekdays 9am - 4pm (One Day) - Fee: $299

Tues., Jan. 14 Wed., Feb. 5 Mon., Mar. 2 Mon., Mar. 23

Tues., Apr. 14

Fri., May 8

NAPERVILLE- Evenings 6:30pm - 9:30pm (Two Days) - Fee: $299 Mon., Mar. 2 and Wed., Mar. 4

Excel Part 2

Work with PivotTables and PivotCharts in this class. Use multiple worksheets efficiently, learn more advanced formatting options, and sort and filter data. Also learn how to create outlines and subtotals and how to work with tables. Along with, advanced charting techniques and worksheet auditing and protection.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $329

Wed., Dec. 11 Fri., Dec. 27

Sat., Jan. 11

Mon., Jan. 13

Tues., Jan. 28 Mon., Mar. 30 Fri., May 29

Wed., Feb. 12 Tues., Apr. 14

Thurs., Feb. 27 Fri., Mar. 13 Wed., Apr. 29 Thurs., May 14

SCHAUMBURG- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $329 Tues., Dec. 17 Wed., Jan. 8 Thurs., Jan. 30 Fri., Feb. 21 Sat., Mar. 14 Tues., Mar. 17 Wed., Apr. 8 Thurs., Apr. 30 Tues., May 26

NAPERVILLE- Weekdays 9am - 4pm (One Day) - Fee: $329 Mon., Dec. 23 Wed., Jan. 15 Thurs., Feb. 6 Tues., Mar. 3 Tues., Mar. 24 Wed., Apr. 15 Mon., May 11

NAPERVILLE- Evenings 6:30pm - 9:30pm (Two Days) - Fee: $329 Mon., Mar. 9 and Wed., Mar. 11

Lower pricing may be available on

MICROSOFT EXCEL - CONTINUED

Excel Part 3

Students will work with advanced formulas, learning functions such as VLOOKUP, IF, SUMIF, SUMIFS, ROUND , PMT, IFERROR, COUNTIF and COUNTIFS. In addition, students will learn about data validation and creating formulas with dates. Learn how to import and export comma and tab delimited text files and how to create macros.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $379

Mon., Dec. 30

Sat., Jan. 18

Wed., Jan. 29

Fri., Feb. 28

Tues., Mar. 31 Thurs., Apr. 30

SCHAUMBURG- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $379 Thurs., Jan. 9 Mon., Feb. 24 Sat., Mar. 28 Thurs., Apr. 9 Wed., May 27

NAPERVILLE- Weekdays 9am - 4pm (One Day) - Fee: $379

Fri., Feb. 7

Wed., Mar. 25

Tues., May 12

NAPERVILLE- Evenings 6:30pm - 9:30pm (Two Days) - Fee: $379 Mon., Mar. 16 and Wed., Mar. 18

Take all 3 Excel Classes: Part 1, Part 2 and Part 3 for $849, saving over 15%!

Excel VBA (Visual Basic for Applications)

Students will gain proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.

CHICAGO- Weekdays 9am - 4pm (One Day) - Fee: $425 Mon., Apr. 6

SCHAUMBURG- Weekdays 9am - 4pm (One Day) - Fee: $425 Fri., Jan. 17

DECEMBER 2019 - MAY 2020

3 WWW.

MICROSOFT ACCESS

Access Part 1

After an introduction to database concepts, students will learn how to design and create databases. Then they will work with tables, fields, and records; sort and filter data; and set field properties and data entry rules. Students will then learn to create queries, forms, and reports.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $299

Thurs., Dec. 12 Fri., Jan. 17

Tues., Feb. 18 Wed., Mar. 18

Thurs., Apr. 16 Sat., Apr. 18 Mon., May 18

SCHAUMBURG- Weekdays 9am - 4pm (One Day) - Fee: $299

Fri., Dec. 20

Thurs., Feb. 27

Fri., Apr. 24

NAPERVILLE- Weekdays 9am - 4pm (One Day) - Fee: $299 Wed., Dec. 4 Thurs., Jan. 30 Mon., Mar. 30 Tues., May 26

Access Part 2

Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields, and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $329

Fri., Dec. 13

Mon., Jan. 20 Wed., Feb. 19 Thurs., Mar. 19

Fri., Apr. 17

Sat., Apr. 25 Tues., May 19

SCHAUMBURG- Weekdays 9am - 4pm (One Day) - Fee: $329

Mon., Dec. 23

Fri., Feb. 28

Mon., Apr. 27

NAPERVILLE- Weekdays 9am - 4pm (One Day) - Fee: $329

Thurs., Dec. 5

Fri., Jan. 31

Tues., Mar. 31 Wed., May 27

MICROSOFT ACCESS - CONTINUED

Access VBA

This class is for experienced Access users who want to learn ActiveX data objects, control structures, and the basics of VBA programming. Introductory and advanced courses and several weeks of practice are recommended.

SCHAUMBURG - Weekdays 9am - 4pm (One Day) - Fee: $425 Fri., Feb. 14

Take all 3 Access Classes: Part 1, Part 2 and Part 3 for $849, saving over 15%!

MICROSOFT WINDOWS

Windows/File Management Introduction

Learn how to use the Start menu and taskbar; move, resize windows; create and manage files, folders, and libraries; edit file metadata; and search for content on their computers. You will also create shortcuts, use gadgets, and change system settings. Finally, students will browse the Web add sites to their Favorites lists.

CHICAGO- Weekdays 9am - 4pm (One Day) - Fee: $299

Thurs., Feb. 6

Fri., Apr. 3

Wed., May 27

SCHAUMBURG- Weekdays 9am - 4pm (One Day) - Fee: $299 Tues., Dec. 10

Access Part 3

Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; passwordprotect and encrypt databases; and set Access options and properties.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $379

Tues., Jan. 21

Fri., Mar. 20

Sat., May 2 Wed., May 20

SCHAUMBURG- Weekdays 9am - 4pm (One Day) - Fee: $379

Thurs., Dec. 26

Tues., Apr. 28

NAPERVILLE- Weekdays 9am - 4pm (One Day) - Fee: $379

Fri., Dec. 6

Wed., Apr. 1

DECEMBER 2019 - MAY 2020

4

WWW.

MICROSOFT WORD

Word Part 1

Students will learn how to navigate documents, enter and edit text, create and save documents. They will also create tables, insert headers and footers, proof, and insert graphics. Learn how to navigate documents, how to enhance the appearance of a document by using various formatting options.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $299

Mon., Feb. 10

Sat., Mar. 21

Tues., Apr. 21

SCHAUMBURG- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $299

Tues., Jan. 14

Wed., Apr. 1

Sat., May 30

NAPERVILLE- Weekdays 9am - 4pm (One Day) - Fee: $299

Tues., Dec. 17

Wed., Mar. 11

Word Part 2

Students will work with styles, sections, and columns and will use the Navigation pane to work with outlines. They will format tables, print labels and envelopes, and work with graphics. They will also use document templates, and work with Web features.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $329

Tues., Feb. 11

Sat., Mar. 28

Wed., Apr. 22

SCHAUMBURG- Weekdays 9am - 4pm (One Day) - Fee: $329

Wed., Jan. 15

Thurs., Apr. 2

NAPERVILLE- Weekdays 9am - 4pm (One Day) - Fee: $329

Wed., Dec. 18

Thurs., Mar. 12

Take all 3 Word Classes: Part 1, Part 2 and Part 3 for $849, saving over 15%!

Word Part 3

Students will perform mail merges, create forms, and create master documents that include a table of contents, a table of figures, footnotes, endnotes, an index, bookmarks, cross-references, and Web frames. They will also create macros, Quick Access toolbar, and work with XML documents.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $379

Tues., Dec. 10

Wed., Feb. 12

Sat., Apr. 4

NAPERVILLE - Weekdays 9am - 4pm (One Day) - Fee: $379

Thurs., Dec. 19

Fri., Mar. 13

MICROSOFT POWERPOINT

PowerPoint Part 1

Students will learn to create, and rearrange presentations. Then they will format text, use drawing objects, work with graphics, and insert tables and charts. They will also use slide masters, and transition effects. Finally, students will learn to run presentations.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $299

Thurs., Jan. 30

Sat., Feb. 1

Mon., Mar. 23 Mon., May 11

SCHAUMBURG- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $299

Thurs., Feb. 6

Mon., Apr. 13

Sat., Apr. 18

NAPERVILLE- Weekdays 9am - 4pm (One Day) - Fee: $299

Thurs., Jan. 16

Thurs., Mar. 19

Thurs., May 28

NAPERVILLE- Evenings 6:30pm - 9:30pm (Two Days) - Fee: $299 Mon., May 11 and Wed., May 13

Take both PowerPoint Classes: Part 1 and Part 2 $529, saving over 15%!

PowerPoint Part 2

Students will customize PowerPoint by modifying the Ribbon and changing application settings. They will also apply themes and templates, and they will work with SmartArt graphics. Students will add multimedia content and interactive elements to slides. Finally, students will integrate PowerPoint with Word and Excel.

CHICAGO- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $329

Fri., Jan. 31

Sat., Feb. 8 Tues., Mar. 24 Tues., May 12

SCHAUMBURG- Weekdays/Saturdays 9am - 4pm (One Day) - Fee: $329

Fri., Feb. 7

Tues., Apr. 14

Sat., May 2

NAPERVILLE- Weekdays 9am - 4pm (One Day) - Fee: $329

Fri., Jan. 17

Fri., Mar. 20

Fri., May 29

NAPERVILLE- Evenings 6:30pm - 9:30pm (Two Days) - Fee: $329 Mon., May 18 and Wed., May 20

DECEMBER 2019 - MAY 2020

5 WWW.

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download