Professional and Executive Development

• Administration
• Communication
• Finance and Accounting
• Information Management
• Languages and Cultures
• Māori Language, Society & Culture
• Management and Leadership
• Marketing
• People and Performance
• Personal Effectiveness
• Project and Strategy Management
• Public Policy and Management
• Research - Skills & Software
• Software for the Office
• xxLanguages and Cultures
• xxLanguages and Cultures
• Customised and In-house Programmes
• Computer Suite for Hire
•  Course Schedule

This website is
printer friendly.

Excel Smartskills

Overview: Who should attend: Learning objectives:

Course outline: Course format: Further details:

Overview:

This course fills gaps in your Excel knowledge, explores features like creating formulas and suggests tips for managing your data more effectively.

Come along with your questions and learn tips and tricks for working with Excel more efficiently.

 

^ Top of page

Who should attend:

This course is suitable for people who are using Excel but want to know more. It assumes you have basic Excel skills – for example you should be confident entering data into cells, creating simple formulas and basic formatting. This is not an advanced Excel course.

Please note - we are now using Office 2007 software and Windows XP for training purposes.

 

^ Top of page

Learning objectives:

• Expand the range of uses you have for Excel by exploring ways of working with data, spreadsheets
• Utilise Excel to present your data professionally
• Get answers to common questions about working with Excel

 

^ Top of page

Course outline:

• Managing your data
  • Sorting data
  • Filtering
  • Adding comments
• Working with large spreadsheets
  • Splitting the window
  • Freezing panes
• Using formulas
  • Creating formulas
  • IF, AND and OR
  • Filling
• Sharing workbooks
  • Sharing your workbook
  • Protecting your workbook

 

^ Top of page

Course format:

This is a hands-on workshop in our Computer Training Suite, the tutor will demonstrate various tasks and you will have chance to practise these tasks and ask relevant questions. You will receive course materials to take away.

 

^ Top of page

Limit per course: 12

We offer these dates:

Date: Thursday 8 April
Time: 9am-12:30pm
Venue:
Downtown venue at Pipitea campus to be advised

Fee: $175.50 (excl. GST)
The above Early Bird fee is available if booked on or before Thursday 11 March. Full fee: $195 (ex. GST)

or

Date: Thursday 3 June
Time: 9am-12:30pm
Venue:
Downtown venue at Pipitea campus to be advised

Fee: $175.50 (excl. GST)
The above Early Bird fee is available if booked on or before Thursday 6 May. Full fee: $195 (ex. GST)

or

Date: Thursday 26 August
Time: 9am-12:30pm
Venue:
Downtown venue at Pipitea campus to be advised

Fee: $175.50 (excl. GST)
The above Early Bird fee is available if booked on or before Friday 9 July. Full fee: $195 (ex. GST)

or

Date: Thursday 4 November
Time: 9am-12:30pm
Venue:
Downtown venue at Pipitea campus to be advised

Fee: $175.50 (excl. GST)
The above Early Bird fee is available if booked on or before Thursday 7 October. Full fee: $195 (ex. GST)

Louise Head