Spreadsheet Analyst
Clean a real dataset in Excel or Sheets and answer a question with it.
Add it to your LinkedIn profile with the insiderOne logo, verifiable by anyone.
What you will be able to do
- Lay out a sheet another person can pick up without asking you anything
- Clean a messy export without destroying the original
- Spot a date or a number that is secretly text before it ruins the answer
- Write lookups and conditional sums that do not break when the data grows
- Summarise thousands of rows into the four numbers somebody asked for
- Check your own answer against a control total before anybody else has to
Students and freshers heading into any role where somebody will send them a spreadsheet and expect an answer, which is most of them.
What is in it
- 1A sheet somebody else can read11 min
- 2Cleaning what you were actually sent11 min
- 3Dates, numbers and text that lie to you11 min
- 4The formulas that carry the job11 min
- 5Turning rows into an answer11 min
- 6Checking yourself before anybody else does11 min
- 7Showing the answer11 min
- 8A report you can run again next month11 min
The export nobody wants to open
A written plan with four parts: how you would clean it and in what order, how you would check your own answer, how you would answer each of Meera's three questions, and what you would put in front of her.
About 125 minutes in total.
Two levels
Finish the units and the project and you get the Certificate of Completion. Pass the live skill challenge on Spreadsheets at Practitioner level or above and it becomes a Verified Certificate, which anyone you send it to can check for themselves.
Questions
What does it cost?
Nothing while insiderOne is in beta.
Can an employer check it?
Yes. Every certificate has its own page, and the code printed on it resolves there without anyone needing an account.
Do I need any experience?
No. These are written for students and people in their first job, and they assume nothing.
What do I actually walk away with?
The certificate, and the piece of work you made for the project. That goes into your insiderOne profile as a proof item, private until you choose to show it.
Know someone studying this?
It is free while insiderOne is in beta, and the certificate is checkable by anyone they send it to.