(310) 598-7080
company catalog schedule discounts register contact

LA Downtown Branch

Register:

Related Classes:

Serving:

Price: $350 for one day
Time: 9am - 4:30pm
Held at: 915 Wilshire Blvd. Suite 1800
Los Angeles, CA 90017
checkmark Onsite training available
checkmark 1-on-1 training available
Call us for details

Excel Lookups, Functions, and Macros - Los Angeles

Macros, collaboration, security are the foundations of this advanced Excel class. You will learn about different scenarios and how to use what if analysis. Advanced functions and much more are also covered:

  • Using IF, SUMIF, and COUNTIF to process data based on rules
  • Using the VLOOKUP, INDEX and MATCH functions to find data in related worksheets
  • Auditing: how to find errors using tracing, IFERROR, and other functions
  • Defining arrays and using array functions to work with groups of data
  • Advanced functions for manipulating dates, times, text
  • Statistical and financial functions
  • Importing external data from the web
  • Scenarios using goal seek, scenario manager and input data tables
  • Using the Analysis Toolpack for correlations and histograms
  • Recording and replaying macros and basic VBA code
  • Creating a form with buttons to add interactivity to your spreadsheet


* Note: This class description is for our Excel course in downtown Los Angeles. We also offer the same excel course in San Diego, San Jose, Sacramento and San Francisco.

Adobe Authorized Training Center Microsoft Certified Partner Google Certified Partner
Newsletter subscribers can win $100 credit! | Privacy Policy | Terms of Use    Social Media Buttons AcademyX on Facebook AcademyX on Google+ AcademyX on LinkedIn AcademyX on Twitter AcademyX on Youtube