Upcoming Training
Introduction to Excel
When: To be confirmed, 2 hours
Where: The Kollective, 145 17th Ave, Tauranga or at your premises
Never used Excel before, or self-taught but know there must be a better way?
This session will take you through the basics from how to create and use spreadsheets in Excel, to showing you shortcuts and give you an understanding of the key tools including:
Finding your way around a spreadsheet
Working with columns and rows
Data ranges
Formatting
Filtering
Basic Formulas
Shortcuts and tips
Bring your laptop along with Excel loaded and ready to go for a very hands on workshop.
Excel - Intermediate
When: Tuesday, 22 September 2026, 9.30am - 1.30pm
Where: The Kollective, 145 17th Ave, Tauranga
This Excel training is for intermediate users who know their way around a spreadsheet and want to take their skills to the next level.
What you will learn about:
Find and replace
Work with Auto-fill
Text Functions
Protecting and sharing a workbook
Hyperlinks
Formulas
Functions
Charts
Chart Dashboards
Please bring your laptop for a hands-on workshop facilitated by the very experienced Cathi Barker from Software Solutions.
Spaces are limited to 8 per workshop, book now to secure your space.
Our People, Our Places
Ōmokoroa: Tuesday, 11 August 2026, 5.30pm - 7.30pm
We've done all of the hard work - no spreadsheets and no math. Just the facts to help identify what is happening in your community.
Join us to view the latest infographics available for WBOP and to find out what other data is available for your area.
Discover information that will help you to:
identify the need in the community
find information to help support funding applications
Are you interested in finding out more about:
Residents - age, gender, ethnicity, languages spoken
Households and housing
Income
Education
Employment
Levels of deprivation
Anything else?
Come along to this hands-on workshop to discover more information about your local community.
This session is suited for all abilities – you do not need data skills to participate or to get something out of the workshop.
Please bring:
Your laptop to help gain confidence in finding and using the infographics and let us show you where to find other data specific to your community.
If you are interested in an Our People, Our Places workshop for your own community please let us know via the register your interest button below.
Collecting & Presenting Data Using Google Forms
When: To be confirmed, 3 hr workshop
Where: The Kollective, 145 17th Ave, Tauranga
Learn how you can save time by using Google forms for registrations, feedback and evaluations. We will then take you through how to present the data visually with graphs and charts.
This workshop will cover:
What types of questions to include
Linking QR codes to Google forms
Transforming data collected into basic charts to present to your board and funders
You will need access to a gmail account prior to attending the workshop. Please contact us if you need assistance with setting this up.
Please bring your own laptop as this is a very hands on workshop.
Introduction to Power BI (Level 1)
When: To be confirmed, 4 hour workshop
Where: The Kollective, 145 17th Ave, Tauranga
Join us to being your journey visualising data with this Level 1, Introduction to Power BI.
This workshop will introduce you to Microsoft’s Power BI tool for connecting and analysing data. In this hands-on workshop, you will learn:
the essential methods of connecting to data correctly
transforming that data so that you will have a data set that is easy to get real insights and valuable information
how to get data from a variety of sources including text/csv, Excel and database files and bring that data into Power BI.
transform data using the Power Query editor including pivoting, transposing, splitting, duplicating, merging, appending, replacing, formatting, applying functions and creating parameter queries and dynamic lists in preparation for reporting and visualisations.
Spaces are limited to 8 per workshop, book now to secure your space.
Power BI (Level 2)
Reports & Visualisations
When: To be confirmed, 4 hr workshop
Where: The Kollective, 145 17th Ave, Tauranga
This workshop follows on from the Introduction to Power BI (Level 1) training and will introduce you to the Microsoft’s Power BI report visualisations.
In this hands- on workshop you will learn:
the essential methods of creating and formatting visuals
how to create, manage and format action buttons, cards, multi-row cards, slicers, tables, maps, decomposition trees, matrices, charts (including scatter, pie, donut, waterfall, ribbon and bar charts), smart narratives, Q&A buttons and more
to set up reports for easy navigation, interaction via a mobile device
to publish to a Power BI service for easy access by others
Spaces are limited to 8 per workshop, book now to secure your space.
Annual Reporting Correctly and Creatively
When: To be confirmed, 2.5 hr workshop
Where: The Kollective, 145 17th Ave, Tauranga
Use your annual report to tell the story of your organisation using your data correctly and creatively.
Liz Flaherty works with data and knows how the social sector works. Richard Dey from William Buck, Chartered Accountants, knows the mechanics of annual reporting from a financial perspective.
Together they can help you to use your data creatively and correctly, so your annual report will meet all requirements and also tell a story that will interest your members, clients and funders.
Data Storytelling
When: To be confirmed, 3 hour workshop
Where: The Kollective, 145 17th Ave, Tauranga
A follow-up workshop to the Local Data resources workshop.
Now that you know how to find the data that is relevant to your mahi (work), this Data Storytelling workshop will provide participants with the skills and knowledge to effectively communicate data stories.
Through interactive activities and hands-on exercises, participants will practice:
identifying relevant data
framing data so key insights are revealed (story forming)
communicating these insights using narrative and visual elements (story telling)
It is recommended that you attend a Local Data Resources workshop prior to attending this workshop. Alternatively, let us know when you register so we can organise time with someone from the Community Insights team prior to this workshop.
Bring your laptop for a hands-on workshop.
Annual Reporting with Infographics
When: Tuesday, 15 September 2026, 9.30am - 12.30pm
Where: The Kollective, 145 17th Ave, Tauranga
Join us for a 3-hour workshop and leave with your own infographic!
Discover how to create an engaging infographic to tell the story of what your organisation has achieved during the year. Ideal for sharing with funders and stakeholders, increasing donations and engaging with sponsors.
What you will learn:
The first hour will be facilitated by the Community Insights team and will cover what data to include:
When to use % vs amounts
Getting the balance right - numbers vs narrative
Data sources
The following two hours will be facilitated by Emily Arnold from Creative BOP taking you through Canva:
Useful infographic templates
Using symbols and images
Icons
Charts
Composition
Using your organisations brand kit
This session is for people who already have a Canva account and know their way around the basics. If you are not currently using Canva and want to learn the basics first check out the Canva - Starting your creative journey workshop in August.
Emily Arnold is a marketing and storytelling specialist with experience in social media, content creation, and designing in Canva. She helps individuals and organisations create clear, engaging visuals with confidence, bringing an audience-first approach to simple, effective design.
Spaces limited, book early to avoid disappointment.
Get in touch!
Get in touch with the Community Insights team to talk with us about your data needs, questions or ideas. We’ll support your organisation to build your skills and expertise in using both your own and relevant external data to enhance and grow your work in our community.
Call us: 07 987 0920
Visit us: The Kollective – 145 17th Ave, Tauranga
Mail: DX BOX HP40007, Tauranga 3112
Terms of use and privacy policy
