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 the basics of working with spreadsheets using Microsoft Excel 2010. Topics include entering data and formulas, moving and copying data, formatting & print previewing worksheets. Please note: 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...

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

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

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

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

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

Learn the industry standard tool for creating rich imagery for a variety of applications including video, print and the web in this comprehensive two-day Photoshop training. Through hands-on practice, you will create, edit and apply special effects to images and text that can be prepared for various uses such as print and marketing materials, presentations,...

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

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

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