Course Details close

Course Details

Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
$ 250
Application:Excel
Level:Beginner
Version:2013
Duration:1 day
Location:
Level 2
80 Mount St
North Sydney
NSW 2060
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Excel Beginner 2013 Course

   (4.83 out of 5)
1587 Excel beginner student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 1 day Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
$ 250

Quick links

Excel Beginner 2013 Course

Course Overview

This course is designed for people with no prior knowledge of Excel or Excel spreadsheets. They may be able to enter data into their excel spreadsheets however would like to be able to format the spreadsheet to give it a more professional look and feel for printing. They may want to learn how to enter a formula so that it automatically updates when changes are made or learn how to make a chart out of the data already entered into their existing Excel worksheets. It would be beneficial to have a basic understanding of computers and basic typing skills. As a result of this course students will gain understanding of the concepts and terminologies used in Microsoft Excel. They will be able to confidently enter, edit, navigate and format data, create and edit basic formulas and print their workbooks. Students will also gain an insight into working with Excel charts, understand and navigate the new Excel ‘ribbon’ and work with multiple windows.

Course Prerequisites

Basic computer and keyboard skills

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Course Dates

Course Date Price Add Course Qty Status
30-Apr-19 (Tue)$250.00 0
ON SALE
08-May-19 (Wed)$385.00 0
21-May-19 (Tue)$385.00 0
29-May-19 (Wed)$250.00 0
ON SALE
03-Jun-19 (Mon)$385.00 0
11-Jun-19 (Tue)$385.00 0
17-Jun-19 (Mon)$385.00 0
26-Jun-19 (Wed)$385.00 0
01-Jul-19 (Mon)$385.00 0
10-Jul-19 (Wed)$385.00 0
17-Jul-19 (Wed)$385.00 0
23-Jul-19 (Tue)$385.00 0
29-Jul-19 (Mon)$385.00 0
07-Aug-19 (Wed)$385.00 0
12-Aug-19 (Mon)$385.00 0
20-Aug-19 (Tue)$385.00 0
28-Aug-19 (Wed)$385.00 0
03-Sep-19 (Tue)$385.00 0
11-Sep-19 (Wed)$385.00 0
16-Sep-19 (Mon)$385.00 0
23-Sep-19 (Mon)$385.00 0
01-Oct-19 (Tue)$385.00 0
09-Oct-19 (Wed)$385.00 0
Training courses on sale now

Courses start
from $250 (inc GST).
Limited seats.
Book today!

Course Outline

GETTING STARTED

Exploring The Excel Screen

Navigation - The Excel Ribbon

  • Working With Contextual Tabs
  • Using Live Preview
  • Using the Quick Access Toolbar (QAT)
  • Customising The QAT
  • Removing Icons From The QAT
  • Display the QAT Below the Ribbon
  • Introducing Dialogue Box Launchers
  • Accessing The Shortcut Menu Using Right Click
  • Introduction To Keyboard Shortcuts
  • Change Views
  • Showing And Hiding Workbook Elements

The Backstage View

  • Using The Backstage View
  • Opening An Excel Workbook
  • Closing An Excel Workbook
  • Creating a New Excel Workbook

Excel Selection Techniques

  • Selecting A Single Cell
  • Selecting A Range of Cells
  • Selecting A Range Of Cells Using SHIFT
  • Selecting An Entire Column
  • Selecting An Entire Row
  • Selecting The Entire Worksheet
  • Selecting Non-Adjacent Ranges

Navigating In An Excel Worksheet

  • Moving The ActiveCell
  • Move The ActiveCell Using The Keyboard
  • Move Using The Name Box
  • Moving Within A Selected Range
  • Insert A New Worksheet
  • Move To Other Worksheets

Entering Data

  • Enter Text Into The ActiveCell
  • Edit The Contents Of The ActiveCell
  • Edit Text Using The Formula Bar
  • Replace The Contents Of The ActiveCell
  • Delete The Contents Of The ActiveCell
  • Undoing And Redoing Edits
  • Enter A Date In A Cell
  • Enter A Heading
  • Entering Numbers
  • Enter Numbers As Text In A Cell

