Office Productivity Classes in Online

In this intermediate Excel course, master tools such as pivot tables, formulas, macros, data analysis & more with hands-on exercises. You'll also learn some advanced formatting tools such as conditional formatting, sorting and filtering, and some major time-saving tips like freeze panes. Materials Needed to Fully Participate: Microsoft Excel...

Master the core Excel functions in this one-day course. Learn calculations and data entry. Apply formatting to text and cells to make your spreadsheet scannable and visually appealing. In this hands-on training, you will learn all the basics to use Microsoft Excel as your primary data processing tool. You'll produce polished and print ready spreadsheets...

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

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 hands-on introductory course details the most essential Adobe Photoshop features for beginner level users. Topics include basic image editing, transformation, retouching, enhancement, and compositing.  TOPICS Understanding File Formats & Resolution Selections Techniques Image Transformations Layer Management Layer Masking &...

This hands-on introductory course details the most essential Adobe Illustrator features for beginner level users. Students will learn how to create and manipulate vector shapes with a variety of tools. The course also covers text, color, effects, and layers. TOPICS Understanding Vector Graphics Creating & Transforming Paths Working With...

Bring your creative ideas to life with Adobe Photoshop, the professional digital imaging standard, used by photographers and designers who want to perfect their digital images. Photoshop allows you to create powerful images and designs. This workshop is designed to get you up and running with Adobe Photoshop in just three hours. The focus will be...

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

WorkShop Includes: Filters, SUBTOTAL VLOOKUP Merge Data with Lookup Functions Error Handling Tables Pivot Tables Must-Know Keyboard Shortcuts 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 files after class. They serve as a great...

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

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 and simple database operations.  Continuing classes include a overview of Excel's vast collection of formulas and functions....

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

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

In this class you will work with formulas that span across multiple worksheets and use the VLOOKUP and INDEX functions. You'll create and modify macros, protect workbooks, and use Excel's data validation features. Prerequisite: You must have expertise in using range names and/or have successfully completed the Excel 2016 Basic and Intermediate...

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