Course Details close

Course Details

Price:
(inc GST)
$ 385
Application:Excel
Level:Beginner
Version:2010
Duration:1 day
Location:
ITIC Live
Level 3, 321 Pitt St
Sydney NSW 2000
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 2010 Course

   (4.83 out of 5)
1431 Excel beginner student evaluations
Location: ITIC Live: Level 3
321 Pitt St
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)
$

Quick links

Excel Beginner 2010 Course

Course Overview

This course is designed for people with no prior knowledge of Excel 2010 or Excel spreadsheets in general. They may be able to enter data but would like to be able to format the information and set up the spreadsheet to give it a more professional appearance for presentation purposes or printing. They may want to learn how to enter an Excel formula so that it automatically updates when changes are made the data stored within the Excel spreadsheet or learn how to make a chart based on the information stored on the worksheet. It would be helpful to have a basic understanding of computers and basic typing skills.

Upon completion of this course students will gain an understanding of the concepts and terminology used in Microsoft Excel 2010. They will be able to confidently enter, navigate, edit and format data, use and enter a range of basic formulas using the inbuilt Excel tools and wizards, and print their existing workbooks. Students will also gain skills working with the Excel ‘file ribbon’, build and update Excel charts and work with multiple windows within the Excel 2010 environment.

Course Prerequisites

Windows 7: Beginner or equivalent experience

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.

Webinar Course Dates (via Zoom)

Course Date Price Add Course Qty Status
19-Jan-21 (Tue)$385.00 0
08-Feb-21 (Mon)$385.00 0
24-Feb-21 (Wed)$385.00 0

Public Course Dates (Face to Face)

Course Date Price Add Course Qty Status
27-Jan-21 (Wed)$385.00 0
16-Feb-21 (Tue)$385.00 0
01-Mar-21 (Mon)$385.00 0
22-Mar-21 (Mon)$385.00 0
29-Mar-21 (Mon)$385.00 0
13-Apr-21 (Tue)$385.00 0

Course Outline

GETTING STARTED

The Microsoft Excel Screen

The Microsoft Excel Ribbon

  • Contextual Tabs In The Ribbon
  • Live Previews
  • Working With The Quick Access Toolbar
  • Adding Icons To The Quick Access Toolbar
  • Removing Icons From Quick Access Toolbar
  • Change The Location Of The Quick Access Toolbar
  • Group Dialogue Box Launchers
  • Right Click Using The Mouse
  • Keyboard Shortcuts
  • Changing The Workbook View
  • Show / Hide Excel Elements

The Excel Backstage View

  • Introduction To The Backstage View
  • Opening An Excel Spreadsheet
  • Closing An Excel Spreadsheet
  • Create a New Workbook In Excel

Selection Techniques In Excel

  • Single Cell Selection
  • Selecting A Range of Cells Using the Mouse
  • Select A Group Of Cells Using
  • Select A Whole Column
  • Select A Whole Row
  • Select The Whole Worksheet
  • Selecting Non-Adjacent Ranges In A Worksheet

Navigating In Excel

  • The ActiveCell
  • Moving The ActiveCell Using The Keyboard
  • Moving The ActiveCell Using The Name Box
  • Moving The ActiveCell Within A Selected Range
  • Inserting A New Worksheet
  • Selecting Different Sheets Within A Workbook

Data Entry

  • Entering Text
  • Edit Text In the ActiveCell
  • Edit Text In The ActiveCell Using The Formula Bar
  • Replacing The Contents Of A Cell
  • Deleting The Contents Of A Cell
  • Undo And Redo Actions
  • Entering A Date
  • Entering A Heading
  • Enter A Number As A Value
  • Enter A Number As A Label

AutoFilling In Excel

  • Automatically Fill In A Series Of Months
  • Automatically Fill In A Series Of Days
  • Enter A Series Of Dates
  • Enter A Series Of Numbers

AutoFill Customisation

  • Create A Custom List
  • Delete A Custom List
  • Use AutoFill To Enter Data
  • Enter Data Into A Range Of Cells In A Worksheet
  • Filling Common Data Into A Range Of Cells

Workbook Management

  • Saving For The First Time
  • Creating A Copy Using Save As
  • Save Using A Different File Format
  • Saving Workbooks To Another Folder
  • Saving To A USB
  • Close The Workbook
  • Open An Excel Workbook

CALCULATIONS IN EXCEL

Using Simple Formulas

  • Resize The Formula Bar In Excel
  • Using The Keyboard To Enter A Formula
  • Entering Manual Operators
  • AutoFilling Using Relative Cell References
  • AutoFilling Using Absolute References
  • Applying an Absolute Reference To Cell References

Simple Functions In Excel

  • Entering A Simple Function
  • Using The AutoSum Button To Calculate Totals
  • AutoSum and Manual Selections
  • Entering Other Simple Functions
  • Using AutoComplete To Enter Formulas
  • Turning AutoComplete On Or Off
  • Insert Other Simple Functions Using AutoSum Button
  • Inserting Functions Using A Wizard

AutoCalculate

  • Using AutoCalculate To Do A Calculation

MANAGE WORKSHEETS INFORMATION

Managing Worksheet Information

  • Move Content Using Cut And Paste
  • Drag And Drop Content Using The Mouse
  • Copying And Pasting Content
  • Setting Paste Options
  • Drag And Drop To Copy Content
  • Insert Rows
  • Insert Multiple Rows
  • Delete Rows
  • Insert Columns
  • Insert Multiple Columns
  • Delete Columns
  • Insert And Deleting Cells
  • Rename A Worksheet
  • Add A New Worksheet To The Workbook
  • Moving a Worksheet Within The Workbook
  • Delete a Worksheet Within The Workbook

