MS Excel Advanced (Virtual - 3 sessions)
This practical, virtual course is designed to enable you to create spreadsheets which allow secure data sharing and integration with other applications.
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.
Delivered over 3 x 2 hour virtual sessions 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
-
LouiseLouise is an IT professional with over 22 years' experience in IT and telecommunications. During her career she has worked in IT consultancy, project management and as an in-house trainer.
Louise is an Associate with AKU Training and provides specialist IT training in Belfast including MS Excel, MS Word, MS Access, MS Project and marketing through Twitter and LinkedIn training.
Louise also runs her own IT consultancy in Belfast through which she operates as an IT consultant, mentor and IT trainer. She is an Accredited Microsoft Master Instructor and an accredited ECDL and Advanced ECDL Tester. She has worked as an Associate Lecturer with the Open University and a part-time lecturer with Castlereagh College and EDIFHE.
-
MS Excel Advanced (Virtual) - 14, 16, 18th Dec 2020
Date: 14 December 2020Location: VirtualTime: 10:00 - 12:00Price: £199 +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@akutraining.com.
Download a copy of our standard Terms and Conditions for course bookings.
