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

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.

Price

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

To query booking individual modules please contact maria@womeninbusinessni.com

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

Educational Partners

Belfast Met Queens Uni Ulster Uni