All Software Training in Chicago, IL

You can't get a job today without Excel. This class will show you the basics of working with spreadsheets using Excel. First we'll get comfortable in the Excel workspace, then we'll cover the basics: entering numbers and text, formatting, and performing basic calculations. Then we'll look at sorting data, creating charts, and more advanced use of formulas. ...

With some of our competitor's QuickBooks seminars you will be watching someone show you how to use QuickBooks. In our class YOU will be using the QuickBooks software at all times during the class. Learn by doing! Course Outline: Lesson 1 – Getting Started Starting QuickBooks Setting QuickBooks Preferences  Identifying Components of the...

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

This comprehensive Photoshop course enables students to create professional, complex graphics and edit images. Learn to manipulate photos and graphics for both print and web. Whether you’re new to Photoshop or been using it for years, you will have solid skills and be able to create, edit, and manipulate images with ease in our Adobe Photoshop class....

This hands-on beginner class is suitable for Project 2013, 2016, 2019 and 365 users. You will start with basic concepts, before proceeding through all the functions required to effectively plan and manage small to medium-size projects. These include scheduling tasks, allocating resources, creating a timeline, tracking costs and reporting. This course...

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

You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course is ideal for people new to Excel who need to produce reports, budgets, lists...

In our Intermediate Word class students will work with styles, sections, and columns and will use the Navigation pane to work with outlines. They will format tables, print labels and envelopes, and work with SmartArt graphics and drawing tools. They will also use document templates, manage document revisions, and work with Web features. Course Outline...

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.  This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. Prerequisite:  You should have completed...

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 hands-on class is suitable for Excel 2013 and 2016, 2019 & 365 users.  On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If...

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

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.

Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties.

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