All Software Training
Los Angeles
Classes near you
Classes near you
0 classes with availability
Excel Intermediate 2: Queries, Subtotals & Tables
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
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 rows that meet your criteria. Prerequisites This class is suited for people who have taken Excel levels...
Excel Intermediate 1: Simple Formulas
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
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) when duplicating formulas. Prerequisites: This class is ideally suited for people with basic Excel...
Photoshop CC Day 2: Layers, Colors, Selections & Type
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this one-day Adobe Authorized training class, you will learn how to create, link and group layers and how to apply color, including CMYK safe colors, custom and spot colors. You will also learn one of Photoshop's most important skills: how to make and save selections using the Marquee and Lasso tools as well as Quick Select and the Magic Wand tool. Learn how to add to or subtract from selections and how to avoid hard edges. Finally, you will move,...
Photoshop CC Day 3: Layer Masks, Color Correct, Retouch
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this one-day Adobe Authorized training class, you will learn the art of correcting and retouching images. First, you will learn to create and apply layer masks. You will then make non-destructive adjustments and color corrections, retouching images using techniques the pros use on magazines covers. You will also learn how to restore old images, removing cracks, scratches and dust. Course Outline Layer Masks creating and applying layer masks...
Excel 2016 (Mac) Session 3
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this half-day session, you will learn Excel's data management and summarization tools, which let you turn large amounts of raw data into concise, meaningful reports and charts. This course will let you import external data, convert data into a table, apply automatic totals and use AutoFilter to show only rows that meet your criteria. You will sort by multiple columns, generate automatic subtotals on sorted data, including multi-level subtotals....
Excel 2016 (Mac) Session 4
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this half-day session, you will learn how to work on multiple worksheets simultaneously. You will also learn how to set up several what-if analysis models using Goal Seek, Scenario Manager and one- and two-input data tables. And for maximum efficiency, you will learn to use styles-based formatting to format worksheet cells globally as well as how to record and edit simple macros. Course Outline Group Mode: Working in Multiple Sheets:...
Excel 2016 (Mac) Session 5
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this half-day session, you will create sophisticated charts and complex formulas using functions. You will learn to chart noncontiguous data, create dual-axis charts for comparing vastly disparate data sets, and combine column and areas markers on the same chart. You will learn how to make 3-D charts more effective by controlling the stacking order of the series, and add trendlines to 2-D charts. You will also expand your ability to write complex...
PowerPoint (Mac) Beginning: Effective Presentations
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
PowerPoint (Mac) Beginning: Create Effective Presentations In this class, you will learn how to create effective, engaging presentations using the most efficient techniques available. You will start a new presentation, apply a template or theme, add and import text, and then use Slide Masters to customize backgrounds, color schemes, text formatting and placement of text throughout the entire presentation. Prerequisites This class is designed for...
Excel Beginning 2: Simple Formulas
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
This three-hour session introduces you to creating 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) when duplicating formulas. Prerequisites: This class is ideally suited for people with basic...
Excel (Mac) Basics: Your First Worksheets
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
This half-day session 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 and values, write basic math formulas, use calculation functions, move and copy entries and duplicate formulas using absolute and relative referencing. Course Outline Introduction to Excel: what can I do with Excel? learning the...
Word Advanced 2: Produce Long Documents
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
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 for you automatically. Prerequisites This class is ideally suited for people who have attended...
Excel Dashboard Reporting: Intro to Dashboards ..
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
Excel Dashboard Reporting: Intro to Dashboards Using Excel 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 will be spent addressing specific questions...
Excel Beginning 2: Cell Formatting and Charting
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this three-hour session, you will learn the most efficient ways to format cell text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart elements, and how to create and enhance dual-axis and combination charts. Prerequisites: This class is ideally suited...
PowerPoint Beginning: Create Presentations Efficiently
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this three-hour session for Windows and Mac users, you will learn how to create effective, engaging presentations using the most efficient techniques available. You will start from a blank presentation, apply a design theme, add and import text, and then use Slide Masters to customize backgrounds, color schemes, text formatting and placement of text throughout the entire presentation. Prerequisites This class is ideally suited for people with...
Google Apps: Intro to Gmail and the Google Apps
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
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 files and learn how to save and return to them on your Google Drive. Prerequisites This class is...
PowerPoint Intermediate: Illustrate Your Presentations
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this three-hour session, you will learn how to strengthen the message of any PowerPoint presentation by adding SmartArt graphics, AutoShapes, photos, charts and tables. You will insert clip art and photographic images, remove image backgrounds and optimize images to reduce file size. You will transform plain bullet text into captivating SmartArt graphics and use the built-in drawing tools to create custom illustrations. You will create pie charts...
Excel Tips and Tricks: Essential Time-Saving Techniques
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
Excel is one of the most complex and powerful software programs ever created, and becoming skilled in Excel can take many years! In this lively three-hour training session, you will learn many tips and tricks that will save you time every time you use Excel. We guarantee you will learn techniques worth remembering! Class Outline Formulas Display Formulas Instead of Results Display Cell Values When Creating or Editing Formulas Highlight All...
Visio Pro 2: Create Process Diagrams and Org Charts
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
Upon successful completion of this three-hour course, you will create process diagrams like flowcharts and workflow diagrams and represent an organization hierarchy as a Visio diagram. This course will focus on creating process diagrams and org charts. You will have the opportunity to put all your Visio skills to work in a final exercise under the close guidance of your expert instructor. Course Outline Creating Process Diagrams: Create a fllowchart...
Word Intermediate 1: Tabs, Indents, Graphics & Proofing
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
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 class is designed for people who have attended our Word Beginning class or who are comfortable performing...
Excel Intermediate 1: Cell Formatting and Charts
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
In this three-hour session, you will learn the most efficient ways to format text, dates and numbers, applying and defining cell styles to automate formatting. You will also create several types of charts, learning how much data to select, which chart types will best present your data, how to add and format various chart elements, and how to create and enhance dual-axis and combination charts. Prerequisites This class is ideally suited for people...