Microsoft Excel - Intermediate
2 hour online session running from 2.00pm to 4.00pm
Attendees must have Excel 2016 or 2013 desktop client installed on their machine and should have some familiarity with Microsoft Windows.
This course is aimed at those who are familiar with the basics of Excel and need to broaden their knowledge. Attendees must be confident with creating basic formulas, use of AUTOSUM and filling formulas.
On completion of this course, attendees will be able to create and apply a range of functions, apply formatting based on conditions, and summarise and analyse data using Pivot Tables.
This 2 hour session will cover the following:
- Absolute cell referencing
- Using Conditional formatting
- Introduction to the following functions: IF, SUMIF, COUNTIF
- Introduction to the VLOOKUP function
- Create a Pivot Table
- Filter a Pivot Table
Funding and Fees
This course is eligible for ITA Funding. To apply for ITA please visit the SDS My World of Work website by clicking here
Once you have applied for ITA you will still have to apply for this course here on the College website.
For further information please email email@example.com