Office Productivity Classes in Los Angeles, CA

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

Virtually everyone who works with data could benefit by gaining a better understanding of Microsoft Excel. This class will extend beyond the simple addition of data and will put participants in a position where Excel is no longer a chore, but a powerful tool to assist in manipulating data efficiently. You’ll learn various functions to help you organize...

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

Simply put, masking is the heart and soul of Photoshop. Masking allows you to make incredibly subtle and complex selections with ease, which in turn opens up a world of image correction, retouching and compositing. One of the principle functions of Photoshop is to adjust images. Adjustments are relatively easy to learn; knowing where and how to...

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

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

Work smarter, not harder. This three-hour session reveals secrets to using Word at maximum efficiency. You will learn how to apply, define, redefine and import styles, which let you make global formatting changes instantly. You will learn how to use section formatting to set headers and footers with page numbers and build multiple column layouts. You...

How your documents look reflects on you, so make them look sharp! In this three-hour session, you will learn how to format paragraphs precisely with indents, tab stops, and line and paragraph spacing, edit text with spell and search-and-replace, and insert professional-looking images and illustrations to strengthen your message. Prerequisites This...

A dashboard is a way to visually present data in summary form. Chart-rich reports visually compare patterns of performance among many charts, making it easier to remember performance results. In this one-day session, problems will be introduced to help you build your dashboard reporting and troubleshooting skills. The last thirty minutes of the class...

In this three-hour session for Windows and Mac users, you will learn how to efficiently produce long documents. You will assemble subdocuments into a master document, add footnotes, cross-references, bookmarks, and a cover page. You will also learn how to make Word do the work of building your table of contents, table of figures, index and bibliography...

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

Full Course Name: "Excel Power BI for Desktop: Data Summarization and Visualization" In this one-day Excel for Windows session, you will learn how to use Microsoft's free Power BI for Desktop app to produce stunning interactive summarization reports full of modern charts/visuals. In class, you will connect to external data sources, create relational...

Bring your creative ideas to life with Adobe Illustrator, the industry-standard vector graphics software, used by designers and illustrators who want to create digital graphics, logos, illustrations, and original typography. This workshop is designed to get you up and running with Adobe Illustrator in just one day. The focus will be on step-by-step...

In this three-hour session for Windows and Mac users, you will learn how to markup or "redline" a document with suggested changes, potentially from multiple authors, and then accept or reject those changes when crafting the final version. You will also learn how to present columnar information in tables and how to draw freeform tables. You will also...