Discover Classes. Earn Rewards.
Excel Level 3 Advanced is unfortunately unavailable

Thankfully we have 28 other Excel Classes for you to choose from. Check our top choices below or see all classes for more options.

Excel Level 3 Advanced

at American Media Training Los Angeles - Westchester

Course Details
Price:
$350
Start Date:

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!
If you're enrolled in an upcoming date, this simply means that date has now sold out.

Location:
Westchester, Westside
9841 Airport Blvd Ste 1200
Btwn W 98th St & W Century Blvd
Los Angeles, California 90045
(Map)
Share:
Purchase Options
Description
Class Level: Advanced
Age Requirements: 18 and older
Average Class Size: 8

What you'll learn in this excel class:

Take your Microsoft Excel skills to new heights with our Advanced Excel course, which continues where the Excel 2007/2010 Intermediate course left off. Our Microsoft Excel classes have been crafted to help you develop skill with both Excel 2007 and Excel 2010. As a result, you will accomplish more by taking full advantage of Excel's power: more powerful calculations, more effective data analysis, more time saved with automated routines, more successful data presentations - make sure you know exactly what Excel can do for you.

Course outline

Advanced Functions in Excel
  • Automate your work with logical functions (IF, AND, OR, NOT, IFERROR) that calculate values based on criteria you specify
  • Apply math and statistical functions to calculate conditional sums and averages
  • Use financial functions, such as the PMT function, which calculates loan payment amounts 
V Lookups and Data Tables in Excel
  • Create lookup functions to find exact or approximate matches in lists of data
  • Use the MATCH function to determine a specified value's relative position in a list
  • Use the INDEX function to return a value based on a specified cell in a range
  • Create "what-if" scenarios with one-variable and two-variable data tables 
Advanced List Management in Excel
  • Set up cells to accept only valid dates, whole numbers, or other valid values you specify
  • Use database functions to summarize values that meet complex criteria, for example, the total sales in a specific region for a specific year 
Excel PivotTables and PivotCharts
  • Create and use interactive PivotTables to analyze and compare large amounts of data from your workbooks or from external databases
  • Make a PivotTable easier to read with effective automatic formatting
  • Create a PivotChart to graphically display PivotTable data 
Exporting and Importing within Excel
  • Export your Excel data to a text file that can be read by other programs
  • Import data from a text file and organize it automatically into appropriate columns
  • Easily remove duplicate rows from your imported data
  • Create an XML map that maps your Excel data to an XML schema
  • Use Microsoft Query to access data in external databases
  • Set up a Web Query to automatically pull data such as online currency quotes or stock quotes from the web 
Analytical Options
  • Perform a simple one-variable "what-if" analysis using the Goal Seek utility
  • Perform complex "what-if" analyses with multiple variables using the Solver utility
  • Expand your data analysis capabilities with the tools in the Analysis ToolPak, including Random Number Generation, Histogram, Regression, Sampling tools and many more
  • Simplify your budget planning by creating and easily switching between Scenarios
  • Save time by saving Views with different worksheet display and print settings 
Macros & Custom Excel Functions
  • Determine when a macro makes sense
  • Record and run macros that work for you
  • Enable and disable macros in a spreadsheet
  • Make changes to existing macros using the Visual Basic Editor
  • Create custom functions for your business, for example, a Profit function with sales and cost arguments 
Conditional Formatting and SmartArt
  • Use data bars or icon sets to graphically display how different cell values compare to each other
  • Communicate with color by setting up color scales to automatically format cells depending on their values
  • Get your message across by inserting and customizing SmartArt graphics

Still have questions? Ask the community.

Map

Google Map

American Media Training Los Angeles

All classes at this location

Start Dates (0)

This class isn't on the schedule at the moment, but save it to your Wish List to find out when it comes back!

Similar Classes

Benefits of Booking Through CourseHorse

Booking is safe. When you book with us your details are protected by a secure connection.
Lowest price guaranteed. Classes on CourseHorse are never marked up.
This class will earn you 3500 points. Points give you money off your next class!
Questions about this class?
Get help now from a knowledge expert!
Questions & Answers (0)

Get quick answers from CourseHorse and past students.

School: American Media Training Los Angeles

 

American Media Training provides quality certified instructor led training for Adobe, Quark, Apple and Microsoft software products. We offer regularly scheduled public courses as well as customized on-site training. We also offer live online training.

At American Media Training our training courses are...

Read more about American Media Training Los Angeles

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified LA educator.

Want to take this class?

Save to Wish List
Taking this class for work? Get exclusive perks & discounts for free.

28 Top Choices

Excel at Excel: Getting Down to the Basics

at General Assembly - Downtown 360 E 2nd St Ste 400, Los Angeles, California 90012

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

