You're browsing Office Productivity Classes in Online

Learn the basics of working with spreadsheets using Microsoft Excel 2010. Topics include entering data and formulas, moving and copying data, formatting & print previewing worksheets. Please note: Must register with a valid email address. You will receive an email 2 hours prior to the start of the class with the link to join the virtual...

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 Migrating to AWS focuses on planning and migrating existing workloads to the AWS Cloud. The course covers various cloud migration strategies with a detailed discussion on each phase of the migration process, including portfolio discovery, application migration planning and design, migration execution, and post-migration validation...

Learn the basics of creating spreadsheets in Excel. Enter data, formulas, format and print workbooks. Target Student This course is for individuals whose job responsibilities include creating, inputting and printing basic spreadsheets. Prerequisites Basic Windows, keyboarding and mouse skills. Course Outline Getting Started Starting Excel Opening...

Learn how to create a slideshow presentation using Microsoft PowerPoint 2010. Topics include creating and editing slides, inserting images and clipart, and running your slideshow. You will receive an email two (2) hours before the class starts with the link to join the virtual class. Skill prerequisites: MS Word Basics

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

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

This course explores methods of shape creation and manipulation, as well as how to apply patterns, gradients, and meshes to shapes, and how to manage larger projects with symbols and global colors.   You will receive an email 2 hours prior to the start of the class with the link to join the virtual class.  *Please note that some people using...

In this class you’ll learn how to create and send messages, sort emails, work with e-mail messages, schedule appointments, insert events, add and edit contacts, create and edit tasks, work with calendar features, and much more!

Make your images even better with Adobe Photoshop Elements—a user-friendly photo editor that has the same concepts as the full version of Photoshop. Apply selection tools, layers, and smart brushes.  A laptop computer with Adobe Photoshop Elements or Adobe Photoshop CS5 installed and a digital camera are required.  This class will be...

Students will learn how to customize Outlook and work with address books. They will search and filter mail folders, and apply and customize categories. Students will also work with personal, public, and offline folders. Finally, students will organize folders and set rules.

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

This class explores photo retouching techniques and tools for filling in cracks, removing wrinkles, and fixing blemishes. Topics include Spot Healing Brush, Healing Brush, Clone Stamp, and Frequency Separation. You will receive an email 2 hours prior to the start of the class with the link to join the virtual class.  Skill prerequisites: Computer...

Explore more advanced features of Microsoft Excel. Topics include using formulas and functions, absolute cell references, data sorting and filtering, and conditional formatting. To participate hands-on in this class, it is advised that you have one of the following versions of Excel: PC - 2010, 2013 , 2016 , 2019 Mac - 2016 , 2019 You will...

Become the leader in creating spreadsheets and data presentation, Topics include:  Basic worksheet navigation Entry techniques Cell references Using the command groups & settings Formulas & functions Charts & graphs Simple database operations Note: Continuing classes include a overview of Excel's vast collection of formulas...