Search results for:
No result found! Try with different keywords!
Users
Organizers
Events

MS Excel Advanced

Advertisement

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).

What Will I Learn?

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 and 2010.

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



Is it For Me?

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.



You may also like the following events from AKU Training:

Tags
Map Mount Business Centre, 2 Woodstock Link, Belfast, United Kingdom
Loading venue map..
Event details from Report a problem

Are you going to this event?

Advertisement

More Events in Belfast

Explore More Events in Belfast