Programme type:

Virtual

Sign in

Price:

Programme Price - £150.00 (+VAT)

Affiliate Discount Price - £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.

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

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

Educational Partners