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

On this class you will learn the fundamentals of Microsoft Word. You will create, edit and format documents by adding paragraphs, tables, lists, images, design elements, layout options and styles before printing or sharing your documents. No prior experience of Word is needed. Suitable for Word 2010/2013/2016 users.  Detailed course outline...

This course will introduce students to spreadsheets and the fundamentals concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly.  Learn how to:  Quickly set up workbooks Enter data, and format it for easier viewing Perform calculations and find and correct errors Visualize data with charts and...

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 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 for Windows and Mac users introduces you to Excel’s interface and fundamental capabilities. By the end of the session, you will be easily getting around in Excel’s Ribbon-based interface, able to enter and edit labels, values and dates, extend series of dates and months, cut and paste entries, insert and delete cells and...

This course will teach students advanced tasks in Microsoft Excel. In this advanced Excel course, you will learn about:  Alternative Data Sets Dynamic Worksheets with PivotTables Automating Repetitive Tasks with Macros Working with Other Microsoft Office Apps Business Intelligence Analysis and Forecasts and Visualizations Excel Versions...

In this one-day course, you will learn how to write formulas, creating calculated fields, doing math with dates, and writing expressions in queries and validation rules. You will also create sophisticated data entry forms, including navigation forms and subform containers. Finally, you will design reports and subreports, including using variables as...

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

Students will learn how Professional Graphic Designers use Photoshop on a range of different design jobs. This course teaches beginners, step-by-step, how to create cutting-edge graphics and special effects with Photoshop. Target Audience: This Photoshop training is ideal for designers, marketers and anyone who is pursuing a career in graphic design....

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

This hands-on intermediate class is suitable for Excel 2010/2013/2016 users. You will learn to share data across multiple worksheets and workbooks, work with named ranges, filter and sort data, use PivotTables and PivotCharts, conditional formatting, advanced charting, and how collaborating with others.  Live face-to-face instructor. No minimum...

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