Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Microsoft Excel: Intermediate Course

This course is designed for those that use the basic functions within Microsoft Excel and want to learn how to use this powerful tool better. Great follow on course for those that have completed the Microsoft Excel Basic Course.

Description

This course will cover:

1.  Working with Functions

    • Work with Ranges
    • Use Specialized Functions
    • Work with Logical Functions
    • Work with Date and Time Functions
    • Work with Text Functions

2.  Working With Lists

    • Sort Data
    • Filter Data
    • Query Data with Database Functions
    • Outline and Subtotal Data

3.  Analyzing Data

    • Create and Modity Tables
    • Apply Intermediate Conditional Formatting
    • Apply Advanced Conditional Formatting

4.  Visualising Data with Charts

    • Create Charts
    • Modify and Format Charts
    • Use Advanced Chart Features

Similar courses

Xero - An Introduction

Xero is fast becoming the go to in Accounting Software and Systems. This course will give you an Introduction to this system. Suitable for those looking at Xero, just started or wanting to get more out of Xero.

More Information
Xero - The Next Steps

You have learnt and understood the basic principle of Xero and are ready to learn more. Then this course is for you.

More Information
Payroll

An introduction to what you need to know and do as an Employer and how to manage your Payroll manually with a brief introduction to Computerised Systems.

More Information
Accounting & Tax - An Introduction

In this course you will understand the Accounting principles and gain a good grounding in how Accounting works in a Business Environment.

More Information
Ways to Improve You Employability

You may be new to the workforce, returning to the workforce or just unable to obtain that Interview. This course will guide you through what should be put into your CV and how to manage the Interview process.

More Information
Microsoft Excel - Basic Course

This course is a great course to introduce new users into how to use Microsoft Excel as a personal or business tool. Will enable users to understand the basic functions and become familiar with Spreadsheets and how they are used. At the end of the course - there maybe time to chat with the Tutor regarding any individual problems you may be having with your own spreadsheets and excel files.

More Information
Microsoft Excel: Advanced Course

Students in this couse will learn some of the more advanced functions and features of Excel enabling users to make the most of this program in their workplace or at home.

More Information
Microsoft Power Point Basics

If your new to using Power Point, this course will allow you to become familiar with the basic functions and abilities of Power Point.

More Information
Microsoft PowerPoint Intermediate

Build on the knowledge you have or have gained from the PowerPoint Basics course.

More Information
Microsoft Word Basic

An Introduction into using Microsoft Word programme

More Information
Microsoft Word Intermediate

Build on what you already know or from what you have learnt in the Microsoft Word Basics course

More Information
Get Noticed, Get the Job

Learn to present your CV and covering letters in a way that stands out from the crowd. Then learn how to create an engaging LinkedIn profile that builds your network. This is a popular course held at Selwyn Community Centre and now available to attend on the North Shore.

More Information

Press enter to see more results