MS Excel Advanced

Schedule

Tue Apr 08 2025 at 09:30 am to 04:30 pm

UTC+01:00

Location

Mount Business & Conference Centre | Belfast, NI

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

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


Advertisement

Where is it happening?

Mount Business & Conference Centre, 2 Woodstock Link, Belfast, United Kingdom

Event Location & Nearby Stays:

Tickets

GBP 270.00

AKU Training Ltd

Host or Publisher AKU Training Ltd

It's more fun with friends. Share with friends

Discover More Events in Belfast

Belfast Job Fair - Belfast Career Fair
Tue Apr 08 2025 at 11:00 am Belfast Job Fair - Belfast Career Fair

Belfast

JOB-FAIRS VIRTUAL-RUN
Joan As Police Woman in Belfast
Tue Apr 08 2025 at 07:00 pm Joan As Police Woman in Belfast

The Limelight 2

Andr\u00e9 Rieu in Belfast
Thu Apr 10 2025 at 06:01 pm André Rieu in Belfast

The SSE Arena, Belfast

Eshaan Akbar - Live 2025
Thu Apr 10 2025 at 07:00 pm Eshaan Akbar - Live 2025

The Limelight 2

ART THEATRE
Andre Rieu
Thu Apr 10 2025 at 07:30 pm Andre Rieu

SSE Arena Belfast

MUSIC ENTERTAINMENT
Belfast Careers Fair
Fri Apr 11 2025 at 10:00 am Belfast Careers Fair

Assembly Buildings Conference Centre

EXHIBITIONS BUSINESS
Time Management
Mon Jan 22 2018 at 09:30 am Time Management

Mount Business Centre

WORKSHOPS
Developing Confidence
Thu Feb 22 2018 at 09:00 am Developing Confidence

Mount Business Centre

WORKSHOPS
Presentation Skills
Tue Mar 06 2018 at 09:00 am Presentation Skills

Mount Business Centre

WORKSHOPS NONPROFIT
MS Excel Intermediate
Fri Mar 23 2018 at 09:00 am MS Excel Intermediate

Mount Business Centre

WORKSHOPS
Assertiveness Skills
Mon Apr 30 2018 at 09:00 am Assertiveness Skills

Mount Business & Conference Centre

WORKSHOPS
Finance for Non-Financial Managers
Thu Jun 07 2018 at 09:00 am Finance for Non-Financial Managers

Mount Business Centre

WORKSHOPS BUSINESS
SAGE Cloud Accounting
Thu Nov 14 2019 at 09:15 am SAGE Cloud Accounting

Mount Business & Conference Centre

WORKSHOPS
Difficult Conversations
Wed Jan 29 2020 at 09:15 am Difficult Conversations

Mount Business Centre

WORKSHOPS
Practical Risk Management
Mon Jun 22 2020 at 09:15 am Practical Risk Management

Mount Business Centre

WORKSHOPS
Effective Report \/ Business Writing
Mon Sep 28 2020 at 09:30 am Effective Report / Business Writing

Mount Business & Conference Centre

WORKSHOPS
Joint Falls\/Shankill Tour
Fri Nov 04 2022 at 10:00 am Joint Falls/Shankill Tour

Divis Tower

WORKSHOPS
Afraid Of Public Speaking? FREE Virtual class to Banish Anxiety and Fears
Sun Jan 01 2023 at 12:00 am Afraid Of Public Speaking? FREE Virtual class to Banish Anxiety and Fears

Belfast

PUBLIC-SPEAKING WORKSHOPS
Make Your First Sale in Your Business (!!!) | Belfast
Sun Nov 12 2023 at 09:00 pm Make Your First Sale in Your Business (!!!) | Belfast

Virtual via Zoom

WORKSHOPS HEALTH-WELLNESS
Carnmoney Christian Healing Hub (Northern Ireland)
Thu Nov 16 2023 at 09:00 pm Carnmoney Christian Healing Hub (Northern Ireland)

St Peter's Church of Ireland

WORKSHOPS NONPROFIT

What's Happening Next in Belfast?

Discover Belfast Events