Wednesday Jun 26th, 6:30pm - 9pm

Excel VBA Macros: Write Custom Excel Macros in VBA

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

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. Prerequisites: This class is...

Tuesday Jun 25th, 9am - 4pm

  (2 sessions)
$895

2 sessions

Excel Beginning 1: Your First Worksheets

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

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

Saturday Jun 29th, 9am - 12pm

Excel One-Day Bootcamp

at General Assembly - Downtown 360 E 2nd St Ste 400, Los Angeles, California 90012

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

Saturday Jun 29th, 10am - 4pm

Excel PivotTables: Data Analysis with PivotTables

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyze, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance for...

Tuesday Jul 2nd, 1pm - 4pm

Excel Intermediate 2: Queries, Subtotals & Tables

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

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

Friday Jun 21st, 1pm - 4pm

Microsoft Excel Level 1

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

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

Tuesday Jul 9th, 9am - 4:30pm

Microsoft Excel Level 2

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

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

Wednesday Jul 10th, 9am - 4:30pm

Microsoft Excel Level 3

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This hands-on class is suitable for Excel 2010, 2013 and 2016 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,...

Thursday Jul 11th, 9am - 4:30pm

Excel Intermediate 1: Simple Formulas

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

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

Friday Jun 21st, 9am - 12pm

Excel Level 3

at Certstaffix Training - Downtown 355 S Grand Ave Ste 2450, Los Angeles, California 90071

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

Wednesday Jul 3rd, 7am - 2pm

Excel Advanced 1: Automating Tasks

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

In this half-day session, 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. Outline Working on Multiple Sheets Simultaneously selecting ranges of worksheets selecting...

Monday Jun 24th, 9am - 12pm

Excel Advanced 2: Advanced Formulas

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

In this half-day session, 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....

Monday Jun 24th, 1pm - 4pm

Excel Beginning 2: Cell Formatting and Charting

at Accelerate Computer Training - Long Beach 200 Pine Ave Ste 280, Long Beach, California 90802

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

Saturday Jun 29th, 1pm - 4pm

Excel Level 1

at Certstaffix Training - Downtown 355 S Grand Ave Ste 2450, Los Angeles, California 90071

This course will introduce students to spreadsheets and the fundamentals concepts of Microsoft Excel. Learn these features of Microsoft Excel and get more done quickly.  Learn how to:  Quickly set up workbooks Enter data, and format it for easier viewing Perform calculations and find and correct errors Visualize data with charts and...

Monday Jul 1st, 7am - 2pm

Excel Level 2

at Certstaffix Training - Downtown 355 S Grand Ave Ste 2450, Los Angeles, California 90071

This course will teach students how to perform more advanced calculations and work with larger worksheets in Microsoft Excel. In this intermediate Excel course, you will learn how to:  Perform Calculations on Data Manage Worksheet Data Reorder and Summarize Data Combine Data from Multiple Sources Analyze Alternative Data Sets and Collaboration...

Tuesday Jul 2nd, 7am - 2pm

Excel: Dashboards

at Certstaffix Training - Downtown 355 S Grand Ave Ste 2450, Los Angeles, California 90071

This course builds upon the foundation knowledge presented in the Excel - Level 1 course and will help start you down the road to creating advanced workbooks and worksheets that you can use to create a dashboard. The ability to analyze massive amounts of data, extract actionable intelligence from it, and present that information to decision makers...

Friday Jul 5th, 7am - 2pm

Word & Excel: Level 2 Advancing through Word and Excel

at El Camino College - Torrance 16007 Crenshaw Blvd, Torrance, California 90506

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

Saturday Jul 6th, 12:30pm - 3:30pm

  (3 sessions)
$79

3 sessions

Excel 2016 for Windows

at West Los Angeles College - Culver City Fine Arts Bldg 9000 Overland Ave, Los Angeles, California 90230

Excel 2016, the most popular spreadsheet program, has powerful features that allow you to analyze and manipulate financial and mathematical data. It’s great for budgets, simple bookkeeping, an easy database, or making charts and graphs.  In this hands-on beginning class, you’ll learn the basic concept of how a spreadsheet works, how to enter...

Monday Jul 8th, 7pm - 10pm

  (2 sessions)
$125

2 sessions

Microsoft Excel Level 4 - Macros & VBA

at Training Connection - Downtown 915 Wilshire Blvd Ste 1800, Los Angeles, California 90017

This instructor-led course covers automation and customation of Excel using macros and screen items (such as buttons and menus). Trainees learn how to write macros using VB code and assign macros to screen items. Live face-to-face instructor. No minimum class size - all classes guaranteed to run! Prerequisite Students are expected to have completed Excel...

Friday Jul 12th, 9am - 4:30pm

Loading...