Discover Classes. Earn Rewards.

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
Save to WishList

1 person saved this class

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