Upcoming Training
Introduction to Excel
When: Tuesday, 9 June 2026, 1 - 3pm
Where: The Kollective, 145 17th Ave, Tauranga
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
Maketū: Thursday, 11 June 2026, 10am - 12.00pm
Te Puke: Wednesday, 1 July 2026, 11.30am - 1.30pm
Ō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.
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
