MS Excel Intermediate (Virtual - 2 sessions)
This interactive, virtual training course will introduce you to the most effective features in MS Excel to enhance your productivity and save you time.
Detailed module content is provided below which includes automated tasks for data manipulation, calculation and data analysis.
Delivered over 2 x 3 hour virtual sessions you will gain the knowledge and skills to create, edit and enhance Excel spreadsheets.
The content will be relevant to Excel 2007, 2010 and 2016 and will cover the following detailed topics:
FORMULAS & FUNCTIONS
Creating Formulas
Operators
Relative & Absolute Ref
Named Cells
Creating Functions
Sum/Average/Max/Min/Count
Auto sum
Error Messages
MANIPULATING DATA
Sorts & Filters
- Basic Sorts
- Multiple Sorts
- Custom Sorts
- AutoFilter
- Advanced Filter
Protection/Security
- Data Validation
- Protected Sheets/Workbooks
FORMATTING DATA
Font /Alignment Formatting
Number Formatting
Format Painter
Conditional Formatting
-
Louise
Louise 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 Intermediate (Virtual) - 20th & 21st May 2021
Date: 20 May 2021Location: VirtualTime: 09:30 - 12:30Price: £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@aku.training.
Download a copy of our standard Terms and Conditions for course bookings.