AutoFilling

  • AutoFill A Series Of Months
  • AutoFilling Days
  • Entering Dates Using AutoFill
  • AutoFilling A Series Of Numbers

Customising AutoFill

  • Customise A Custom List
  • Deleting A Custom List
  • Using A Custom List To Enter Data
  • Entering Data Into A Range Of Cells
  • Fill The Same Data Into A Range Of Cells

Saving Workbooks

  • Saving A Workbook For The First Time
  • Saving A Copy Using Save As
  • Saving A Workbook With A Different File Format
  • Save To Another Folder
  • Saving A Workbook To A USB
  • Closing A Workbook
  • Opening A Workbook

PERFORMING CALCULATIONS IN EXCEL

Creating Simple Formulas

  • Resizing The Formula Bar
  • Entering Formulas Using The Keyboard
  • Manually Entering Formulas
  • Using Relative Cell References
  • Using Absolute Cell References
  • Applying Absolute Cell Reference

Using Common Functions

  • Enter A Function
  • Using AutoSum To Total Columns Or Rows
  • Manual Select Ranges With AutoSum
  • Enter A Function
  • Use AutoComplete To Enter Formulas
  • Enable/Disable Formula AutoComplete
  • Insert Other Functions Using Extended AutoSum
  • Using The Insert Function Wizard

Using AutoCalculate In Excel

  • Get A Quick Result Using AutoCalculate

MANAGE WORKSHEET AND WORKBOOK INFO

Manage Worksheet Information

  • Moving Data Using Cut And Paste
  • Drag And Drop Data
  • Copy And Paste Data
  • Changing Paste Options
  • Drag And Drop To Copy Data
  • Inserting A New Row
  • Inserting Multiple Rows
  • Deleting A Row
  • Inserting A New Column
  • Inserting Multiple Columns
  • Deleting Columns
  • Inserting Cells
  • Deleting Cells
  • Renaming A Worksheet
  • Adding A New Worksheet
  • Moving a Worksheet
  • Deleting a Worksheet

FORMAT WORKSHEETS

Adjust Column Widths And Row Heights

  • Using The Mouse To Adjust The Column Width
  • Using The Menu To Adjust The Column Width
  • Using The Mouse Adjust The Row Height
  • Hide / Unhide Columns And Rows
  • Freezing Panes
  • Unfreezing Panes
  • Splitting A Worksheet
  • Remove A Split

Using The Ribbon To Format Cells

  • Change The Font Style
  • Changing The Font Size
  • Bolding Text
  • Italicise Text
  • Underline Text
  • Change Font Colour
  • Align Data Horizontally and Vertically In A Cell
  • Indenting Data In A Cell
  • Merging Data In A Cell
  • Wrapping Text In A Cell
  • Changing Numbers To Percentages
  • Increasing Or Decreasing Decimal PlacesCopying A Format Using The Format Painter
  • Fix Display Problems

Formatting Data Using Format Cells

  • Double Underline Information
  • Changing Text Orientation In A Cell
  • Wrapping Text In A Cell
  • Formatting Numbers As Currency
  • Formatting Dates
  • Change The Background Colour Of A Cell
  • Setting An Outline Border
  • Setting A Double Line Border
  • Drawing Borders Using The Mouse

PAGE SETUP AND PRINTING

Page Setup

  • Inserting And Removing And Page Breaks
  • Setting and Clearing Print Areas
  • Setting Page Margins Using The Page Layout View
  • Change The Page Orientation
  • Set Scaling Size
  • Changing The Paper Size
  • Change The Page Margins
  • Centring The Printout On The Page
  • Adding Headers And Footers

Print Preview in Excel

  • Viewing Print Preview
  • Printing Options
  • Printing Active Sheets
  • Printing Selected Cells
  • Printing Multiple Copies

