Office Productivity Classes in Chicago, IL

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

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

AWS Technical Essentials introduces you to AWS products, services, and common solutions. It provides you with fundamentals to become more proficient in identifying AWS services so that you can make informed decisions about IT solutions based on your business requirements and get started working on AWS. Skills Gained This course teaches you how to:...

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

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

Developing on AWS helps developers understand how to use the AWS SDK to develop secure and scalable cloud applications. The course provides in-depth knowledge about how to interact with AWS using code and covers key concepts, best practices, and troubleshooting tips. This course is designed to teach you how to: Set up the AWS SDK and developer credentials...

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

Have you been out of the job market, or want to change careers? Need to submit a resume with up-to-date computer skills to a temp agency? This class will get you started. Word is currently the most popular word processing program in the market. Most jobs require you to have basic knowledge of Word. And it's not only useful for jobs, but for school...

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

InDesign is a powerful page layout publishing application. In this class, we cover adding/removing document pages and master pages, adding columns and guides, formatting text, placing text from a word-processor, adding photos and graphics, creating a newsletter, and preparing your document for output to an offset printer all while learning multiple...

This 1-day beginner class is designed to get you up and running quickly in Adobe Illustrator. You will create icon shapes, learn to use the pen tool and other manipulation tools, incorporate type into your artwork, create an event poster, and prepare your images for the Web and social media. This course is ideal for designers, marketers and anyone...

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

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, tables, and charts. Students will add multimedia content and interactive elements to slides. Finally, students will integrate PowerPoint with Word and Excel.

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

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