Excel Advanced

Chicago
Wednesday May 02, 2018
9AM - 4PM

$299.00 / Student

Price

$299 / Student

REGISTRATION FORM

Enter the below information for each student.

Total Due $299

About Our Classes

  • Small class sizes - typically six to ten students
  • Instructor in the classroom at all times!
  • Students work at our computers during the training
  • Student manual and practice exercise files included
  • Free class retake within six months of attending class!

DESCRIPTION

Students will work with advanced formulas, learning functions such as VLOOKUP, HLOOKUP, MATCH, INDEX, IF, ROUND , PMT, and IFERROR. In addition, students will learn about data validation and analytical functions SUMIF, COUNTIF, AVERAGEIF, and creating formulas with dates. They will learn how to import and export XML data, and how to query external databases. Finally, students will learn about the analytical features of Excel (such as Goal Seek and Solver) and running and recording macros.

This is a unique website which will require a more modern browser to work!

Please upgrade today!