Flash Classes in Chicago, IL

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work...

One of the most important Excel features is Pivot Tables. This course covers creating Pivot Tables as well as using calculated fields and filters. You will learn to connect to external data sources such as Access and web queries. You will learn to use lookup functions and data tables to allow more sophisticated data conversion functions.  This...

SQL statements are used to perform tasks such as updating data on a database, or retrieving data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, and others.  Some of these database systems will have extensions specific only to their system. However, the...

Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment,...

This course consists of 6 different projects that cover the more advanced features of Adobe Illustrator.The trainer will show you step-by-step how Professional Illustrators use Adobe Illustrator on these more complex jobs. This approach not only teaches you proper workflow techniques but is also a proven training method for those looking...

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...

This course is a complete resource for PMP exam preparation, featuring full coverage of all exam objectives, hands-on practice, and plenty of interactive tools. Fully updated to reflect the Project Management Institute's latest changes to the exam, this new edition includes the revised best practices in alignment with PMBOK 5th edition.  This...

Students will learn how Professional Graphic Designers use Photoshop on a range of different design jobs. This course teaches beginners, step-by-step, how to create cutting-edge graphics and special effects with Photoshop. Target Audience: This Photoshop training is ideal for designers, marketers and anyone who is pursuing a career in graphic design....

Students will learn all the essential tools and techniques to perfect photo manipulation. Our most comprehensive Photoshop course, taking you from Photoshop beginner to Photoshop master in 5 days. The trainer will show you step-by-step how Professional Graphic Designers use Photoshop on a range of different photo editing jobs. This...

Adobe After Effects is the industry leader for Video Compositing that allows you to create QuickTime movies for output on the Web, CD ROM, Monitor, or full-motion broadcast quality video for television. You will learn how to mix a number of still images together to create a moving texture. Placing Compositions into other Compositions, using Keyframes...

This 4 day immersive Captivate Bootcamp offers a complete training solution for those working in Captivate. Our instructional designers will take you from start to finish in creating rich eLearning experiences. It is a comprehensive course that teaches both a solid foundation and enables students to add engaging interactivity. Class Pre-requisite:...

Learn the ins and outs of Adobe Premiere Pro, one of the most powerful motion graphics applications available. Learn how to import and create video files, edit rough cuts, work with transitions, color, opacity, Motion Paths, and special effects. Additionally, students will explore EncoreDVD, Adobe's DVD-authoring wonder, in a special one-day additional...