Office Productivity Classes in Chicago, IL

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

This hands-on introductory course details the most essential Adobe Photoshop features for beginner level users. Topics include basic image editing, transformation, retouching, enhancement, and compositing.  TOPICS Understanding File Formats & Resolution Selections Techniques Image Transformations Layer Management Layer Masking &...

This hands-on introductory course details the most essential Adobe Illustrator features for beginner level users. Students will learn how to create and manipulate vector shapes with a variety of tools. The course also covers text, color, effects, and layers. TOPICS Understanding Vector Graphics Creating & Transforming Paths Working With...

Bring your creative ideas to life with Adobe Photoshop, the professional digital imaging standard, used by photographers and designers who want to perfect their digital images. Photoshop allows you to create powerful images and designs. This workshop is designed to get you up and running with Adobe Photoshop in just three hours. The focus will be...

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more. Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with...

In this class you will work with formulas that span across multiple worksheets and use the VLOOKUP and INDEX functions. You'll create and modify macros, protect workbooks, and use Excel's data validation features. Prerequisite: You must have expertise in using range names and/or have successfully completed the Excel 2016 Basic and Intermediate...

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

MS Word for Windows allows you to create and format personal and professional documents and tables of all kinds. Level 2 covers how to use mail merge, work with tables, charts and graphics and how to customize documents.  Prerequisite: MS Word Level 1 or equivalent knowledge.  NOTE:  This course will be offered via Zoom. Register...

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!

Learn how to enhance photos using the # 1 photo editing software in the world: Adobe Photoshop. Get a basic introduction to Photoshop's tools, layers, and adjustments as you work through two example projects. Must register with a valid email address. You will receive an email 2 hours prior to the start of the class with the link to join the virtual...

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  Live face-to-face instructor. No minimum...

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...

Take your skills to the next level and learn more about additional toolsets and techniques in this two-day Photoshop training session. You will explore more advanced features, improve your workflow and work with advanced image handling tools and features available in Adobe Photoshop. You will learn how to avoid pitfalls and which practices to follow...

An introduction to Adobe Photoshop, the imaging software used to create and modify images for use in print and web media. This course will go over working with the tools and user interface, layer basics, working with selections, retouching, color correcting, masking, compositing, preparing files for the web, and more, through hands-on practice in class...