Office Productivity Classes in Los Angeles, CA

The Excel at Excel workshop is designed for students who are relatively familiar with other office productivity software, for example Microsoft Word. (The students who succeed the most are comfortable using a computer and navigating around desktop programs on their own). It introduces a range of Excel topics giving students a taste of the potential...

MS Excel can never be displaced by any technology and every organization uses it in one way or the other. Enrolling in Sprintzeal's Advanced Excel training in Los Angeles CA will ensure you have the basic skills to promptly and efficiently carry out day to day activities at work. Although technology has immensely evolved with various high-level programming...

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

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 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 workshop, we will move beyond the basics of spreadsheet creation. Topics will include data manipulation and advanced functions to summarize and analyze data having multiple attributes. We will also introduce using slicers with PivotTables, creating interactive charts and dashboards, and using advanced formulas.  In-class exercises will...

48 Course Hrs Introduction to Microsoft Access 2016 Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records. Intermediate Microsoft Access 2016 Do you want to take your Microsoft Access skills to the next level?...

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

Bring your creative ideas to life with Adobe Photoshop, the professional digital imaging standard, used by photographers and designers who want to perfect their digital images. Photoshop allows you to create powerful images and designs. This 1-day beginner workshop is designed to get you up and running quickly in Photoshop.  You will learn...

On this beginner class students will learn all the everyday tasks and features within Microsoft Outlook, including sending and receiving mail, managing messages, customizing your messages, calendar and appointments, notes, tasks, and managing contacts. Course Outline Outlook Essentials Getting Started Exploring the Outlook Window Navigating...

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

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

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

Learn the industry standard tool for creating rich imagery for a variety of applications including video, print and the web in this comprehensive two-day Photoshop training. Through hands-on practice, you will create, edit and apply special effects to images and text that can be prepared for various uses such as print and marketing materials, presentations,...

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