York College

Programme Content

For those who have a basic grounding in Microsoft Excel and have already completed the Excel Intermediate course or have the equivalent experience of this extremely popular software.  It explores the more complex functionality offered by Microsoft Excel.

Course Content

Session 1 Content

Session 1 will cover building spreadsheets -functions and formulae and auditing, Secenarioes and goal seeking, numeric and text lookups, index and match functions, connecting vs importing, importaing data, pivot tables and dash boards. 

Session 2 Content

Session 2 will cover validations, by value and list, macos and macro applications, protection and inspecting documents, tracking changes, sharing concepts, protect and share, co-authoring.  

Delivery and Attendance

This course will take place at York College.

Full day course - 9.30am to 4.30pm.

The courses will be delivered online in bitesize sessions. 

Price

£35.00

Next Course Dates

Session 1 - 26/10/20  09:30 - 12:30 or 13:30 - 16:30. 

Session 2 - 27/10/20  09:30 - 12:30 or 13:30 - 16:30. 

To book onto this programme please call: 01904 770368 Option 1 or email This email address is being protected from spambots. You need JavaScript enabled to view it.

Future Courses

We are hoping to deliver our courses back in the college after the new year and these will be delivered over a full day 09:30 - 16:30 covering all the topics outlined above. 

The dates we have scheduled are; 

15/02/2021

30/03/2021

09/04/2021

17/05/2021 (You will be required to provide your own laptop for this date)

01/06/2021

06/07/2021

19/07/2021

Need Help?

Course Enquiry

Please type your full name.
Invalid email address.
Please tell us about your enquiry
×