All Software Training in Chicago, IL

Google AdWords allows individuals and organizations to advertise on the Internet. In this course, students will learn how to create and navigate a Google AdWords account, create and manage ad campaigns, work with keywords, write ads, manage bidding and budgets, launch and manage ads and be able to create financial and performance reports. About Our...

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 hands-on beginner class is suitable for Project 2010, 2013 and 2016 users. You will start with basic concepts, before proceeding through all the functions required to effectively plan and manage small to medium-size projects. These include scheduling tasks, allocating resources, creating a timeline, tracking costs and reporting. This course...

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

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

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

In this class, students will learn how to use Microsoft Windows efficiently. The majority of computers today use Microsoft Windows. Therefore, a solid understanding of Windows is necessary before learning other programs. In our Introduction to Windows class we will resize windows, navigate the desktop and use online help. We will customize Windows,...

This one-day class will show you basics of how to maneuver in Google Drive. You will learn how to create, upload, share files with Google Drive. The class is recommended for users who would like to get to know Google Drive in more depth or who are converting to G Suite from another office suite such as Microsoft Office. Prerequisites: To ensure...

In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft® Office OneNote® 2016 provides a way for you to efficiently create and collect your notes in an electronic notebook. This course will introduce you to using OneNote notebooks to store a wide variety of content in an organized structure,...

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

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 hands-on class is suitable for PowerPoint 2010/2013/2016 users.  You will learn to create more dynamic and visually appealing presentations using the more advanced features of PowerPoint. The course covers transitions and animation, themes, slide masters, advanced formatting, using templates, collaborating with others and more. Live face-to-face...

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 hands-on Project class is suitable for Project 2010, 2013 and 2016 users. You will learn the more advanced features of Project such as working with network diagrams, calendar views, team planners, baselines, progress lines, resolving conflicts, working with resource pools, comparing projects, using the organizer and more. Course Outline Working...

On this class you will learn how to use Microsoft Visio to draw a wide variety of drawings such as flowcharts, organization charts, maps, floor plans and more. No prior experience of Visio is needed. Course Outline: Opening and Closing Visio Working with Files Setting Up Your Screen Your First Drawing Basic Editing Tasks Formatting Shapes...