You're browsing Tech Classes in Chicago, IL

QuickBooks is a very popular small business accounting software. You’ll learn how to invoice, receive payments and make deposits. We’ll enter bills, print checks, void checks and do manual checks, do journal entries, enter credit card charges, set up a petty cash account, set up a loan, customize your chart of accounts, and reconcile your checking...

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

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

Learn to create visualizations including box and whisker plots, dual axis, and combination charts. Create and edit calculations, use parameters. Tell a data story with dashboards by creating a dashboard framework and implementing actions. Create trends, distributions, and built-in forecasting. Course Outline 1. Going Further with Visualizations:...

The Architecting on AWS course focuses on the fundamentals of building IT infrastructure on the AWS platform. You will learn how to optimize the AWS Cloud by understanding AWS services and how they fit into cloud-based solutions. In this training, best practices and design patterns are covered to help you architect optimal IT solutions on the AWS...

The purpose of this training module and the associated exam and certificate is, respectively, to impart, test, and validate the knowledge on industry practices in service management as documented in the ITIL Service Operation publication.  The ITIL Intermediate Qualification: Service Operation Certificate is a free-standing qualification but...

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

Find out how to build effective visualizations and dashboards. Learn how to quickly connect to data sources; build useful calculations; build data visualizations including bar & line charts, geographic maps, scatter plots, dual axis charts, and tables; build dashboards; share with others. Learn how to create and present stories. Course Outline...

Jump into video and learn how to create and edit complete video projects for the web, apps and production. Learn the best options for platforms like YouTube and Vimeo. Create transitions, titles and seamless compositions. Learn the basics of animation and motion graphics with Adobe After Effects. Intro to Premiere Pro Intro to Premiere Pro and...

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

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

This class involves the practical use of QuickBooks with a mock company. The students will be entering/editing/deleting multiple bills, checks, invoices, and credit card charges in realistic workflow scenarios. The students will also work on reconciling credit card and bank statements. Prerequisites: Students should take Part I and Part II before...

We will cover the more advanced features of QuickBooks such as payroll, customizing invoices and other forms, job costing features of QuickBooks Pro, progress invoicing, inventory, and sales tax.  Prerequisite: You must take our regular QuickBooks class (or have used QuickBooks for at least three months) before taking this class. 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...

Learn to use Power BI Desktop Software to connect to, model and shape data. Learn to customize visuals, tooltips, create calculated messages and conditional columns.  Create interactive visualizations with Power BI with data hierarchies, filters, slicers, and dashboards. 1. Connecting to Data  Create Data Connections  Model Data...