Book Online: Login | Register

1300 658 388

Search form

 

 

 

This course introduces you to Excel spreadsheets and how they are used in business. You will learn to create, edit, format and print professional looking spreadsheets using simple formulas.

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

2007

You'll Learn how to: 
  • Start and explore Excel
  • Navigate around the workbook
  • Enter and edit data
  • Use simple formulas
  • Manipulate data
  • Format data
  • Preview and print data
Course Content: 

Getting to know Microsoft Excel

The Excel 2010 screen
Using short cut menus
Launching Dialog Boxes

Creating a new workbook

Typing text, numbers, dates and formulas
Making basic changes

Working with workbooks

Navigating using the keyboard
Using Go To

Editing in a workbook

Editing formulas
Clearing and deleting data in a cell
Using Undo and Redo

Selecting ranges

Selecting contiguous and non contiguous ranges
Using special selection techniques
Selecting larger ranges

Copying data

Using Fill for quick copying
Copying from one range to another
Copying to another worksheet

Filling data

Filling a series
Filling using options
Creating a custom Fill list

Formulas and Functions

Creating formulas that add and subtract
Creating formulas that multiply and divide
Using the Sum Function to add
Finding an average
Finding a maximum and minimum value
Common error messages

Font formatting

Changing fonts
Making text bold, italicised and underlined
Changing font colours
Using the Format Painter

Cell alignment

Aligning left, right and centre
Rotating, indenting, wrapping and merging text

Row and column formatting

Setting columns widths and row heights
Hiding rows and columns

Number formatting

Formatting as currency
Formatting percentages
Increasing and decreasing decimals

Printing

Previewing and printing a range
Printing an entire workbook

Applying borders

Applying a border to a range
Removing borders

Working with a worksheet

Worksheet zooming
Inserting and deleting cells, columns and rows
Switching between worksheets

Worksheet techniques

Inserting, deleting, moving, copying and renaming a worksheet
Grouping worksheets
Freezing rows and columns

Page Setup

Page breaks
Settings rows as repeating print titles
Scaling to a percentage

Getting Help

Browsing for help

This Course Suits: 

This course will suit you if you are a beginner and are just getting started with Excel.

Prerequisites: 

Successful completion of TP3 Computer Fundamentals course or equivalent knowledge and skills are required to participate in this course.

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

14 Aug 17

Classroom

08:45 to 16:45

$450.00
Melbourne

22 Aug 17

Classroom

08:45 to 16:45

$450.00
Melbourne

4 Sep 17

Classroom

08:45 to 16:45

$450.00
Melbourne

12 Sep 17

Classroom

08:45 to 16:45

$450.00
Melbourne

20 Sep 17

Classroom

08:45 to 16:45

$450.00
Melbourne

26 Sep 17

Classroom

08:45 to 16:45

$450.00
Melbourne

5 Oct 17

Classroom

08:45 to 16:45

$450.00
Melbourne

19 Oct 17

Classroom

08:45 to 16:45

$450.00
Melbourne

31 Oct 17

Classroom

08:45 to 16:45

$450.00
Melbourne

9 Nov 17

Classroom

08:45 to 16:45

$450.00
Melbourne

20 Nov 17

Classroom

08:45 to 16:45

$450.00
Melbourne

28 Nov 17

Classroom

08:45 to 16:45

$450.00
Melbourne

4 Dec 17

Classroom

08:45 to 16:45

$450.00
Melbourne

12 Dec 17

Classroom

08:45 to 16:45

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