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

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

Learn advanced Excel features and become an Excel expert. In this course, you'll master advanced functions like INDEX-MATCH, macros, and data analysis. Develop expertise in Excel’s most advanced features and become a resident Excel expert. Maximize the power of Pivot Tables, save hours by automating tasks with macros, and develop experience with...

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

Master VBA (Visual Basic for Applications) and macros in this course for avid Excel users. Visual Basic for Applications or VBA is Microsoft's coding language to program Excel. You can use it to write macros and automate tasks. On Day 1, you'll learn everything covered in Excel VBA Macros Level 1. Day 2 covers advanced VBA techniques in Excel VBA...

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