MS Excel Advanced

MS Excel Advanced

Create spreadsheets which allow secure data sharing and integration with other applications and learn advanced functions including VBA

By AKU Training Ltd

Date and time

Thu, 11 Sep 2025 09:30 - 16:30 GMT+1

Location

Mount Business & Conference Centre

2 Woodstock Link Belfast BT6 8DD United Kingdom

Refund Policy

Refunds up to 7 days before event

About this event

  • Event lasts 7 hours

In business, it is important that the data stored by an organisation is accessed, manipulated and analysed in a secure and robust manner. Integration with other applications and sharing data between users is now commonplace, making security an essential consideration in spreadsheet design.


You will learn how to implement advanced functions and features such as macros and will be familiar with the basics of Visual Basic for Applications (VBA).


During the course you will learn how data can be successfully and securely exchanged with outside sources and how it can be shared between multiple users. Advanced data analysis and functions are considered, along with an introduction to macros and VBA. The course is designed as a practical course enabling you to receive hands-on experience of all topics covered.


The content will be relevant to Excel 2007, 2010 and 2016 and will cover the following topics:



SESSION 1 (2HR) - SUBTOTAL/PIVOT TABLES & AUDITING


  • Subtotal
  • Pivot Tables
  • Pivot Charts
  • Precdents/Dependants
  • Error Checking
  • Calculate Formula
  • Watch Window



SESSION 2 (2 HR) - NESTED IF/LOOKUPS


  • IF Functions Recap
  • Nested IF
  • Lookup
  • Match/Index



SESSION 3 (2 HR) - LINKING & CHARTS


  • Linking Sheets
  • Linking Files
  • Managing Links
  • Chart Types
  • Chart Elements
  • Modifying Chart Elements
  • Combo Charts


Tags

Organised by

AKU Training Ltd

At AKU Training we provide practical, engaging and practitioner-led training in Belfast, Ireland, UK and further afield. We offer a unique and varied range of training across Business & Administration, Finance & HR, Marketing and Project Management. Whether you are a senior manager or trainee, our strength lies in identifying and fulfilling your professional training needs through:

Public training courses in Belfast that offer value for money and access to a wide range of topics including IT training, Administration training, Finance training, Marketing and Digital Marketing training and Project Management training.In-house training that is tailored to your organisation’s needs and provides cost savings.Recognised accreditations in Agile and PRINCE2 project management through the Association of Project Management Group (APMG).

 ALL of our courses can be tailored and offered on an in-house basis.

 Visit www.aku.training for a full list of courses or contact marketing@aku.training