All Software Training in Chicago, IL

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

You will walk away knowing how to set up a QuickBooks company, use registers, set up inventory, invoice customers, process payments, enter and pay bills, and much more. Course Outline: Lesson 1 – Getting Started Lesson 2 – Setting Up QuickBooks Lesson 3 – Working With Lists Lesson 4 – Setting Up Inventory Lesson 5 – Selling Your Product...

The Intermediate Outlook class is designed for experienced Outlook users who need to learn how to customize their environment, calendar, and mail messages to meet their specific needs and who wish to track, share, assign, and quickly locate various Outlook items.

From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations. In...

On this class you will learn how to use Microsoft Visio to draw a wide variety of drawings such as flowcharts, organization charts, maps, floor plans and more. No prior experience of Visio is needed. Course Outline: Opening and Closing Visio Working with Files Setting Up Your Screen Your First Drawing Basic Editing Tasks Formatting Shapes...

This course is intended as a continuation of our introductory-level courses in Power BI (20778: Analyzing Data with Power BI and/or Excel BI Tools: Power BI for Excel Users ). It covers common intermediate-level tasks and some of Power BI’s most desireable new features. Prerequisites Before attending this course, students should have: - General...

Premiere is one of the most adaptable digital video editing tools on the market today. We'll learn about the work area, video basics and terminology, transitions, filters, audio, titles & superimposing, the motion command, advanced editing, and layers. Course Outline Getting to Know the Workflow Customizing the Workspace Setting Up a Project...

This class focuses on getting students familiar with a complete and logical workflow for creating a video production, thus providing a background of how projects go from start to finish. Topics include color correction, applying transitions effectively, controlling clip speed and key framing. Course Outline Advanced Editing Techniques Working...

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

This class will cover advanced modification of PDF's, create complex forms, create indexes, manage large number of PDF's, create links, customize PDF output using compression, and more. Course Outline: Lesson 1: High Quality PDF’s PDF File Attributes PDF Settings Image Options Lesson 2: Color Management Color Shifting Color Profiles ...

Adobe Acrobat DC is the most thorough and comprehensive course for students to learn how to reliably create, edit, and sign PDF documents and forms with Adobe Acrobat DC. Each of the 13 lessons in this step-by-step, project-based course contains a project that builds on their growing knowledge of the program. This cross-platform (Mac and Windows) course...

Learn the basic features of Microsoft Visio and get more done quickly. Learn about:  Creating Diagrams Managing Text Shapes & Pages Creating Business Process Diagrams Creating Organization (Org) Charts Adding Style Color & Themes and Printing Reusing & Sharing Diagrams Visio Versions That Can Attend: Visio 2016 & 2013...

Students will learn to design and create new databases, tables, and relationships; create and maintain records; locate records; and produce reports based on the information in the database. Target Audience: This course is aimed at students who need to learn the basic operations of the Microsoft Access database application. No prior experience of...

Google Analytics is a suite that is integrated with Google’s data to help draw conclusions about the effectiveness of your site content, promotions and advertising campaigns. This class will go over how to implement Google Analytics, how to manage your accounts, perform reports and in-depth analysis with specific reports.

Google AdWords is designed to help you reach potential customers at the exact right moment. This workshop will walk you through what you need to know to get started with this highly powerful, highly technical, advertising platform. Students will learn keyword audience targeting, how to design effective ad copy, and how to estimate you ad’s success....