Office Productivity Classes 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....

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.

Discover how to create a new website similar to www.art4charity.us or photo-video-portfolio.com. Millions of websites are online right that have been created using the method that will be taught in this class and it’s EASY! Be empowered.  You will have your own website which you may use to upload and add your original content. You’ll...

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

System Operations on AWS is designed to teach those in a Systems Administrator or Developer Operations (DevOps) role how to create automatable and repeatable deployments of networks and systems on the AWS platform. The course covers the specific AWS features and tools related to configuration and deployment, as well as common techniques used throughout...

Running Container-Enabled Microservices on AWS is designed to teach you how to manage and scale container-enabled applications by using Amazon EC2 Container Service (ECS). The course highlights the challenges of running containerized applications at scale and provides guidance on creating and using Amazon ECS to develop and deploy containerized microservices-based...

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

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

Master the number one accounting system for small and medium size businesses. Create a truly portable QuickBooks company accessible over the internet anywhere. In this class we’ll compare the features of the available QuickBooks versions and their costs. You’ll learn the basic QuickBooks architecture and navigation system and practice using QuickBooks...

We cover using Photoshop for print production and the web, and making detailed photograph adjustments in a workflow environment. Course Outline Basic Photo Corrections Retouching and Repairing Images Sharpening the Image Quick Fixes Creating a Panorama Correcting Lens Distortion Adding Depth of Field Moving Objects Seamlessly Adjusting...

This one-day class offers tips, tricks and timesavers that will help you get the most from Excel. It is an easy quick-paced class that will touch on most of the popular Excel features and how to access them efficiently. Target Student: You already know Excel and have been working with it regularly. Some of your skills are self-taught and you might...

You can't get a job today without Excel. This class will show you the basics of working with spreadsheets using Excel. First we'll get comfortable in the Excel workspace, then we'll cover the basics: entering numbers and text, formatting, and performing basic calculations. Then we'll look at sorting data, creating charts, and more advanced use of formulas. ...

This hands-on class is suitable for PowerPoint 2010/2013/2016 users.  You will learn to create more dynamic and visually appealing presentations using the more advanced features of PowerPoint. The course covers transitions and animation, themes, slide masters, advanced formatting, using templates, collaborating with others and more. Live face-to-face...

Go further with Excel by learning to create charts and tables as well as learning time saving formatting and validation features. In this course, you will work Microsoft Office Excel 2013 create charts and tables. You will learn handy formatting and tools for error checking. You will create formulas to that use built-in functions to do advanced analysis....

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