Book Online: Login | Register

1300 658 388

Search form

 

 

 

This course provides a solid grounding in the more commonly used formulas and functions in Excel and in the best practice methods for analysing data. You will learn techniques to help you find information, write formulas and analyse data in tables, lists and charts and how to get the most out of the powerful Pivot Tables and Pivot Chart data analysis tools.

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

2007

You'll Learn how to: 
  • Find information using Find/Replace and conditional formatting
  • Use absolute and relative references in formulas
  • Create range names
  • Use statistical, logical, math and date Functions
  • Sort and filter lists of data
  • Use subtotals to summarise lists
  • Create and modify charts
  • Create and modify PivotTables and PivotCharts
Course Content: 

Finding and replacing

Finding and replacing text and values

Conditional formatting

Applying and clearing conditional formatting
Top ten items
Working with Data Bars, Colour Scales and Icon Sets
Creating and editing Sparklines

Formula referencing

Absolute versus relative referencing
Creating absolute and mixed references

Labels and names

Creating names for cell ranges
Using names to select ranges
Using names in formulas

Statistical Functions

Using COUNT, COUNTA and COUNTIF
Using MODE, MEDIAN and STDEV

Logical Functions

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

Math Functions

Using INT, ROUND and PRODUCT
Using SUMIF, SUMIFS and SUMPRODUCT

Date and time Functions

Using NOW and TODAY
Calculating future dates
Using DATE, WEEKDAY and EOMONTH

Sorting and filtering data

Performing an alphabetical and numerical sort
Sorting on more than one column
Applying and using a filter
Creating custom filters

Summarising and subtotalling

Creating and using subtotals

Creating charts

Creating a new chart
Working with an embedded chart
Resizing a chart
Printing charts
Creating a chart sheet
Changing the chart type and chart layout
Changing the chart style
Deleting a chart

Charting techniques

Adding a chart title and axes titles
Positioning the legend and showing data labels
Modifying the axes and formatting the plot area
Adding a trendline

Chart object formatting

Selecting chart elements
Changing column colour
Filling the chart area and the plot area

Pivot Tables

Creating a PivotTable
Filtering a PivotTable report
Clearing a report filter
Formatting a PivotTable report
Creating slicers

PivotTable techniques

Using compound fields
Counting in a PivotTable report
Formatting PivotTable report values
Working with PivotTable totals
Grouping in PivotTable reports
Creating calculated fields
PivotTable options

PivotCharts

Creating a PivotChart
Changing the PivotChart type
Using the PivotChart filter field buttons

This Course Suits: 

This course will suit you if you are an experienced Excel user working on existing spreadsheets or if you are designing and creating your own models and need to get a good grounding in some of the more complex formulas and data analysis methods used in Excel.

Prerequisites: 

Successful completion of TP3 Excel Introduction 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.

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

3 Aug 17

Classroom

08:45 to 16:45

$450.00
Melbourne

16 Aug 17

Classroom

08:45 to 16:45

$450.00
Melbourne

24 Aug 17

Classroom

08:45 to 16:45

$450.00
Melbourne

5 Sep 17

Classroom

08:45 to 16:45

$450.00
Melbourne

14 Sep 17

Classroom

08:45 to 16:45

$450.00
Melbourne

22 Sep 17

Classroom

08:45 to 16:45

$450.00
Melbourne

6 Oct 17

Classroom

08:45 to 16:45

$450.00
Melbourne

16 Oct 17

Classroom

08:45 to 16:45

$450.00
Melbourne

25 Oct 17

Classroom

08:45 to 16:45

$450.00
Melbourne

1 Nov 17

Classroom

08:45 to 16:45

$450.00
Melbourne

13 Nov 17

Classroom

08:45 to 16:45

$450.00
Melbourne

22 Nov 17

Classroom

08:45 to 16:45

$450.00
Melbourne

29 Nov 17

Classroom

08:45 to 16:45

$450.00
Melbourne

5 Dec 17

Classroom

08:45 to 16:45

$450.00
Melbourne

13 Dec 17

Classroom

08:45 to 16:45

$450.00
Melbourne

18 Dec 17

Classroom

08:45 to 16:45

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