This one day course is for those who have a good grounding in Excel basics and wish to gain a fuller understanding of more advanced features available to them.
This course has been specifically designed to give users a solid foundation in setting up spreadsheets to perform advanced calculations to create professional and functional Excel workbooks thus enabling them to be more efficient and effective in the workplace
The course covers the following topics: Main spreadsheet features Shortcuts, tricks and tips Absolute referencing Macros Managing Conditional formatting Charts and graphs Pivot tables Formulae, functions and nested functions
1 day course (6 hours). Candidates will be awarded a college certificate of attendance upon completion of the course. Candidates can progress to Microsoft Excel Advanced or L3 Spreadsheet Software qualification.
CON/ITOC_ME2Coleg Gwent Business (Short Course)
All courses may be subject to change. Coleg Gwent reserves the right to withdraw courses should they no longer be deemed viable to run.
Gall yr holl gyrsiau fod yn destun newid. Mae Coleg Gwent yn cadw'r hawl i dynnu cyrsiau yn os ystyrir nad yw bellach yn ddichonadwy i'w rhedeg.
Visit our campuses and speak to staff