You're browsing Office Productivity Classes in Chicago, IL

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

Students will learn how to navigate documents, enter and edit text, create and save documents. They will also create tables, insert headers and footers, proof, and insert graphics. Students will learn how to navigate documents. Learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert...

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

Learn to perform mail merges. Create forms and master documents that include a table of contents; table of figures; footnotes; endnotes; and more. Create macros, customize the ribbon and Quick Access toolbar. Course Content Lesson 1: Manipulating Images Topic A: Integrate Pictures and Text Topic B: Adjust Image Appearance Topic C: Insert Other...

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

Learn how to use action queries, use calculated fields, adjust data types, set field properties, and perform database maintenance. You will also use input masks, use controls in forms, learn the lookup feature, and work further with queries and reports. Class Outline Unit 1: Designing a Relational databases Topic A: Relational database design...

Learn the principles of table relationships; advanced query techniques; an introduction to functions, macro actions, advanced form techniques including using macros in forms; database security, and advanced report techniques. Class Outline Unit 1: Implementing Advanced Form Design Topic A: Add Controls to Forms Topic B: Enhance navigation...

This intensive training teaches you to create print and digital publications with InDesign. Create projects from scratch and learn about placing photos, drawing and manipulating objects threading text frames, paragraph and character styles, and more. Leave this class with solid Adobe InDesign skills to create compelling documents. Course Outline...

This comprehensive Adobe Photoshop class 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 have been using it for years, you will come away solid skills and be able to create, edit, and manipulate images with ease. Getting...

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! Note: Effective July 1, 2020, all customers are required to wear a mask or face covering at all times while in our building,...

This course is intended for students who want to expand their entry-level knowledge of Adobe InDesign by using advanced features and collaboration tools.  Students will learn how to prepare documents for multiple formats, manage advanced page layouts, manage styles, build complex paths as well as manage external files and create dynamic documents....

Learn PivotTables, advanced formatting, sorting and filtering, outlines, subtotals, advanced charting & more! Class Outline: Lesson 1: Working with Functions Topic A: Work with Ranges Topic B: Use Specialized Functions Topic C: Work with Logical Functions Topic D: Work with Date & Time Functions Topic E: Work...

You 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. Lesson 1: Getting started Topic A: Using Adobe Bridge Topic B: Organizing & Customizing the Photoshop Workspace Lesson 2: Basic Images Topic A: Image...

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. Note: Effective July 1, 2020, all customers are required to wear a mask or...

PowerPoint is used to develop presentation materials. We’ll create text, charts and graphs to be used in electronic presentations or handouts. We’ll also work with slide masters and templates, create objects and use clip art. You will also learn how to apply transitions for electronic presentations. Note: Effective July 1, 2020, all customers...