Office Productivity Classes in Online

Master the number one accounting system for small and medium size businesses. Create a truly portable QuickBooks company accessible over the internet anywhere. In this class we’ll compare the features of the available QuickBooks versions and their costs. You’ll learn the basic QuickBooks architecture and navigation system and practice using QuickBooks...

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

The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard...

Master advanced Excel techniques in this hands-on training. Learn how to use the more advanced tools in Excel like What-If Analysis, INDEX-MATCH, macros, and more. Advance your career with this essential course for professionals that use Excel daily. You'll make functions more flexible, take Pivot Tables to the next level, and automate tasks with...

Adobe Illustrator CC is a vector-based image creation software used in illustration, technical drawing, animation, special effects, logo and T-shirt design and motion graphics. Topics include Bezier curves, color and gradients, dynamic type and gradient mesh tool, live trace, live paint, creating custom workspaces, control palette and integration...

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!

The bootcamp is designed to provide students with a general overview of Excel topics and specifically more knowledge of several different functions. It combines most of the material from the two workshops into an intense one-day session. Given the short timeframe and large amount of topics covered, students are expected to be able to learn quickly....

Learn how to enhance photos using the # 1 photo editing software in the world: Adobe Photoshop. Get a basic introduction to Photoshop's tools, layers, and adjustments as you work through two example projects. 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...

We are offering a Microsoft Excel Expert Course. The class will teach you how to create Marco's, conditional formatting, securing your workbooks, expert functions, auditing worksheets, analyzing data, and importing, exporting data.  This course is perfect for someone who uses Microsoft Excel already, or took our Excel essentials course and wants...

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

If you know the basics of Microsoft Excel and want to take your knowledge to the next level, then this hands-on bootcamp is for you. Whether you are in business, management, or simply interested in getting more organized, this Excel bootcamp will cover the tools and functions you need to automate or enhance the way you analyze and restructure your...

Create vector-based graphics that can be easily rescaled without loss of quality. Learn basic tools & fundamentals, features for creating distinct designs include painterly/fluid brushes, shape-building tools, and path controls.  There are also different transparency and gradients tools available for a variety of illustrations and mediums....

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

Become the leader in creating spreadsheets and data presentation, Topics include:  Basic worksheet navigation Entry techniques Cell references Using the command groups & settings Formulas & functions Charts & graphs Simple database operations Note: Continuing classes include a overview of Excel's vast collection of formulas...

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