AUCKLAND (09) 378-0411       HAMILTON (07) 838-0700       WELLINGTON (04) 472-4830      CHRISTCHURCH (03) 365-5020      |      
Home Courses Excel Timesaving Features

Courses


Excel Timesaving Features

Length: 1    Cost: $325 + GST    Version: Excel

= Scheduled class    = Guaranteed to run    = Fully booked
Click on the dates to book online
CentreAprMayJunJul
Auckland--
10
25
09
20
07
31
Hamilton--
10
20
07
31
Christchurch--
19
21
--
Wellington--
03
10
10
16
16
13
29
11
25

Can't find a class in your area? Contact our sales team and request a class date.
Not sure about the version of your software? Click here to find out.
Want to know if this course is right for you? Assess your skills level with our online Skills Assessment tool.


Prerequisites

Attendees must have a thorough understanding of file handling, spreadsheet fundamentals, and have used simple functions and formulas in Excel, as covered in our Excel Essential Skills course.

At Course Completion

This course concentrates on introducing attendees to some of the more productive tools and time saving features of the program. It focuses on how to build accurate spreadsheets that survive changes without errors.

Course Outline


Working with Worksheets and Workbooks
Learn how to view two different parts of your worksheets at once or two different worksheets at once. Group sheets together so that you can work on several at once. Create a link between two workbooks or consolidate the data from several workbooks into a single summary. Save a workspace to save time in the future.

Working with Formulae and Functions 2
Focus on conditional functions such as IF, COUNTIF and SUMIF Working with Formulae and Functions 1 is in our Excel Essential Skills course)

Working with Formats
Control how numbers are displayed in your workbook. Learn about Conditional Formats. Create and apply your own style with customised formats

Link to other documents
Create formulas to other excel spreadsheets or hyperlinks to other documents

Using Templates
Possibly the biggest time saving feature of all: make your own template.

Auditing a Worksheet
Discover how to control what data is entered into your spreadsheet and then learn how to find just where that error is coming from.

Working with Data 1
Subtotal your data or apply a Filter. (Working with Data 2 is in our Excel Data Analysis and Reporting course)

Using Names
Name a cell. Name a range of cells. Name a constant. Makes things a lot easier.

Collaborating with Workgroups
Protect your workbook to stop accidental editing.


 Print this page