Advanced Spreadsheet Office Hours & Workshop with Bernat Fortet
Why: As much as we want cutting-edge technology, we know that reforestation around the planet is mostly driven by spreadsheets. Why not?! It’s a flexible and powerful solution. Most importantly, lots of people know how to use it.
Bernat is offering a space to support implementors in up-leveling their spreadsheet skills. He believes that spreadsheets are here to stay for good or for bad. So we might as well empower those using them to learn ways to squeeze the most out of them.
Format: Office Hours - Bring Your Own Spreadsheet
Duration: Initially 1 hour, extensible to 2 hours.
Who’s this for: Project implementors who spend several hours a day/week working with spreadsheets.
What You Get Away With:
Learn how to improve data connections and reduce duplicate data.
Learn advanced formulas and functions.
Learn how to create advanced dashboards and visualizations.
A spreadsheet with several sheets containing advanced examples specifically designed for reforestation projects.
Agenda:
Introduction (10 min): Intros and context for the participants. Choosing the first person to deep dive with. Verbal confidentiality agreement to keep the shared data safe.
Participant's Spreadsheet Deep Dive (20-30 minutes each): Ideally, you bring your own spreadsheet and a goal, and I help you find a way to improve it.
Advanced Techniques and Q&A: If people don’t bring a spreadsheet, we can use the time for Q&A and showcasing some advanced techniques.
Feedback and Follow-Up (5 min): A way to learn how we might improve this type of session.
About Bernat: Bernat Fortet is a black-belt in spreadsheets. When he’s not doing spreadsheet black magic, he is the founder of Restoration Scope, a software company dedicated to supporting nature restoration organizations by streamlining on-the-ground operations and data transparency through technology. He’s built products and companies for the last 15 years and learnt to spreadsheet before walking.