Although I have spent many years working with spreadsheets across different jobs, my One Awards Computing Diploma gave me the opportunity to receive formal recognition of the knowledge and skills I have built up over a period of time. In order to show evidence of this, I was tasked with making a spreadsheet that would demonstrate an understanding of multiple functions, data types and analysis/forecasting tools that a company would expect to be used on a daily, monthly and yearly basis.
The assignment was to produce a workbook for a movie rental company with a physical store that is looking to move into online streaming. This task also required two presentations to be created, which would prove that the criteria had been not just been fulfilled, but exceeded. The workbook would need to be structured in a logical and fluent manner, and also display clear evidence that it makes use of the following items in order to prove my understanding of working with spreadsheets:
I was asked to produce a comprehensive presentation which contained annotated screenshots showing how I implemented multiple functions within my work. Each example is from my own workbook, highlighting its use and purpose.
I also produced a guide (similar in style to the ‘For Dummies’ books) which explains how to find and correct errors that appear within incorrectly-entered formulas. This used deliberately created examples from my own workbook in order to show a genuine understanding of each error.
Listed below are all my self-produced tutorials relating specifically to spreadsheets
A full list of my tutorials for all subjects can be found here
My YouTube channel can be found here
*To open links in a new tab, hold down the Ctrl key and click on the link*
| No. | Description | Link |
|---|---|---|
| 1 | Awaiting upload | ▶ |
| 2 | Awaiting upload | ▶ |
| 3 | Awaiting upload | ▶ |
| 4 | Complete playlist | ▶ |
