Business Development Company

Research, Learning, Results

  • Home
  • Who we are
    • Our People
    • Staff
    • Presenters
  • Building Teams
    • Whole Brain Thinking
  • Learning
    • Register for a course
    • Online Learning
    • My Learning
    • My Account
  • Sustainability
  • Our Thoughts
  • Contact Us
  • Login
  • Log In

Microsoft Excel Intermediate

Programme overview

The training focuses on the more advanced features within Excel, in particular, functions and formatting of worksheets; and using multiple worksheets. We will assume that you already have a basic, working knowledge of Excel (see Excel Foundation course).

Gain a greater understanding of the working of Microsoft Excel, including how to work between multiple worksheets and workbooks. Learn how to import Excel information into other Microsoft Office applications.

This course is designed for

People already familiar with the basic features of Microsoft Excel and who want to develop their skills and expertise.

Benefits

The greatest benefit? Feel more confident. Ditch the frustration and become more competent in your work.

Skills taught

This training is ‘hands on’ and covers the following:
  • the interface, tabs and ribbons
  • absolute and relative cell referencing
  • inserting objects  – tables, pivot charts and sparklines
  • the ‘if’ functions, including ‘sumif’ and ‘countif’
  • worksheet consolidation
  • lookup function and its implementation
  • formulas
  • the ‘developer tab’
  • managing data
  • conditional formatting.

What to expect

This workshop is delivered over two sessions to small groups, not exceeding five, with each person having their own computer to work with and a manual to support the learning. This training can be tailored to meet organisational needs.


Register now

What people say

Thank you so much for the course, I really enjoyed it and I am sure I will be able to utilize the Excel skills in my role. Stacey is a great teacher, really friendly and happy to answer any weird and interesting questions that were thrown her way.
Latania Leach, Cawthron Institute

Presenter: Dr Pip Lynch

Courses we offer

Herrmann Whole Brain Thinking
  • Building Team Performance – *In-house only*
  • Customer Relationship Management – *In-house only*
  • Smart Thinking
  • Strategic Planning- *In-house only*
Online Learning

Online ‘Expand your thinking’ series using Herrmann Whole Brain Thinking

Practice Thinking Blue
Practice Thinking Green
Practice Thinking Red
Practice Thinking Yellow
Computer Skills
  • Microsoft Excel Foundation
  • Microsoft Excel Intermediate
  • Microsoft Outlook Foundation
  • Microsoft Outlook Intermediate
  • Microsoft Powerpoint
  • Microsoft Project Foundation
  • Microsoft Word Foundation
  • Microsoft Word Intermediate
Leadership
  • Leading for Performance
  • Self-Leadership for Success
Business Management
  • Better Business Writing – *In-house only*
  • Project Management – *In-house only*
Personal Development
  • Conflict to Collaboration
  • Personal Productivity
  • Powerful Presentations
  • Resilience and Wellbeing

Scheduled Courses

Leading for Performance

4-part series developing the skills required for effective feedback, motivation and delegation.

Date: Thursdays 3, 10, 17 & 24 May 2018
Time: 9am - 12pm
Investment: $860 + GST
Course description
Book now

Personal Productivity

Get the most out of your day. Gain back control of your time. Learn practical tools to implement straight away.

Date: Tuesday 8 May
Time: 9am - 4:30pm
Investment: $425 + GST & $150 + GST for one-on-one coaching
Course description
Book now

Conflict to Collaboration

Learn negotiating and collaborating skills for effective communication.

Date: Thursday 31 May and 7 June 2018
Time: 9am - 12pm
Investment: $425 + GST
Course description
Book now

Self-Leadership for Success

Develop your unique style and effective communication. This course is the perfect leadership preparation.

Date: Tuesdays 12 & 19 June
Time: 9am - 12pm
Investment: $425 + GST
Course description
Book now

What people say

Our staff have benefited immensely from a variety of up skilling and training courses that have been provided by the Business Development Company. All of the presenters have been very knowledgeable and skilled in their subject matter. They have also been exceptional at delivering the material and have engaged our employees in the process which has led to a superior learning experience.

Lees Seymour, Managing Director, Nelson Forests Limited.

Get in touch

03 545 6566
Business Development Company (BDC)
285 Hardy St
P.O. Box 1307
Nelson, 7040
Email us

Connect with us

Find us on Linked InFind us on Facebook

What we do

  • Our Courses
  • Insight
  • Results
  • We’re involved in our community

How we do business

  • Terms and Conditions – Coaching
  • Terms and Conditions – Scheduled Courses
  • Privacy Policy

Subscribe to our mailing list

* = required field

Copyright © 2018 Business Development Company · Website design by Avoca Design