Skip to content ↓

Learning Alliance

PROFESSIONAL SKILLS: Developing Excel Skills

This event will take place between 9:30am and 3:30pm on 26/03/2019.

Venue: Danesholme Junior Academy

The day aims to give practical training on how to make best use of some of the facilities of MS Excel. The day will recap the basics of MS Excel and then moves on to work on more
advanced techniques.

  • Navigating excel/menus Moving and copying data
  • Searching and sorting data Filtering
  • Cell formatting Using multiple worksheets
  • Useful shortcuts Simple formulas (=SUM) etc
  • Adding and removing cells/row/columns etc

More advanced:

  • More advanced formulas IF statements
  • Pivot tables and charts V Lookup
  • Conditional formatting Data validation
  • Trim, concatenate, left/right functions etc
  • Using graphs to present data/reporting
  • Creating drop down menus