MS Excel Advanced
This practical course is designed to enable you to create spreadsheets which allow secure data sharing and integration with other applications. 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).
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.
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, 2016 and 365
By the end of the course you will have an understanding of:
- Analysing Data: Using IF Statements, Data and Pivot Tables
- Macros: Recording & Running Macros and Assigning Macros to Buttons
- Sharing Workbooks: Consolidating Data, Conflicts of Shared Data and Administration
- Template and Protection: creating templates and protecting Excel files
- Importing from External Sources such as Word, Access and Powerpoint. Introducing Dynamic Data Exchange
- Forms: Creating Forms and using Ready made Forms
This course is designed for those who are proficient in basic MS Excel features and wish to use MS Excel for more complex and sophisticated tasks. Participants should have a good working knowledge of MS Excel, or have attended AKU's Intermediate MS Excel training course.
-
MS Excel Advanced - 30th September 2024
Date: 30 September 2024Location: The Mount Business & Conference CentreTime: 09:30 - 16:30Price: £199 +VAT
-
MS Excel Advanced - 12th December 2024
Date: 12 December 2024Location: The Mount Business & Conference CentreTime: 09:30 - 16:30Price: £199 +VAT
-
MS Excel Advanced - 8th April 2025
Date: 8 April 2025Location: The Mount Business & Conference CentreTime: 09:30 - 16:30Price: £225 +VAT
-
MS Excel Advanced - 11th September 2025
Date: 11 September 2025Location: The Mount Business & Conference CentreTime: 09:30 - 16:30Price: £225 +VAT
-
MS Excel Advanced - 3rd December 2025
Date: 3 December 2025Location: The Mount Business & Conference CentreTime: 09:30 - 16:30Price: £225 +VAT
Please note that the cancellation policy for our public training courses is as follows:
NON-ACCREDITED TRAINING
More than 3 weeks prior to the course start date - No cancellation fee payable.
Less than 3 weeks prior to the course start date - 100% of total fees payable or free transfer.
ACCREDITED TRAINING
More than 6 weeks prior to the course start date - No cancellation fee payable.
Less than 6 weeks prior to the course start date - 100% of total fees payable or free transfer.
Substitute delegates will be accepted at any time at no cost.
Full joining instructions for the course will be emailed to you at least five working days prior to the course. In the meantime, if you have any queries please contact a member of our team on 028 9016 0587 or via email kate@aku.training.
Download a copy of our standard Terms and Conditions for course bookings.
