We aim to cover the top 15 functions you might need to advance your Excel skills, and the techniques you need to make them work harder; absolute and mixed cell references, nesting, using range names and Table ‘structured references’. Please read below for greater detail and prerequisite skills. 2020 courses starting May and October.

You know the basics of DSLR, now explore different types of photography and continue your learning.

Introduction to Argentine Tango. $130.00 per couple.

Have you ever wanted to work with clay, but not known where to start? Come and learn a range of skills that you can later adapt to fulfil your creative ideas. This course, designed for beginners or relative beginners, teaches hand building skills in a structured way. It is essential to attend the first two evening classes or the first weekend day to learn foundational skills. Read below dates for more information. The first three upcoming courses are visible. To see later course dates, click 'show more'.

Eat Auckland Walking Food Tours takes you for a stroll down Ponsonby's memory lane reliving the food history which makes Ponsonby 3 Lamps area so fascinating. Find out about a murder, a brothel owner, and a sly grog operation.

Understanding accounting concepts will help you successfully read, create and comprehend financial reporting. You will gain useful practical knowledge of accounting principles and methods. This course is designed for those new to accounting.

This six week course will cover the foundations of psychology, as well as the major theories associated with a number of branches of the subject - biological psychology, social psychology, cognition and perception, developmental psychology and health psychology.

Discover how to correctly prune fruit trees and ornamental bushes for maximum productivity.

A hands-on introduction to basic car maintenance which will help keep your car costs low and ensure you know what to do if your car breaks down. Workshop runs 8:30 - 11:30am.

Have you got an idea for a storybook character? Learn techniques to create and develop your very own storybook characters. Learn the process of illustrating, developing and producing a children's picture book. Bring your own materials. Read more below.

This course is designed as an introduction to the DSLR camera. Bring your own camera.

Get started using Facebook and Instagram for connecting with friends and family.

This course aims to help you establish the mindset needed to lose weight and make long term lifestyle changes. It covers the fundamental elements of sustainable weight loss, focusing on changing beliefs and habits. Read on below course date for more information.

Come along and spend a day being introduced to the art of calligraphy and learn techniques to achieve beautiful lettering for stationery, invitations, signs and cards. Materials included and you'll take home a starter pack.

For Intermediate to Advanced level English learners.

This course is for those completely new to Adobe Photoshop and offers an introduction to the key concepts of Photoshop and how to digitally manipulate images. The objective of this course is to give participants a basic understanding of Photoshop and the potential that Photoshop offers. Strong general computer skills are needed. Please read more information about suitability below the course dates.

A, de or en? Para or por? Get a handle on tricky Spanish prepositions with Sergio. Suitable for all level of Spanish learners.

Come and work with fabrics, papers, beads and a variety of textiles to make creative art. This is a course for beginners and improvers alike, led by an internationally experienced artist and author. You will leave with your very own book of samples and ideas to pursue your obsession.

Come and enjoy working with this easy medium to create your own gorgeous flowers. On the second day you will assemble your flowers to make either a wreath or you can create your own floral arrangement. Your course fee includes all materials.

Designed for those with some painting experience, this workshop will give students opportunities to experiment and learn various watercolour techniques. This is a chance to explore a less botanical, more expressive and contemporary way of depicting flowers. I'd like to encourage students to paint in a freer, looser way.

Make your next trip more enjoyable by learning some French before you go. This course is designed for those new, or relatively new, to French language.

Learn to create closed terrariums and take home your own miniature indoor garden at the end of the workshop

For those who have attended our Mobile Phone Photography Snapseed course. Extend your skills and learn new composition techniques, editing workflow with Lightroom Mobile and Snapseed.

Come and learn how to create your own bird bath or patio bowl using recycled, beautiful, broken china and found objects.

Come and learn how to create a cake that has the WOW factor! Naked cakes have no outside layer of icing allowing you to show off the delicious layers and fillings inside and create amazing toppings. In our November course, Oscar will offer suggestions to ice the cake with a Christmas theme, giving the option of a fresh approach to this seasonal cake.

