Book Online: Login | Register

1300 658 388

Search form

 

 

Discover best practice in the design and deployment of business spreadsheets and how to create user-friendly, automated spreadsheet solutions designed to be used by others. You will also learn to work with complex formulas and advanced analysis tools.

Course Price (inc GST where applicable): 
$450.00
Locations: 
Sydney, Melbourne
Duration: 
1 day
Versions: 

2016

You'll Learn how to: 
  • Use Link formulas
  • Consolidate data
  • Use Data Validation and Auditing tools
  • Protect worksheet data
  • Automate routine tasks with Macros
  • Use Logical, Lookup, Financial and Text Functions
  • Use Goal Seek, Scenario Manager and Solver
Course Content: 

Data linking

Linking between worksheets and workbooks
Updating links between workbooks

Data consolidation

Consolidating data
Creating an outlined consolidation

Validating data

Creating and testing a validation
Creating an input and error message
Creating a drop down list
Circling invalid data

Protecting data

Protecting a worksheet and workbook
Providing restricted access to cells

Recorded Macros

Setting Macro security
Recording an running a simple Macro
Editing and deleting a Macro
Assigning a Macro to the ribbon and keyboard shortcut

Logical Functions

Using IF to display text and calculate values
Nesting IF Functions
Using IFERROR, AND, OR and NOT

Lookup Functions

Using CHOOSE,  VLOOKUP and HLOOKUP
Using INDEX and MATCH
Using ROW, ROWS, COLUMN and COLUMNS
Using ADDRESS, INDIRECT and OFFSET

Financial Functions

Using PMT,  FV and NPV

Text Functions

Using PROPER, UPPER and LOWER
Using CONCATENATE
Using LEFT,  RIGHT, MID and LEN

Advanced analysis tools

Using Goal Seek
Creating Scenarios
Using Solver

This Course Suits: 

This course will suit you if you are an experienced Excel user who will be creating spreadsheet templates or automated solutions for others in the organisation to use.

Prerequisites: 

Successful completion of TP3 Excel Level 2 - Intermediate courses or equivalent knowledge and skills are required to participate in this course.

Not sure if you meet the prerequisites?

Click here to take our quick online course prerequisite test.

The Learning Process: 
Preparing to learn

Get the most out of your course by preparing before you attend. TP3 provide pre-course materials that enable you to reflect on and align your learning outcomes with the course content.

After the course

TP3's online Learning Resources contains additional tools and resources to help you consolidate and continue your learning. For more details, click here.

Customising this course: 

TP3 can provide a range of consulting services to better meet your business needs, including closed courses for your organisation, customised course material relevant to your industry and requirements, individual or group coaching and blended learning solutions.

Booking Information: 
Call 1300 658 388 to book this course, or book and pay online below.
Course Dates: 

To sort results, click on column heading.

Guaranteed To Run courses are marked with

Location Course Dates Delivery Method Course Times Price (inc GST) GTR ADD TO CART/WISHLIST
Melbourne

25 Jul 17

Classroom

08:45 to 16:45

$450.00
Melbourne

7 Aug 17

Classroom

08:45 to 16:45

$450.00
Melbourne

18 Aug 17

Classroom

08:45 to 16:45

$450.00
Melbourne

28 Aug 17

Classroom

08:45 to 16:45

$450.00
Melbourne

7 Sep 17

Classroom

08:45 to 16:45

$450.00
Melbourne

18 Sep 17

Classroom

08:45 to 16:45

$450.00
Melbourne

9 Oct 17

Classroom

08:45 to 16:45

$450.00
Melbourne

27 Oct 17

Classroom

08:45 to 16:45

$450.00
Melbourne

14 Nov 17

Classroom

08:45 to 16:45

$450.00
Melbourne

24 Nov 17

Classroom

08:45 to 16:45

$450.00
Melbourne

6 Dec 17

Classroom

08:45 to 16:45

$450.00
Sydney

4 Jul 17

Classroom

08:45 to 16:45

$450.00
Sydney

13 Jul 17

Classroom

08:45 to 16:45

$450.00
Sydney

25 Jul 17

Classroom

08:45 to 16:45

$450.00
Sydney

10 Aug 17

Classroom

08:45 to 16:45

$450.00
Sydney

18 Aug 17

Classroom

08:45 to 16:45

$450.00
Sydney

23 Aug 17

Classroom

08:45 to 16:45

$450.00
Sydney

8 Sep 17

Classroom

08:45 to 16:45

$450.00
Sydney

14 Sep 17

Classroom

08:45 to 16:45

$450.00
Sydney

25 Sep 17

Classroom

08:45 to 16:45

$450.00

Pages

Twitter icon
Facebook icon
Google icon
LinkedIn icon
e-mail icon