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

The leader in creating spreadsheets and data presentation, topics include: Basic worksheet navigation, entry techniques, cell references, using the command groups & settings, formulas & functions, charts & graphs and simple database operations.  Continuing classes include a overview of Excel's vast collection of formulas and functions....

Adobe Illustrator CC is a vector-based image creation software used in illustration, technical drawing, animation, special effects, logo and T-shirt design and motion graphics. Topics include Bezier curves, color and gradients, dynamic type and gradient mesh tool, live trace, live paint, creating custom workspaces, control palette and integration...

This course is designed for Excel users who would like develop their quantitative skills for managerial decision making. Students will learn how to use present value, Internal Rate of Return, Standard Deviation and more. It features a mix of case studies, individual exercises and group activities. This course is appropriate for all students who wish...

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

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!

In this three-hour session for Windows and Mac users, you will learn to write complex formulas using Excel's built-in functions and array formulas. You will expand your library of functions to include financial, text parsing, logical, lookup and database functions. You will also learn to write array formulas, which are capable of performing multiple...

Learn the essentials managing large worksheets, creating models, and working financial, date, and logical functions. Target Student The course is for individuals who are responsible for managing and creating large worksheets and models in Excel. Prerequisites Excel Introduction or equivalent skills. Course Outline Working with Workbooks Viewing,...

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

A dashboard is a single screen used for reporting that displays charts, tables, and other visual data components on a related subject. Learn how to create Dashboards that will transform business data into actionable information. You will: Create an interactive, dynamic information source within Excel without creating a monster workbook or submitting...

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

This four-week class is designed to get you up and running with all of the basic skills needed to use Adobe Photoshop CC® with your photography.  Using Adobe Photoshop CC®, your instructor will teach you this powerful photo manipulation software. Topics Include: The program layout (menus, tool bars, option bar, panels) through fun project-based...

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Excel is our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. To avoid disappointment,...

Learn the essentials regarding managing data and creating PivotTables in Excel. Create tables; import, modify and analyze data; create and enhance PivotTables. Target Student The course is for individuals who are responsible managing data and creating PivotTables in Excel. Prerequisites Excel Introduction or equivalent skills. Course Outline...