Join Masterchef NZ 2013 winner Aaron Brunet to make and taste delicious plant-based meals. Suitable for those on vegan diets. All ingredients included.

Join resin artist Andrea Waterhouse and make your own personalised piece of resin art to hang on your wall.

Rome: the very name conjures up excitement and romance. The intending traveller to Italy will be introduced to some little known places and local favourites as well as major tourist attractions.

Facebook, Twitter, LinkedIn and Instagram. We've all heard of them, but do we really know how to unlock their full potential for enjoyment and business use? In this course, professional Social Media Consultant Clark Valmont teaches you about promoting your business, brand or dream idea on social media and how to get engagement that turns into real business results.

Biryani is a celebration of all that is great about Indian food. Join chef Prateek to learn to make this famed dish, then enjoy a tasty lunch at the end of the session.

Buongiorno. This lively course introduces the basics of the Italian language. Enrich your time in Italy by being able to communicate. This course runs 10am - 4pm on Saturday 28 March 2020 or Sunday 24 May 2020 and is designed for those new, or relatively new, to the language.

Learn to create your own healthy bread knowing the ingredients will be good for you? You'll learn some delicious and healthy varieties including walnut and fig and beetroot bread.

Having style is the ability to know how to create a fantastic look that is uniquely you. Come and learn tips and tricks to work with your own figure, personality and lifestyle to create a look that flatters you, and is uniquely you!

Do you find it hard to make the time to do something just for YOU! These three hour classes held on Sunday afternoons during term time are an opportunity for you to relax, learn something new and meet other people who also live busy lifestyles. So, join Astar, leave the kids at home, forget about the housework, don't worry about dinner - instead, get creative with crafting, while chilling, meeting others and having a glass of wine. Join whichever sessions take your fancy. Scroll down for more information.

Be part of the movement to reduce plastic waste! Join Kimberly in the kitchen where she will show you how to make your own reusable beeswax food wraps - a beautiful alternative to plastic cling film. Course fee includes $10.00 for materials. New courses will be scheduled according to demand so register your interest!

Be part of the movement to reduce plastic waste! Join Kimberly in the kitchen where she will show you how to make your own reusable beeswax food wraps - a beautiful alternative to plastic cling film. Course fee includes $10.00 for materials. New courses will be scheduled according to demand so register your interest!

Discover how to correctly prune fruit trees and ornamental bushes for maximum productivity.

Create your own masterpiece to enhance your garden or interior spaces. The soft stone sculpture is one of the most accessible mediums to work with as ideas can be quickly realised and easily modified. Includes sculpting block. Courses run 11am - 4pm.

Join Jo Seagar for a long Italian lunch. Jo will demonstrate a range of recipes and you'll enjoy the prepared food and wine. Jo will be donating the proceeds of this course to Hospice.

This convivial cooking experience will lead you through an encounter with the flavours, aromas, spices and the culture of Silvia's beloved Mexico and its flavourful cuisine. The course fee includes all ingredients.

For many of us, all we know about Islam is what we hear in the media. Here is your chance to learn more about this rich and old religion. Learn about the prophets of God, the holy book The Qur'an, women in Islam, the concept of life in Islam, the prohibited, science and Islam today.

From minions to penguins, elephants to giraffes, and roses to wild flowers, this class  will introduce you to working with sugar paste and modelling fondant to make basic animals, flowers and figurines.

This is a fun and very practical course for people of all ages. You may want to re-kindle an interest in cooking or start from scratch. You may have always had someone cook for you and now you want to learn to cook for yourself.

Following on from the Excel for Beginners course, this intermediate level course takes your Excel skills to the next level. You will learn more formulae, some awesome tips for working with multiple worksheets, advanced printing, sorting, filtering and more. These topics will really improve your productivity and save you lots of time.