FORMATTING WORKSHEET INFORMATION

Adjusting Column Widths And Row Heights

  • Adjust The Column Widths
  • Adjust The Row Height
  • Hiding And Unhiding Rows or Columns
  • Freeze Columns And Rows
  • Unfreeze Columns And Rows
  • Split The Worksheet
  • Removing A Split

Formatting Cells With The Ribbon

  • Changing The Font
  • Changing The Current Font Size
  • Make Content Bold
  • Italicize Content
  • Underline Content
  • Changing Font Colour
  • Align Data Within A Cell
  • Indent Data Within A Cell
  • Merge Multiple Cells
  • Wrap Text Into Multiple Rows Within A Cell
  • Change The Number Format To Percentage
  • Setting The Number Of Decimal Places
  • Copy Formats With Format Painter
  • Correcting Display Problems

The Format Cells Dialogue Box

  • Apply A Double Underline
  • Setting The Text Orientation
  • Text Wrapping In A Cell
  • Show Numbers As Currency
  • Set The Date Format
  • Changing The Background Colour Of A Cell
  • Apply An Outline Border To Content
  • Apply A Double Line Border To Content
  • Drawing Borders

SETTING UP THE PAGE AND PRINTING

Setting Up The Page

  • Insert A Page Break
  • Remove A Page Break
  • Setting The Print Area
  • Clearing The Print Area
  • Setting Page Margins By Clicking And Dragging
  • Set The Page Orientation
  • Set The Print Size By Scaling
  • Setting Paper Size
  • Change The Page Margin Using Page Setup
  • Centring Content On The Page
  • Add A Header And Footer For Printing

Print Preview

  • Entering Print Preview
  • Setting Print Preview Options
  • Print The Active Sheets
  • Print The Selected Cells
  • Set Multiple Copies For Print

Student Comments

  • 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 Beginner training course
    Very happy with the course today and the trainer. Very professional and great teacher.
    - Kara
  • Excel Basic Training Course
    Craig was very approachable and conducted the course in a manner easy to understand and held my interest for the whole course
    - David
  • 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
    Geoff was excellent at teaching in this course. He was very interesting and did not make it boring. I would recommend him.
    - Louise
  • Excel VBA Basic training course
    The ability to ask questions throughout the course was extremely valuable. The course tracks closely to the notes which meant I could listen without having to take notes at the same time and the content covered a broad spectrum of concepts and ways VBA could be applied to real life scenarios. Thank you Craig and Mark.. hopefully I will be back in some capacity
    - Mike
  • Excel Basic training course
    The course was very informative and our teacher Libby was excellent
    - Ngaire
  • Excel Beginner training course
    Craig is an excellent teacher
    - Lynn
  • 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
    Good eye opener to shortcuts despite using excels for few years as I learn as you go.
    - Eija
  • Excel Basic Training Course
    Good entry level course to learn the basics of excel 2007/2010
    - Matt
  • Excel Beginner training course
    Thoroughly enjoyed this course! Craig really knows his stuff and taught us some really useful shortcuts.
    - Miriam
  • Excel VBA Basic Training Course
    Craig was very professional in terms of delivering the course. I was very satisfied in terms of what I have learned. My colleague is certainly looking forward to do this course.
    - Patrick
  • Excel Basic Training Course
    Very good hand book and teacher would like to have had more time to understand excel
    - Jenny
  • Excel Basic Training Course
    Cressida was excellent
    - Paula
  • Excel Beginner training course
    I found this training to be absolutely fantastic. Craig clearly knows his content, is super organised and explains points extremely clearly so it is easy to follow. Craig kept it so clear and precise so each point could be followed. Any questions the group had he was more than happy to go back to repeat something. I have already used some of the tips he gave us in the first sessions which has saved time in documents. Having this knowledge makes the working time on documents more efficient.
    - Myree
  • Excel Beginner training course
    Overall a great course and worthwhile starting at the beginning for me - so your survey works well. As I said - it is the best software training I have attended. Great work Thank you ?
    - Nell
  • Excel Basic Training Course
    I am so happy to have chosen rtb for this course and will recommend this to others if they need this. I will also look at completing more \courses with you.
    - Donna
  • Excel Basic training course
    Just to thank Craig for his patience and great teaching.
    - Maria
  • Excel Beginner training course
    Craig was so very knowledgeable on Excel, but so patient with the students. Made me feel like it was OK to not quite get it the first time, and could ask questions or re-hash over something that was not quite understood the first time. Thanks Craig !
    - Lyndall
  • Excel Basic Training Course
    Having a professional, knowledgeable trainer makes learning so much easier
    - Ranes
  • 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
    Fantastic course and great trainer - suitable for adult learning.
    - Clare
  • Excel Beginner training course
    I feel more confident in my ability to work with Excel and enjoyed the process
    - Fiona
  • 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 Beginner training course
    Craig was very helpful and informative. The course was extremely useful at building new skills and advancing old skills.
    - Harriet
  • Excel Beginner training course
    Was an incredibly insightful course
    - Finn
  • 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 Basic Training Course
    I would recommend this course to anybody who has any need to use excel for any reason whatsoever.
    - Mark
  • Excel Beginner training course
    Good course, hopefully will be back after some practice.
    - Mohamad

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us