All Software Training 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,...

Our most popular course taking you from Premiere Pro beginner to master in 5 days. You will also learn to work with Encore, Speedgrade and Prelude.  Target Audience: Anyone looking to get into video editing. No prior experience of Premiere Pro is needed.  Intro: Real-World Usage of Premiere Pro What is Premiere Pro? New Premiere Pro...

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

Students will learn to create compelling video. The course covers capturing, editing, special effects, graphics, titles and to final production. Target Audience: Graphic and video professionals looking to use Adobe Premiere Pro to create stunning video productions. No prior experience of Premiere Pro is required. Detailed Course Outline Intro:...

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

In this three-hour session, you will learn the basics of how to use the most popular of the Google apps, including Gmail, Calendar, Notes, Tasks, Docs, Sheets, and Drive. You will send and receive email, with attachments, schedule and share events in your calendar, and keep notes and tasks. You will also create simple word processing and spreadsheet...

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

Students will learn more on creating special effects for video and motion graphics. Target Audience: Graphic and Video professionals who need an essential understanding of video editing, motion editing and compositing. Experienced users will also benefit from many hands-on projects and tricks learnt on the class. No prior experience of...

This two-day class, taught by a FileMaker Certified Developer and Business Alliance Trainer, will teach you the essential skills to develop simple database solutions on the FileMaker platform. You will learn how to plan database structure and create Entity-Relationship diagrams, define tables, fields and relationships, import data, create layouts for...

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

In this three-hour session, you will gain skills vital to using your Mac effectively, including using the mouse and keyboard, working with windows, launching applications, creating and saving documents, creating new folders and the basics of using applications and the Web. Prerequisites This class is designed for new computer users or those new to...

In this first day of our two-day hands-on training, you will learn how to edit video in Premiere Pro using industry-standard techniques and workflows. After touring the interface, you will set up a project, import video and stills, organize your media, edit on the Timeline, work with clips and markers, add transitions and explore a few of Premiere's...

This 2-day class, taught by FileMaker Business Alliance Trainer Tim Jones, will sharpen your skills as a FileMaker developer. Build better layouts, smarter calculations and scripts, and add subsummary reports and dashboards.  This class, along with our other FileMaker classes, will also help prepare you for the FileMaker Certified Developer exam....

On this 2-day hands-on class you will learn advanced video editing, titling, effects and compositing. You will also work with Adobe SpeedGrade, Prelude and Encore. Target Audience: Students should have already completed our Premiere Pro Fundamentals class prior to attending. Upon successful completion of this course students will be able to do:...

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