Student Comments

  • Excel Basic Training Course
    Love the training facilities and trainer fantastic
    - Peter
  • Excel Basic Training Course
    Facilitator was experienced, well-spoken and helpful. She tried to relate excel to the type of work we required.
    - Elizabetta
  • Excel Basic Training Course
    Absolutely fantastic, very informative, and staff were extremely knowledgeable, and amiable.
    - Declan
  • Excel VBA Training Course - Basic
    I now have a much better understanding of the structure behind VBA, what Option Explicit means, etc. The course cleared up a lot things that confused me a bit, having tried to learn VBA on my own
    - Charl
  • Excel Basic Training Course
    Generally excellent.
    - Jennifer
  • Excel Course - Basic
    The course addressed all my objectives, my trainer was very professional and obviously knew his subject very thoroughly.
    - Leif
  • Excel Basic Training Course
    Even though I was the least experienced in the use of excel, Cressida helped me through the exercises.
    - Jenny
  • Excel Basic Training Course
    The course addressed all my objectives, my trainer was very professional and obviously knew his subject very thoroughly.
    - Leif
  • Excel Basic Training Course
    All the courses I have attended have been excellent in every way. I would recommend this organisation to anyone enquiring. Very very happy!!
    - Elisabeth
  • Excel Basic Training Course
    Very happy with course and learnt a lot
    - Robyn
  • Excel Basic Training Course
    Great course, enjoyed it immensely, Caroline was fantastic, very professional and easy to understand
    - Aileen
  • Excel Basic Training Course
    Fantastic tutor and class. Would highly recommend to all. I have never seen such clean toilets and superb facilities
    - Taylor
  • Excel Beginner training course
    Very professional trainer, never felt stupid for asking questions and was able to explain everything perfectly. Thanks Craig :)
    - Christie
  • Excel Basic Training Course
    Cressida was excellent
    - Paula
  • Excel Basic Training Course
    having the manual with all the course content in front of you as you are being taught so that you always have a point of reference to go back to if you forget how to perform a particular task
    - Nick
  • Excel Basic Training Course
    Excellent course
    - Savitree
  • Excel Basic Training Course
    Great course to give you a good insight on the powerful tool that excel is.
    - Dean
  • Excel Beginner training course
    great content and easy to understand. Will recommend
    - Benjamin
  • Excel Basic Training Course
    Excellent trainer, very thorough and helpful, extremely knowledgeable
    - Mirianna
  • Excel Basic training course
    Just to thank Craig for his patience and great teaching.
    - Maria
  • Excel Beginner training course
    Fabulous trainer and really heapful
    - Christina
  • Excel Beginner training course
    From start to end it was helpful and useful, it was a top tier course.
    - Liam
  • Excel Beginner training course
    Sean was excellent - very knowledgeable but also made it an enjoyable day
    - Mark
  • Excel Basic training course
    Enjoyed course and very relevant.
    - Darren
  • Excel Beginner training course
    Very happy with the course today and the trainer. Very professional and great teacher.
    - Kara
  • Excel Basic Training Course
    Sean is a great teacher, very knowledgeable and easy to follow. I didn't expect much and to learn much but was surprised of how engaging and useful and interesting the course was. Great Work!
    - Victor
  • Excel Basic Training Course
    Very happy with course outcome, feel confident returning to work and applying these new skills and eventually furthering them
    - Rebekah
  • Excel Basic Training Course
    Great day. The course was very useful & all the staff members were helpful, approachable and professional. I really enjoyed the course & I will come back in the future if I would like to do more courses.
    - Courtney
  • Excel Training Course - Basic
    The entire course was useful and very relevant to myself. I had no idea about excel prior to this course and I now have a basic idea, (which is why I came). I will definitely be returning to complete other subjects/courses on offer.
    - Hayley
  • Excel Basic Training Course
    Fantastic course. Most useful course I have done in a long time.
    - Nathan

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us