You're browsing Office Productivity Classes in Online

Master VLOOKUP, Pivot Tables, formulas and functions in this intermediate Excel course. Build on your basic Excel knowledge by learning more advanced techniques like Sort & Filter, logical functions, and time-saving tricks. The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter,...

WorkShop Includes:  Logical Test  IF, AND, OR Functions  SUMIFS Function  INDEX & MATCH Merge Data with INDEX, MATCH Functions Text Manipulation and Cleaning Data  Date Function Table Objects

Master basic calculations, formulas, and functions in this introductory Excel course. Beginners who take this course will learn tips and tricks to make navigating Excel easier and faster. Get the hang of Excel formulas, functions, charts, and workbook formatting. This beginner course is the perfect introduction to Excel for self-taught users and...

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 build basics spreadsheets & get comfortable using Microsoft Excel in working environment. This workshop is best suited for those who have very little or no experience with Microsoft Excel. Workshop Includes: Overview Of Microsoft Excel User Interface Working with Workbook Working with Worksheets Working With Worksheet Tabs ...

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.

WorkShop Includes: How to Record and Use Macros VBA Syntax Introduction to VBA Development Writing to Cells & Ranges Modifying Recorder Macros If Then Else Statement Simple For Loops Workshop is led by an Excel Power User/Excel VBA Developer/Data Driven Application Developer. We recommend having a USB flash drive if you want to keep your work...

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

Adobe Photoshop is the industry standard application for professional image manipulation.  This two-day introductory class will get you up-to-speed quickly. This course starts with an overview of the workspace and tools, and moves onto project planning and workflow, basic photo correction, photo retouching and restoration, working with layers...

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

Learn to perform mail merges. Create forms and master documents that include a table of contents; table of figures; footnotes; endnotes; and more. Create macros, customize the ribbon and Quick Access toolbar. Course Content Lesson 1: Manipulating Images Topic A: Integrate Pictures and Text Topic B: Adjust Image Appearance Topic C: Insert Other...

Get up and running quickly with the fundamentals of Photoshop. Learn to retouch photos, create graphics, as well as adjust contrast and color. You’ll learn how to remove unwanted elements from photos, make selections, save files for print or web, and much more. In no time at all you’ll be able to improve your photos and build graphics in Photoshop!...

Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create drop-down menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class,...

This two-day advanced class will help you go beyond the basics offered in our Photoshop Level 1 class. This course offers Photoshop and typographic design, vector drawing tools & techniques , advanced layers techniques, compositing , ImageReady, and color management. Prerequisite:  Photoshop level I (or comparable experience). Audience: ...