Excel - Advanced

Course Information

  • Course Code: BC974
  • Duration: 6 hours
  • Price: £99.00
  • Times: 09:30-16:00
  • Delivery Type: PT

Book Now Print

Overview

Blackburn College in partnership with Caroline Coleman are pleased to offer you the opportunity attend our new Microsoft Excel courses which will be delivered in 2020 and are ready for booking!  Courses will be delivered on Office 2013 but are also suitable for Office 2010 users. 

What will I study?

For those students who are conversant with Basic & Intermediate Excel (or who have already completed the intermediate course), please see below:

 

Module 1

  • Scenario manager, IF Functions, IF/OR Functions, IF/AND Functions, Nested IF

 

Module 2

  • AND Function, OR Function, NOT Function, COUNT/IF Function, SUM/IF Function, NOW/TODAY Function

 

Module 3

  • Pivot tables, HLookup, VLookup, Data list, Conditional formatting, Data validation

 

Module 4

  • Record a macro, assign a macro, edit a macro (vba), advanced macro, create a macro button

 

Entry Requirements

It is the responsibility of the student to ensure that they are booking onto the correct level of course based on their current level of understanding of the application.   We would ask that students have basic computer skills and have a good command of English.   Please also note that you will need access (on a desktop computer) to your personal email address during the course so please ensure you have your password with you.

What can I do next?

We also deliver Word, Powerpoint, Outlook, see here:  https://www.blackburn.ac.uk/course-details/BC925/microsoft-office-training

 

Bespoke Requirements?

We also offer all of the above courses (as well as Word, Outlook and PowerPoint) on a bespoke basis for businesses at dates and times mutually convenient, if this would be of interest please contact me to discuss further and we’ll organise a quotation based on your requirements.

For more information

For more information about this course, contact our specialist team on 01254 29 25 00 or email business@blackburn.ac.uk

Book Now Print