Training Connection Classes, Chicago

This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You’ll also learn how to create interactive forms, insert calculations and handle run-time errors....

This class will cover topics including Camera Raw, Advanced Image Retouching, Smart Objects and Smart Filters, Advanced Compositing, Advanced Vector Drawing and more. This course is aimed at existing Photoshop users who need to improve their workflow by learning the more advanced features. Prerequisites: Students should have completed our Photoshop...

You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. Prerequisite:  You should have completed...

This hands-on class is suitable for Excel 2010, 2013 and 2016 users.  On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...

Better communication skills (with colleagues and clients) can give an organization a huge competitive advantage Not only does it help build a positive working environment with fewer grievances and less staff turnover, but it will result in greater efficiency, more creativity and improved problem-solving. This Business Communication course is designed...

In today's competitive and uncertain times, workers must learn to quickly adapt, integrate and succeed in diverse work environments. And that means business etiquette is more important than ever! Learning Objectives This Business Etiquette course covers: Understanding the importance of business etiquette How to meet and greet Making a favorable...

This course will teach you how to create more complex documents. Topics include working with long documents and table of contents, comments and tracking, reusable content, templates, mail merges, master documents, macros and more. Prerequisite: You should have completed our Introduction course or have similar experience prior to attending this course....

This 1-day beginner class is designed to get you up and running quickly in InDesign. You will learn to layout pages with text and graphics. In no time at all you will be able to control typography, add photos, create/use colors, and more! Live face-to-face instructor. No minimum class size - all classes guaranteed to run! No prior experience of...

Students will complete 7 different projects including a corporate identity package (logo and letterhead), a cereal box, realty development map, a full color brochure, and more. The trainer will show you step-by-step how Professional Illustrators use Adobe Illustrator on a range of different design jobs. This approach not only teaches you proper workflow...

Learn to speak with confidence, clarity and conviction when you attend one of our presentation workshops. Strong presentation skills are vital to succeed in business today. Whether you are doing an internal presentation or delivering a multi-million dollar sales presentation, the skills you learn on this workshop will allow to you produce...

Looking for Microsoft Visio training in Chicago or Los Angeles? Our hands-on Visio classes are the fastest and most effective way to learn Visio. You will be learning from a live trainer present in the classroom. Course Outline: Opening and Closing Visio Working with Files Setting Up Your Screen Your First Drawing Basic Editing Tasks...

On this beginner Adobe certified class you will learn the skills needed to create interactive eLearning content and software demonstrations. The instructor will show you step-by-step how create a soft-skills lessons, software demonstrations, interactive training simulations, and video demos. You will learn to add such standard objects to a slide...

Students will learn the essential tools and techniques to perfect desktop publishing. Our most comprehensive InDesign course, taking you from InDesign beginner to InDesign master in 5 days. The trainer will show you step-by-step how Professional Desktop Publishers use InDesign on a range of different layout jobs. This approach not only teaches you...

On this 3-day beginner to intermediate class you will complete a series of Real World publishing projects including an advertisement, letters and articles, an advertisement, a magazine cover, a map, a travel brochure and more. Our instructors will lead you step-by-step through each project, teaching the correct workflow, how to master each tool and...

This Time Management course teaches students the fundamentals of time management. Participants will learn how to evaluate the use of time, identify goals and set priorities, develop an overall time management plan and much more. Learning Objectives Upon successful completion of this course trainees will be able to: Do a time audit on their existing...