Office Productivity Classes in Chicago, IL

Students will learn to move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. They will also learn how to navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks. This course also covers simple functions used in formulas...

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

This is the weekend course for you if you want to learn the basics quickly. Whether it's for your personal satisfaction or business use, come to this 12 hour comprehensive course for software knowledge. Over the course of two days, you will experience an immersion in MS Word, Excel, and Powerpoint, as well as Desktop Publishing, all using MS Office....

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

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

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

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

Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields,and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

This hands-on class is suitable for PowerPoint 2013, 2016, 2019 and 365 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, SmartArt, adding audio and video, collaborating with others,...

In this class you’ll learn how to create and send messages, sort emails, work with e-mail messages, schedule appointments, insert events, add and edit contacts, create and edit tasks, work with calendar features, and much more!

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 how to customize Outlook and work with address books. They will search and filter mail folders, and apply and customize categories. Students will also work with personal, public, and offline folders. Finally, students will organize folders and set rules.

On this class you will learn the fundamentals of Microsoft Word. You will create, edit and format documents by adding paragraphs, tables, lists, images, design elements, layout options and styles before printing or sharing your documents. No prior experience of Word is needed. Suitable for Word 2007/2010/2013 users.  Detailed course outline...

For most professionals, the ability to organize information is quickly becoming a fundamental part of the job description. Whether you already consider yourself an expert or are just getting started with spreadsheets, this hands-on workshop will allow you to take your skills to the next level and become a “power” user. We’ll start with the absolute...

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