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

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

The Limelight 2

ART THEATRE
GIFTED: VIRGINS | MOON LANDING | GUSH - BELFAST EMPIRE - 10 APRIL 2025
Thu Apr 10 2025 at 08:00 pm GIFTED: VIRGINS | MOON LANDING | GUSH - BELFAST EMPIRE - 10 APRIL 2025

The Belfast Empire

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

Assembly Buildings Conference Centre

EXHIBITIONS BUSINESS
The Emo Festival Is Coming To Belfast!
Fri Apr 11 2025 at 06:00 pm The Emo Festival Is Coming To Belfast!

The Limelight 1

MUSIC
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
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
Practical Risk Management
Mon Jun 22 2020 at 09:15 am Practical Risk Management

Mount Business Centre

WORKSHOPS
Tuesday  morning yoga class for all levels with Chandra
Tue Jun 01 2021 at 10:30 am Tuesday morning yoga class for all levels with Chandra

Wandsworth Community Association

HEALTH-WELLNESS YOGA
Saturday morning yoga class for all levels with Chandra
Sat Jun 12 2021 at 10:30 am Saturday morning yoga class for all levels with Chandra

Wandsworth Community Association

HEALTH-WELLNESS YOGA
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
Virtual Speaking Masterclass Belfast
Tue Jan 09 2024 at 08:00 pm Virtual Speaking Masterclass Belfast

Belfast

WORKSHOPS VIRTUAL
Professional Skills 3 Days Bootcamp in Belfast
Wed Jan 24 2024 at 10:00 am Professional Skills 3 Days Bootcamp in Belfast

For venue details reach us at [email protected]

WORKSHOPS VIRTUAL

What's Happening Next in Belfast?

Discover Belfast Events