back to Course List

Course details:

Getting more out of Excel

Course Duration:
Half-day
Prerequisites:
Intermediate Excel or can show a similar level of skill.
Target Audience:
For people who have done Intermediate and want a refresher, those wanting to prepare themselves for Advanced, or those for whom full Advanced is not necessary.
Topics include:
  • Goal Seek Formula
  • Making the most of Pivot Tables
  • A good look around all types of Absolute References
  • The Vlookup Formula
  • If Statements and all their variations, including nesting the statements
  • Conditional Formatting
  • Making the most of Hyperlinks in Excel
  • ‘Go To Special’, selection based on your own criteria.
  • Trainer’s Tips

back to Course List