Office Productivity Classes in Los Angeles, CA

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

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

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

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

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

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

Designed for people who "learned on the job" as well as those who have never used spreadsheet programs before, this course teaches functions and features of Excel 2016. After an introduction to spreadsheet terminology, you will learn how to navigate worksheets, enter and edit text, values, and formulas. You will learn about absolute and relative references,...

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

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

A dashboard is a single screen used for reporting that displays charts, tables, and other visual data components on a related subject. Learn how to create Dashboards that will transform business data into actionable information. You will: Create an interactive, dynamic information source within Excel without creating a monster workbook or submitting...

This course is designed to provide students with a basic to mature ability to collect, enter, and perform calculations with data in MS-EXCEL spreadsheets, and to utilize basic statistical techniques to analyze and present the data in words, graphs and charts. These skills will be useful in securing entry level IT positions in industry. Key topics...

MS Word for Windows allows you to create and format personal and professional documents and tables of all kinds. Level 2 covers how to use mail merge, work with tables, charts and graphics and how to customize documents.  Students must have MS Office Word software installed on their computer. Prerequisite: MS Word Level 1 or equivalent knowledge. ...