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

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

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.

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

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

You will learn about advanced queries, forms and reporting, creating Macros, importing and exporting data from Access, and important database management tasks such as compressing and restoring a database, data encryption and more. What is included:  Certificate of Course Completion Hardcopy Training Manual FREE Class Repeat Course Outline:...

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.

Students will learn to design and create new databases, tables, and relationships; create and maintain records; locate records; and produce reports based on the information in the database. Target Audience: This course is aimed at students who need to learn the basic operations of the Microsoft Access database application. No prior experience of...

AWS Technical Essentials introduces you to AWS products, services, and common solutions. It provides you with fundamentals to become more proficient in identifying AWS services so that you can make informed decisions about IT solutions based on your business requirements and get started working on AWS. Skills Gained This course teaches you how to:...

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

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

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

Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks. Who Should Attend: This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets. Prerequisite: Basic Windows, keyboarding and mouse skills. Course Outline: Getting Started Entering Data...

Prerequisites Excel 2010 Introduction or equivalent skills. Must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. The ability to copy, move and delete values and formulas is required. Working with Worksheets Viewing, Renaming, and Color-coding Worksheets Editing a Group Manipulating...