Excel Advanced

Course Description: 

Need to learn the advanced functions of Excel to create powerful computerized spreadsheets? If you've already mastered the basics of Excel, MTI's hands-on advanced class is exactly what you need!

If you are very well versed in the basics of Excel and are ready to master the advanced functions of this powerful application, this class is designed to meet your needs. Skilled Excel users can fully utilize the functionality of Excel to develop spreadsheets that can effectively be used as management tools in their organizations. This course is recommended only for those who already possess very strong skills in Excel.

Learning Objectives

This course is designed to provide skilled Excel users with advanced training in this powerful software application. This two-day, hands-on seminar is taught in a computer lab. Participants will receive practical, hands-on training on an individual PC and can choose to work on Excel version 2007 or 2010.

Topics Covered Include:

  • 3-D References
  • VLookup, HLookup
  • Sorting Data
  • Filtering Data
  • Date and Time Functions
  • If Functions
  • Hide/show formulas/values
  • Images and Drawing Objects
  • Inserting & Formatting Images
  • Group Editing / Collaboration Tools
  • Charts & Tables
  • Pivot Tables

Course Category: