MS Excel Advanced

Wed Dec 11 2024 at 10:30 am to 05:30 pm UTC01:00

Mount Business & Conference Centre | Belfast

AKU Training Ltd
Publisher/HostAKU Training Ltd
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 199.00

Sharing is Caring:

More Events in Belfast

Queen's Big Band - Christmas Concert 2024
Tue Dec 10 2024 at 07:30 pm Queen's Big Band - Christmas Concert 2024

The Black Box

Festive Salsa Social
Tue Dec 10 2024 at 08:30 pm Festive Salsa Social

Revolucion De Cuba

POST-BUDGET PRIVATE CLIENT UPDATE
Wed Dec 11 2024 at 09:00 am POST-BUDGET PRIVATE CLIENT UPDATE

Stormont Hotel Belfast

Managing Harassment and Bullying at Work
Wed Dec 11 2024 at 10:00 am Managing Harassment and Bullying at Work

James House

Young Enterprise Big Market 2024
Wed Dec 11 2024 at 10:00 am Young Enterprise Big Market 2024

St George's Market

No Recourse to Public Funds training - Northern Ireland
Wed Dec 11 2024 at 10:00 am No Recourse to Public Funds training - Northern Ireland

Law Centre

Cabaret Christas Lunch Show
Wed Dec 11 2024 at 12:30 pm Cabaret Christas Lunch Show

38-44 Upper Arthur Street, BT1 4GH Belfast, United Kingdom

Does Counter-Terrorism Work?
Wed Dec 11 2024 at 01:00 pm Does Counter-Terrorism Work?

18 University Square

CIH Futures NI  Social Networking Event
Wed Dec 11 2024 at 02:00 pm CIH Futures NI Social Networking Event

2 Royal Avenue

Newstart Education Centre Celebration Evening
Wed Dec 11 2024 at 06:00 pm Newstart Education Centre Celebration Evening

Conway Mill Preservation Trust

Fratelli Presents Elf
Wed Dec 11 2024 at 06:30 pm Fratelli Presents Elf

60 Great Victoria Street, BT2 7BB Belfast, United Kingdom

AOA: Whataboutisms Launch Party
Wed Dec 11 2024 at 07:00 pm AOA: Whataboutisms Launch Party

Black Box

Belfast is Happening!

Never miss your favorite happenings again!

Explore Belfast Events