Office Productivity Classes in Los Angeles, CA

This hands-on class is suitable for Excel 2013, 2016, 2019 and 365 users. On this class you will learn advanced functions including LOOKUPS, Date and Time Functions, Text Functions, Statistical Functions, and Financial Functions. You will learn how to import and export data using the Power Pivot Data model and analysis data using What-If Analysis,...

In this three-hour session, you will import external data, create simple queries to bring in data from SQL sources. You will sort lists by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals. Finally, you will convert data into a table, apply automatic formatting and totals and use AutoFilter to show only...

In this three-hour session for Windows and Mac users, you will learn to write complex formulas using Excel's built-in functions and array formulas. You will expand your library of functions to include financial, text parsing, logical, lookup and database functions. You will also learn to write array formulas, which are capable of performing multiple...

This three-hour session teaches you how to write formulas in Excel. You will perform calculations using functions like SUM, AVERAGE, PMT and PV, write arithmetic formulas by hand, perform calculations on dates, and parse text strings with the LEFT, MID, RIGHT and SEARCH functions. You will also learn when and why to use absolute referencing (like $A$4)...

A PivotTable is Excel's most powerful data summarization tool. In this three-hour session for Windows and Mac users, you will learn what kinds of data works best for PivotTables and how to prepare your data. You will create PivotTables based on various data sources, summarize data by multiple categories using sum, average and count, format the PivotTable,...

This instructor-led course will help advanced Excel users to develop new skills to write and debug powerful VBA code to automate Excel operations such as inserting and formatting text, sorting and duplicating data, generating reports and more. You’ll also learn how to create interactive forms, insert calculations and handle run-time errors Live...

This hands-on beginners course is suitable for Access 2010/2013/2016 users. Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.  After this class you will have a very good working knowledge of Microsoft access, including how to design and build an efficient relational database, construct data...

Transform static slideshows into engaging, energetic presentations by learning to tastefully apply motion to bullet text, images, shapes, SmartArt graphics and charts. Your presentations will hold your audience's attention by appearing one point or image at a time as you talk about them, without creating duplicate slides. In this three-hour session,...

This hands-on beginner class is suitable for Excel 2010, 2013 and 2016 users. You will learn to create, modify, format and print Excel worksheets and workbooks. You will learn basic formulas and functions, how to manipulate data, and how to add charts. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! This course...

On this 3-day beginner to intermediate class you will learn Adobe Illustrator by completing a series of Real World projects. Our instructors will lead you step-by-step through each project, teaching the correct workflow, how to master each tool and show you useful shortcuts to speed up your production. This hands-on training is a proven method for...

In this three-hour training session, you will learn to create and manage a simple Access database. You will navigate within the Microsoft Access application environment, work in Datasheet view, create a simple database, import data from Excel, and work with records. Version covered: 2016 for Windows Prerequisites This class is ideally suited for...

This three-hour session for Windows and Mac users introduces you to the fundamental skills of effective word processing using Microsoft Word. You will become familiar with the Ribbon-based interface, create new documents, add and edit text, cut-and-paste, save and open documents, apply typeface and other font formatting and preview the final document...

In this three-hour session for Windows and Mac users, you will learn how to work on multiple worksheets simultaneously, how to set up what-if analyses models using Goal Seek, Scenario Manager and one- and two-input data tables. You will also learn how to record and edit simple macros. Prerequisites This class is ideally suited for people who have taken...

This 1-day beginner class is designed to get you up and running quickly in Photoshop. You will learn basic photo retouching, color correction, selections, replacing backgrounds, adding type, and preparing your images for print and web. This course is ideal for designers, marketers and anyone who is pursuing a career in graphic design.No prior experience...

Students will learn all the essential tools and techniques to perfect photo manipulation. Our most comprehensive Photoshop course, taking you from Photoshop beginner to Photoshop master in 5 days. The trainer will show you step-by-step how Professional Graphic Designers use Photoshop on a range of different photo editing jobs. This...