SP Weekly Revision Q29 - 38
This video covers revision questions 29 to 38 with topics on date time functions, vlookup function, some mathematical and text functions – countif() sumif(), rounddown(), rank.eq(), left(), trim(), some financial functions, database function and nested if.
This playlist is a series of videos that covers advanced skills that can be used to produce sophisticated reports, to perform complex mathematical and statistical calculations, and to improve productivity using a spreadsheet application.
The videos are free to the public; however, you must sign in with your Coventry University email to access the Resources: Demonstration and Practice resources.
Please use your Coventry University email to access the resources. Use this link to the Demonstration & Practice Resources materials that can be used for particular skills in Excel.
Weekly Revision: https://bit.ly/3MX0EMs
Individual videos will have resources for that video. You will be able to download the demonstration workbooks that have been used in the videos and you can go along with the demonstrations as a first step.