You're browsing Office Productivity Classes in Online

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!

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

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

Adobe Illustrator gives you new creative freedom that lets you realize your ideas quickly and powerfully. Tight integration with other software allows you to produce extraordinary graphics for print, video, the web, and mobile devices. This course gives students a practical, working experience with the basics of Adobe Illustrator, as well as all the...

Adobe Photoshop is the essential software tool used in the film, television, and game industry for use in everything from pre-production and visualization to post. This introductory class explores fundamental skills such as working with layers, editable adjustment layers, mastering selection and masking, use of channels, and layer masks. Other topics...

Learn advanced formulas, VLOOKUP, IF functions, data validation, database functions, formulas with dates, macros & more! Course Outline: Unit 1: Logical and statistical functions Topic A: Logical functions (IF, OR, AND, NOT, IFERROR) Topic B: Math and statistical functions (SUMIF, COUNTIF, AVERAGEIF, ROUND) Unit 2: Financial and date functions...

Learn how to create a slideshow presentation using Microsoft PowerPoint. Topics include creating and editing slides, inserting images, and running your slideshow. Skill prerequisites: Computer Basics 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 older...

PowerPoint is used to develop presentation materials. We’ll create text, charts and graphs to be used in electronic presentations or handouts. We’ll also work with slide masters and templates, create objects and use clip art. You will also learn how to apply transitions for electronic presentations.

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.

In this three-hour session for Windows and Mac users, you will learn the most efficient ways to format cell text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart...

Learn the industry standard tool for creating rich imagery for a variety of applications including video, print and the web in this comprehensive two-day Photoshop training. This Photoshop training begins by learning the interface and how to properly setup a workflow for image editing. Your instructor will show you how to retouch, repair and manipulate...

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

This comprehensive Illustrator hands on training is an in depth courseware using the industry standard tool for creating rich vector graphics for everything from a business card to a roadside billboard. Illustrator is not just for artists. Use Illustrator to quickly manipulate and create Acrobat PDF documents, create mocks and dashboards for prototyping,...

This class will focus on showcasing the different digital processes used to create a solid sketch or drawing that effectively communicates an idea. Students will learn how to approach different types of subject matter such as plants, animals, characters, creatures and props with various digital drawing techniques used by concept artists, storyboard...

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