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

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

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

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.

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.

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!

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

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

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

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

Learn essential Adobe InDesign tools, tips and techniques at your own pace with private one-on-one training. This customized training format is ideal for anyone with special training needs or specific project goals that may fall outside of the scale and scope of group workshops. Private sessions are appropriate for beginner skill levels. Training...