Office Productivity Classes in Chicago, IL

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

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

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

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

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

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 to move and copy data, do formulas, insert rows and columns, create basic charts, & more! Course Outline: Unit 1: Getting started Topic A: Spreadsheet terminology Topic B: The Excel environment Topic C: Getting help Topic D: Navigating a worksheet Unit 2: Entering and editing data Topic A: Entering and editing text and values Topic...

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.

Go further with Excel by learning to create charts and tables as well as learning time saving formatting and validation features. In this course, you will work Microsoft Office Excel 2013 create charts and tables. You will learn handy formatting and tools for error checking. You will create formulas to that use built-in functions to do advanced analysis....

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

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

Microsoft Word enables you to do far more than simple word processing. Word includes advanced image manipulation tools, collaboration features, cross-referencing and linking tools, entry forms and data collection, security features, and tools to automate document production. Version Note This course is for individuals using Word 365, 2019 or 2016...

In today's work environment, proficiency with spreadsheets is expected. In this course, you will work with Microsoft® Office Excel® 2010 create a new spreadsheet. You will learn to enter data in the most efficient way. You will create formulas to summarize and analyze data and learn the proper technique to copy and paste formulas. You will also learn...

Meetings, instruction, training, pitches; these are all a part of our daily lives. We are often called upon to deliver presentations with little notice, at multiple venues, and with varying requirements. And, some of these presentations include sensitive information that needs to be guarded. Given all the variables, it may seem an overwhelming task...