You're browsing Office Productivity Classes in Online

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

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

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

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

Learn more about creating a slideshow presentation using Microsoft PowerPoint. Topics include creating and editing slides, editing master slides, adding animations, and running your slideshow. More Info Skill prerequisites: Keyboard and mouse skills Audience: Adults Instructors will send out an email two hours before the class starts

This class will cover the most popular lookup method in Excel, VLOOKUP, which is used to search for and retrieve information in data sets, and work with the results. To participate hands-on in this class, it is advised that you use one of the following versions of Excel: PC - 2007 , 2010 , 2013 , 2016 , 2019 Mac - 2016 , 2019 Must...

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

Our three-day course will provide you with the core skills you need to make the most of this extremely powerful application. Perspective drawing, variable-width strokes, a new brush that lets you control bristle characteristics, and innovative ways to quickly build shapes, are among the new features in the comprehensive vector environment of industry...

This class covers how to take the basic logic from Class 1 and use it to create functions that process data based on conditions. Topics include SUMIF/AVERAGEIF/COUNTIF and SUMIFS/AVERAGEIFS/COUNTIFS. Skills required: Be able to write a basic formula and function Be able to write Relative and Absolute cell references Have Taken Class 1 or understand...

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

This class will cover how to customize charts to better visualize information, as well as the pros and cons of various chart types.  Topics include : Formatting charts, adding and customizing chart elements, creating mixed charts, chart analysis tools, and sparklines. To participate hands-on in this class, it is advised that you use one of...

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

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.