Short courses
Excel Advanced
Subject Area
Business & Professional Short Courses
Start Date
1 June 2023
Additional Start Date
18 July 2023
Study Mode
Full cost
Duration
1 day
Fee
See Further Information and Booking
Next Start Date
1st June 2023
This course is suitable 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.
This course is delivered over 1 day from 9.30am to 4.30pm
Topics covered will include:
- Building Spreadsheets - Functions and Formulae, Naming Ranges, Data Validation, Formula Auditing
- What if Analysis - Input Cells, Scenarios, Goal Seeking, Data Tables
- Lookups - Numeric and Text Lookups, Index and Match Functions,
- Importing CSV files
- Pivot Tables, Charts and Macros - Pivot Tables, Filtering, Slicers, Pivot Charts, Macros, Running Macros, Editing Macros
- Delivering Workbooks - Workbook Protection, Templates, Excel Options
Further Information and Booking
If you're interested in this course, please contact us:
Business Partnerships, York College, Sim Balk Lane, York, YO23 2BB
Email: businesspartnerships@yorkcollege.ac.uk
Tel:
Fee:
From August 2022 - £100
From August 2023 - £110
Next Course Dates
01/06/2023
21/06/2023 (Campus@Northallerton)
18/07/2023
03/11/2023
29/02/2024
26/03/2024
06/06/2024
19/07/2024
This is the second Excel course I have done at York College. Really useful content delivered in a user-friendly way. The Trainer was very engaging and related content to the workplace.
Other similar courses
These other courses may be more suited to your interests or needs
Business & Professional Short Courses department