Spreadsheet Analyst
Clean a real dataset in Excel or Sheets and answer a question with it.
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
- 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 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 read9 min
- 2Cleaning what you were actually sent11 min
- 3The formulas that carry the job11 min
- 4Turning rows into an answer10 min
- 5Checking yourself, and showing the answer9 min
The export nobody wants to open
A written plan with three parts: how you would clean it and in what order, how you would answer each of Meera's three questions, and what you would put in front of her.
About 85 minutes in total.
Two levels
Finish the units and the project and you get the Certificate of Completion. Add a live skill challenge on Spreadsheets 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, which stays in your insiderOne profile where an employer can see it.