Office Productivity Classes in Chicago, IL

In this intermediate Excel course, master tools such as pivot tables, formulas, macros, data analysis & more with hands-on exercises. You'll also learn some advanced formatting tools such as conditional formatting, sorting and filtering, and some major time-saving tips like freeze panes. Materials Needed to Fully Participate: Microsoft Excel...

Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Microsoft Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets...

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

This course is designed to provide students with a basic to mature ability to collect, enter, and perform calculations with data in MS-EXCEL spreadsheets, and to utilize basic statistical techniques to analyze and present the data in words, graphs and charts. These skills will be useful in securing entry level IT positions in industry. Key topics...

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

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

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!

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

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring the COVID-19 situation very carefully and are adjusting delivery of our programs. Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online...

This hands-on introductory course details the most essential Adobe InDesign features for beginner level users. Students will create multi-page documents while learning a variety of text and image layout techniques. TOPICS  Creating & Customizing Documents Page Setup & Layout Working With Master Pages Working With Typography Applying...