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

Fratelli Presents Elf
Tue Dec 10 2024 at 06:30 pm Fratelli Presents Elf

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

Elf Movie Night
Tue Dec 10 2024 at 07:00 pm Elf Movie Night

38-42 Upper Arthur St, BT1 4GJ Belfast, United Kingdom

The Chameleons
Tue Dec 10 2024 at 07:00 pm The Chameleons

The Limelight 2

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

Stormont Hotel Belfast

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

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

Black Box

Belfast Art Club@The Errigle Inn Christmas Special
Wed Dec 11 2024 at 07:30 pm Belfast Art Club@The Errigle Inn Christmas Special

The Errigle Inn

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

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

David Essex's
Wed Dec 11 2024 at 08:00 pm David Essex's

Waterfront Hall & Ulster Hall

Belfast is Happening!

Never miss your favorite happenings again!

Explore Belfast Events