Office Productivity Classes in Chicago, IL

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

Learn how to build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

Students will customize PowerPoint by modifying the Ribbon and changing application settings. They will also apply themes and templates, and they will work with SmartArt graphics, tables, and charts. Students will add multimedia content and interactive elements to slides. Finally, students will integrate PowerPoint with Word and Excel.

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 the basics of the Photoshop work area and image manipulation. You will work with color, retouch images with filters and other methods, create layered images, and use masks. Course Outline: Lesson 1: Getting started Using Adobe Bridge Organizing & Customizing the Photoshop Workspace Lesson 2: Basic Images Image Elements...

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

This is an introductory course for individuals who want to learn the overall concepts of Lean Six Sigma and to learn the beginning steps into improving processes and eliminating waste. Course Lessons: What is Six Sigma? Sigma Level Methodology Transfer Function What is Lean? Cost of Poor Quality Seven Deadly Muda 5S Define Phase SIPOC Spaghetti...

WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops 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...

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

Students will gain proficiency in creating procedures that run in response to specific events, working with control structures,developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.

Students will learn to create, save, and rearrange presentations. Then they will format text, use drawing objects, work with graphics, and insert tables and charts. They will then learn to use templates and themes, slide masters, and transition effects. Finally, students will learn to proof, and run presentations.

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.

Have you been out of the job market, or want to change careers? Need to submit a resume with up-to-date computer skills to a temp agency? This class will get you started. Word is currently the most popular word processing program in the market. Most jobs require you to have basic knowledge of Word. And it's not only useful for jobs, but for school...

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