Already a member?
Login now to see member only prices and resources

Programme type:


Sign in

Ticket Price:

Member - £100.00 (+VAT)

Non-member - £120.00 (+VAT)

At a glance…

In business, it is important that the data stored by an organisation is accessed, manipulated and analysed in a secure and robust manner. 

This course examines how data can be successfully manipulated and analysed, investigates advanced data analysis and functions, along with an introduction to macros and Visual Basic for Applications. The course is designed as a practical workshop, allowing the participant to receive hands-on experience of all topics covered.

Join us over two half days sessions, for our 2-part Advanced Excel programme facilitated by Accredited Microsoft Master Instructor, Louise Friel and receive support on all the key components within the programme so you can use it confidently and ensure that you no longer need to scower Youtube for answers. 

Module 1: Advanced Functions
  • IF / AND / OR
  • Nested IF
  • Lookups
Module 2: Subtotals & Pivot Tables
  • Single/ Multiple Subtotals
  • Pivot tables
    • Multidimensional
    • Multi-functions
  • Pivot Charts
Module 3: What IF - Forecasting
  • Goal Seek
  • Solver
  • Scenarios
  • Data Tables
Module 4: Macros
  • Security
  • Recording & running Macros
  • VBA Code
  • Relative References
  • Macro Buttons & Toolbars

Louise Friel - Desktop Genie

Louise Friel - Desktop Genie

IT Consultant and Owner

Louise facilitates our Excel Essentials programme. Louise is an IT professional with over 30 years' experience in IT and telecommunications and is the owner of Desktop Genie which provides IT consultancy and business solutions. Louise provides a range of specliast IT Training including MS Excel, MS Word, MS Access, MS Project and marketing through Twitter and LinkedIn training. She is an Accredited Microsoft Master Instructor and an accredited ECDL and Advanced ECDL Tester.


Member price £100.00 (plus VAT)
Non-member price £120.00 (plus VAT)

To query booking individual modules please contact

Upcoming in-take

Starting Tuesday 5 December 2023

Already a member? Sign in to access member discounts
Read Programme T&C's

“I really enjoyed this training, and it is definitely something that I will be able to bring back to the workplace. The training was interactive and any questions I had, were happily received and responded to. ”

Niamh Kelly


“Louise was so lovely. Made everyone feel included, no question too daft. Understood her teaching style instantly - thoroughly enjoyed and benefited from today and yesterday. I've already started putting the tools to good use. ”

Heather Reid

Legacy Resources 247

“So worthwhile to do Excel training. I didnt realise all the things you could do on Excel. Wish I had done this years ago. You dont know what you dont know - until you know!! ”

Roisin McDermot

Seed Mentoring


Educational Partners