Basket Login
WIB logo Programmes About us Other Services Contact us
search icon Join
search-icon search-icon
close

Results

View all results
Close contact iconContact us

Programme type:

Virtual

Sign in
Book Now

Ticket Price:

Member - £120.00 (+VAT)

Non-member - £150.00 (+VAT)

Book now

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 £120.00 (plus VAT)
Non-member price £150.00 (plus VAT)

Want to find out more about this programme? Email nicky@centreoflearningni.com and discover more about support available for your personal and professional development.

Add to Basket Book Now

Upcoming in-take

Starting Friday 6 December 2024

Upcoming in-take

Starting Wednesday 26 March 2025

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

“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

Encirc

top left bottom left top left bottom left

“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

top left bottom left top left bottom left

“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

top left bottom left top left bottom left

“I enjoyed this advanced excel group so much. Louise made it really interactive and the exercises are great as you can apply the knowledge that was talk through the course.”

Yoli Avila

FSCOM

View Programme Here
top left bottom left top left bottom left

“Course was fantastic and Louise was very informative and helpful - really enjoyed the training.”

Encirc Ltd.

Encirc Ltd.

previous
next

Virtual event

Our virtual events take place on Zoom, once booked you will receive the zoom meeting link via your email as well as the confirmation page at the end of the checkout process.

Our Partners

Allstate Northern Ireland
Amazon Danske Bank Glandore Northern Ireland Electricity Pinsent Masons FinTrU Virgin media Business MCS Group Department for Business and Trade

Educational Partners

Belfast Met Queen's University Belfast Ulster Uni