Excel: Acquiring Critical Skills For Data Manipulation

London Met invests in you: from our purpose-built newsroom to our state-of-the-art superlab, we aim to create a stimulating and unique learning environment for our students. Our courses have received top marks from the UK's Quality Assurance Agency and many are accredited by a wide range of professional bodies. Our lecturers are leaders in their field: in the latest Research Assessment Exercise, over two-thirds of the University’s research output was judged to be world-leading, internationally excellent or internationally recognised.

We go the extra mile with our investment. We do this through our five-star promise, our pledge to connect our students with opportunities to boost their career skills. We put employability at the heart of our curriculum through helping you find placements, work experience and voluntary opportunities across a wide variety of organisations.

Topics to be covered include:

• Lookup tables, pivot tables, goal seek analysis and scenario reports
• Recording macros, embedding macros & Conditional Formatting
• Functions: max, min, average, sum, count and IF
• The macro programming environment