You're browsing Office Productivity Classes in Online

Learn the basics of working with spreadsheets using Microsoft Excel. 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...

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

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.

This class will cover how to use different string functions, how to perform goal-seeking and data scrubbing with Excel.   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 or less common email addresses have experienced issues with receiving...

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

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!

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

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

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

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

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

Excel Dashboard Reporting: Intro to Dashboards Using Excel A dashboard is a way to visually present data in summary form. Chart-rich reports visually compare patterns of performance among many charts, making it easier to remember performance results. In this one-day session, problems will be introduced to help you build your dashboard reporting and...

This class covers how to use conditional logic in formulas and functions, allowing you to create formulas that act differently in different circumstances. Topics covered include: IF statements, nested IF statements, AND and OR functions. To participate hands-on in this class, it is advised that you use one of the following versions of Excel: PC...

We will create templates and adjust background settings, create Word-Art, work with graphics, apply animation, hide slides, create handouts and notes. You will also learn how to apply enhanced formatting for your text. Class Outline: Lesson 1: Modifying the PowerPoint Environment Topic A: Customize the User Interface Topic B: Set PowerPoint...