University of Southern Indiana

Microsoft Excel Advanced Level III

Take your Excel skills even higher by attending USI’s non-credit Excel Advanced Level III training.  This Level III training is for very experienced users who want to go beyond the intermediate user level and learn advanced features.  

The training will be six hours in length with a one-hour break for lunch. Training will be hands-on so participants must bring their own laptop to the training.  A training manual will be provided to you at the training.

The content of the training will cover:

  • Import .txt files
  • Clean up errors in imported files
  • Create advanced functions including:  PROPER, VLOOKUP, IFNA,MATCH, INDEX, MATCH/INDEX, COUNTIFS, SUMIFS
  • Use data analysis using goal seek and data tables
  • Use conditional formatting
  • Linking workbooks
  • Create and edit PivotTables and PivotCharts
  • Create, edit, and debug macros

ERROR: If you are seeing this message, you have reached an error. Try using an internet browser other than Internet Explorer (Google Chrome, Firefox, Safari). If you have tried a different browser and are still seeing this message, please call us at 812-464-1989.

Contact Bill Groves


Send Email to