Office Productivity Classes in Chicago, IL

This is the weekend course for you if you want to learn the basics quickly. Whether it's for your personal satisfaction or business use, come to this 12 hour comprehensive course for software knowledge. Over the course of two days, you will experience an immersion in MS Word, Excel, and Powerpoint, as well as Desktop Publishing, all using MS Office....

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work files after class. They serve as a great...

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

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

The focus of this class is the design of an Access database. You will learn how to create tables and basic forms, basic queries, and basic reports. We will cover planning a database, finding records, editing data, and using sorting and filters. Input masks and validation will be covered to help get correct information into your database.

This class will cover topics including Camera Raw, Advanced Image Retouching, Smart Objects and Smart Filters, Advanced Compositing, Advanced Vector Drawing and more. This course is aimed at existing Photoshop users who need to improve their workflow by learning the more advanced features. Prerequisites: Students should have completed our Photoshop...

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

Students will learn how to normalize data, manage table relationships, and enforce referential integrity; work with Lookup fields and subdatasheets; create join queries, calculated fields,and summary values; add objects to forms and create advanced form types; print reports and labels; create and modify charts; and use PivotTables and PivotCharts.

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

Learn to navigate documents, enter and edit text, create and save documents, formatting, create tables, insert headers and footers, insert graphics, and more. Course Content Lesson 1: Getting Started with Word Topic A: Navigate in Microsoft Word Topic B: Create and Save Word Documents Topic C: Manage Your Workspace Topic D: Edit Documents Topic...

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

This hands-on class is suitable for Excel 2010, 2013 and 2016 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 Analysis,...

Developing on AWS helps developers understand how to use the AWS SDK to develop secure and scalable cloud applications. The course provides in-depth knowledge about how to interact with AWS using code and covers key concepts, best practices, and troubleshooting tips. This course is designed to teach you how to: Set up the AWS SDK and developer credentials...