Data Analyst Training
Los Angeles
Classes near you
Classes near you
0 classes with availability
Intermediate Excel 2016 for Windows
West Los Angeles College See all classes by this school @ Fine Arts Bldg, Los Angeles, CA
This class will be held remotely through live videoconferencing. This hands-on intermediate class picks up where the basic Excel 2016 class left off. Topics include calculations and built-in functions, sorting data, creating templates, renaming and moving worksheets, inserting and deleting cells, rows and columns, and adding graphs and charts. Note, this is not a beginning Excel class. You must understand basic Excel functions like editing,...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$79
Microsoft Excel
OC Forward See all classes by this school @ 4590 MacArthur Blvd, Newport Beach, CA
If you think you know Excel, think again. Knowing how to work with Microsoft Excel and being able to put it to use in business are two different things. You will learn how to build formulas, create lookups, and create useful, meaningful, and timely reports for business.
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$40
SQL Server 2017 Reporting Services
Hands On Technology Transfer, Inc. See all classes by this school @ <b>(Exact location to be announced)</b>, Los Angeles, CA
All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility. This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility. All reports are developed utilizing SQL Server Data Tools (SSDT), however Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
Cloud& Datacenter Monitoring with System Center Ops Mgr
ONLC Training Centers See all classes by this school @ 7700 Irvine Center Dr, Los Angeles, CA
This course equips students with the skills they require to deploy and configure System Center 2012 R2 Operations Manager. Using hands-on labs, students learn the following: • How to architect and implement a System Center 2012 R2 Operations Manager Management Group. • How to upgrade and migrate from an existing Operations Manager 2007 R2 Management Group to System Center 2012 Operations Manager, System Center 2012 SP1 Operations Manager and...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
SAS Fundamentals
ONLC Training Centers See all classes by this school @ 10940 Wilshire Blvd, Santa Monica, CA
Do you want to create data analysis reports without writing a line of code? This course introduces SAS programming using SAS Studio. The power of SAS Studio comes from its visual point-and-click user interface that generates SAS code. All that you will learn in this course, you can apply seamlessly using SAS Enterprise Guide or SAS Viya as all platforms use the same programming language and same syntax. It is easier to learn SAS than to learn R...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
Excel VBA Macros: Write Custom Excel Macros in VBA
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
Learn to create automated custom Excel applications using VBA. This two-day VBA Programming course helps advanced Excel users (Windows only) develop new skills writing and debugging powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors. Prerequisites: This class is ideally suited for experienced Excel users who want to learn how to write programming code using Visual Basic...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
Excel VBA Programming
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
Excel VBA Programming Day 1: Write, Edit and Debug VBA Code in Excel Macros Learn to create automated custom Excel applications using VBA. This is the first day of our two-day VBA Programming course, which helps advanced Excel users develop new skills to write and debug powerful VBA code to automate workbook operations, create interactive forms, insert calculations and handle run-time errors. Course Outline VBA Concepts - The Object Model Hierarchy...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$395
Excel Beginning 1: Your First Worksheets
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
This three-hour session for Windows and Mac users 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, values and dates, extend series of dates and months, cut and paste entries, insert and delete cells and sheets, and set print attributes like headers and footers, print area and print titles. Course Outline...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$119
Excel PivotTables: Data Summarization and Analysis
Accelerate Computer Training See all classes by this school @ 200 Pine Ave, Long Beach, CA
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, rearrange columns and rows, apply filters, slicers and grouping (both manual and automatic)....
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$179
Excel Advanced 2: Advanced Formulas
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 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 calculations in a single result. Finally, you will gain essential formula auditing and troubleshooting...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$195
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...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$149
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...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$149
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....
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$99
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:...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$99
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...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$99
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...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$149
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...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$119
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...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$179
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...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$119
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...
This class isn’t on the schedule at the moment, but save it to your Wish List to find out when it comes back!
$149
