Office Productivity Classes in Online

Master the number one accounting system for small and medium size businesses. Create a truly portable QuickBooks company accessible over the internet anywhere. In this class we’ll compare the features of the available QuickBooks versions and their costs. You’ll learn the basic QuickBooks architecture and navigation system and practice using QuickBooks...

Shotgrid Production Tracking, Review, and Management Using Shotgrid During this 8-week course focusing on Autodesk Shotgrid (formerly known as Shotgun,) bring your lunch and feed your brain with new info, too! Starting with Shotgrid Basics, each online session will focus on different aspects of Producing, Tracking, Reviewing and Managing your...

Course Overview In this course, you will learn about the process of planning and designing both relational and nonrelational databases. You will learn the design considerations for hosting databases on Amazon Elastic Compute Cloud (Amazon EC2). You will learn about our relational database services including Amazon Relational Database Service (Amazon...

Course Overview 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. Target Audience This course is intended for Intermediate-level...

The fundamental-level full day course is intended for individuals who seek an overall understanding of the AWS Cloud, independent of specific technical roles. It provides a detailed overview of cloud concepts, AWS services, security, architecture, pricing, and support. It includes lab exercises reinforcing some of the core concepts of the lecture....

Course Overview Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon...

Course Overview Big Data on AWS introduces you to cloud-based big data solutions such as Amazon EMR, Amazon Redshift, Amazon Kinesis and the rest of the AWS big data platform. In this course, we show you how to use Amazon EMR to process data using the broad ecosystem of Hadoop tools like Hive and Hue. We also teach you how to create big data environments,...

Learn how to create documents, apply good formatting, and to save and share your work using Microsoft Word. You will receive an email 2 hours before the class starts with the link to join the virtual class.  *Please note that some people using older or less common email addresses have experienced issues with receiving emails from TechConnect....

Course Overview System Operations on AWS is designed to teach those in a Systems Administrator or Developer Operations (DevOps) role how to create automatable and repeatable deployments of networks and systems on the AWS platform. The course covers the specific AWS features and tools related to configuration and deployment, as well as common techniques...

Course Overview This course covers fundamental AWS cloud security concepts, including AWS access control, data encryption methods, and how network access to your AWS infrastructure can be secured. Based on the AWS Shared Security Model, you learn where you are responsible for implementing security in the AWS Cloud and what security-oriented services...

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

Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. You already have experience working with Excel and creating basic PivotTables to summarize data. But, Excel is capable of doing much more. Being able to harness the...

Course Overview 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. Target Audience This course...

MS Word for Windows allows you to create and format personal and professional documents and tables of all kinds. Level 1 teaches basic skills to create, edit, and format texts. Students must have MS Office Word software installed on their computer. Previous knowledge or experience: Understanding of the basics of Windows Note: Class time...

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