Discover Classes. Earn Rewards.
Data Analyst Training
Los Angeles
Learn how to analyze big data with hands-on and comprehensive data analyst classes in Los Angeles. Gain valuable skills in data mining, statistical analysis, and data visualization that will boost your career and make you an invaluable asset in the tech industry.
Follow
20 following
25 classes have spots left
Excel Beginning 1: Your First Worksheets
Accelerate Computer Training @ 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...
$119
Excel PivotTables: Data Summarization and Analysis
Accelerate Computer Training @ 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)....
$179
Excel at Excel: Getting Down to the Basics
General Assembly @ Online Classroom, 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 that can be achieved with Excel. It touches briefly on everything from navigation and layout to using...
Data Analyst Classes Gift Card
Thousands of classes & experiences. No expiration. Gift an experience this holiday season and make it a memorable one. Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Excel Bootcamp
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 data. Dive into formula writing, combining formulas, creating basic to intermediate charts, and, of...
MS Excel: Databases, Pivot Tables and Pivot Charts
Santa Monica College @ SMC Bundy Campus, Santa Monica, CA
Advanced MS Excel: Working with Databases, Pivot Tables and Pivot Charts In a follow-up class to Intermediate MS Excel, continue building your skills as you learn how to use filters, how to work with subtotals, how to link data to a drop-down menu, how to create Sumif formulas, and how to make the most of pivot tables and pivot charts to take large volumes of data and summarize them in seconds, giving you valuable information efficiently. ...
$129
Intermediate MS Excel: Formatting Data like a Pro
Santa Monica College @ SMC Bundy Campus, Santa Monica, CA
In a follow-up class to Basics of MS Excel, get a quick review of basic formatting, and find out about conditional (if/then) and two-color formatting. Also, learn how to write a selection of advanced formulas, and how to work with named ranges and using names in formulas. You will have an individual computer to work on during class.
$129
Word & Excel: Level 1 The Basics
El Camino College @ 16007 Crenshaw Blvd, Torrance, CA
Word and Excel are two of Microsoft Office’s most powerful programs and absolute essentials within the business environment. Need to learn these programs for work? Or do you just want to use Word to create great looking documents; and use Excel for calculating your household expenses or tracking your collections of books and music? In this hands-on course, you’ll learn all the most useful features of both Word and Excel, including...
Excel 2013 Programming with VBA Course
Prerequisite Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Getting Started Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Understanding Macro...
Excel 2010 Programming with VBA Course
Prerequisite Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Getting Started Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Understanding Macro...
Excel 2007 Programming with VBA Course
Prerequisite Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required. Getting Started Introducing Visual Basic for Applications Displaying the Developer Tab in the Ribbon Recording a Macro Saving a Macro-Enabled Workbook Running a Macro Editing a Macro in the Visual Basic Editor Understanding the Development Environment Using Visual Basic Help Closing the Visual Basic Editor Understanding Macro...
Power View Level 1
ONLC Training Centers @ 450 N Brand Blvd, Los Angeles, CA
Introduction to Power View Installing Power View Canvas Field List Field Well Filters Area View Area Ribbon Loading Data Report Design Titles Adding Fields Filtering, Formatting and Sizing a Visualization Using Tiles Additional Visualizations Setting the Table Including Images Creating a Matrix Report Creating a Card Report Charting Basics Creating a Chart Chart Components Enhancing a Chart Cart Icons Cart Titles Data...
Excel VBA Programming: Add Power & Interactivity
Learn to create automated custom Excel applications using VBA. This is the second 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 Loop Structures For Loops Do Loops Code to Move the Cell Pointer and Select Ranges User-Interactive Worksheets...
Excel Bootcamp
This bootcamp is an excel class that is designed to provide beginner participants with a general overview of Excel topics and specifically a good understanding of several different functions. It combines most of the material and key topics from the two workshops into an intense one-day class. Given the short timeframe and large amount of topics covered, beginner participants are expected to be able to learn quickly. The bootcamp is designed for participants...
Tableau Desktop Level 1: Intro for Experienced IT Professionals
ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA
Tableau has for some time been one of the most popular Business Intelligence and data visualization tools available. Why? Because, quite simply, it’s a tool that’s responsive to the needs of modern business. But it’s most effective when you know how to get what you want from it – it might make your business intelligent, but it isn’t going to make you intelligent. We’ll make sure you’re well prepared to take full advantage of Tableau's...
Word & Excel: Level 2 Advancing through Word and Excel
El Camino College @ 16007 Crenshaw Blvd, Torrance, CA
Once you are able to navigate your way through the basics of Word and Excel, you’re probably ready to explore what more these two powerful Microsoft Office programs can offer: After a short review, we’ll guide you through: Word: We’ll take a closer look at formatting pages; working with styles and themes, creating bullets and numbered lists; working with tables and illustrations, and even how to create macros. Excel: ...
Computer Basics for Everyday + MS Word & Excel
Santa Monica College @ SMC Bundy Campus, Santa Monica, CA
This class discusses Computer, Internet and Email Basics for the Everyday and MS Word and MS Excel for Entering the Job Market. Computer, Internet and Email Basics: This introductory computer workshop is ideal if you need everyday computer basics to cope in the rapidly evolving world of the Internet. Come find out about computer hardware, software, using MS Windows, various browsers for the Internet, email, and file management. Gain...
$119
Power Map Level 1
Power Map Overview Running Power Map The Power Map Window The Power Map Ribbon Region Maps Map Source Data Using the Task Panel Moving Around in Power Map Moving Around a Map Zooming In and Out Changing the Pitch of a Map Flat Map and 3-D Globe Going to a Specific Location Map Types Bubble Maps Column Maps Heat Maps Region Maps Custom Maps Presentation Options Power Map Themes Timelines Using Layers Map Tours Creating...
Tableau Desktop Level 3: Dashboard Deep Dive
ONLC Training Centers @ 10940 Wilshire Blvd, Santa Monica, CA
Master the art of creating dynamic and insightful dashboards with advanced Tableau techniques in this intensive course. Unleash your creativity and learn to build visually appealing and interactive dashboards that will impress and engage users. Take your Tableau skills to new heights and elevate your data visualization game to the next level.
Fundamentals of Microsoft Excel - Creating Spreadsheets
Santa Monica College @ SMC Bundy Campus, Santa Monica, CA
In a one-day professional course on Microsoft Excel 2010, learn how to create a professional worksheet, build formulas on a worksheet, use automatic functions on a worksheet, create professional charts, and sort and filter databases lists. Class combines hands-on experience with lectures and in-class practice exercises. You will have your own individual computer to use during class. Course guide and files of practice exercises included in registration...
$129
Excel 2016 (Mac) Session 4
Accelerate Computer Training @ 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:...
$99
Data Analyst Training in Los Angeles are rated 4.3 stars based on 3,366 verified reviews from actual CourseHorse.com purchasers.
Get it first. Sign up for up-to-the-minute offers, sales and news.
More in Big Data
Made in NYC
© CourseHorse, Inc. 2024 Loading...
