MS Excel Advanced

Tue Apr 08 2025 at 09:30 am to 04:30 pm UTC+01:00

Mount Business & Conference Centre | Belfast

AKU Training Ltd
Publisher/HostAKU Training Ltd
MS Excel  Advanced
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

Event Venue & Nearby Stays

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

Tickets

GBP 270.00

Sharing is Caring:

More Events in Belfast

Health Tech Spring - Life Sciences, Life Support (7th April)
Mon Apr 07 2025 at 01:00 pm Health Tech Spring - Life Sciences, Life Support (7th April)

Titanic Belfast

Health Tech Spring Conference (8th April)
Tue Apr 08 2025 at 09:00 am Health Tech Spring Conference (8th April)

Titanic Belfast

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

Belfast

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

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

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

Assembly Buildings Conference Centre

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

Belfast is Happening!

Never miss your favorite happenings again!

Explore Belfast Events