SydneyMelbourneBrisbaneAdelaidePerthParramattaCanberra

BOOK NOW

Course Details
Price: $330Excel Training Price
Duration: One Day
Excel Training ClockTime: 9am – 4pm (approx)
Classes capped at 10 people (average 5 people)
Excel Training TeamReference manuals provided
Training computer provided

Course Outline
PDFExcel Beginner

Upcoming Dates
Tue 29-May-18 Excel Beginner Sydney No more seats are available for this course.
Mon 04-Jun-18 Excel Beginner Sydney Course confirmed to run. Trainer has been allocated.
Tue 12-Jun-18 Excel Beginner Sydney Course confirmed to run. Limited number of seats available.
Mon 09-Jul-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Tue 24-Jul-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Mon 06-Aug-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Thu 16-Aug-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Wed 22-Aug-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Fri 07-Sep-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Mon 17-Sep-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Wed 03-Oct-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
Thu 18-Oct-18 Excel Beginner Sydney Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $330Excel Training Price
Duration: One Day
ClockTime: 9am – 4pm (approx)
Classes capped at 10 people (average 5 people)
Excel Training TeamReference manuals provided
Training computer provided

Course Outline
PDFExcel Beginner

Upcoming Dates
Tue 29-May-18 Excel Beginner Melbourne Course confirmed to run. Limited number of seats available.
Mon 04-Jun-18 Excel Beginner Melbourne Course confirmed to run. Limited number of seats available.
Tue 12-Jun-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Wed 27-Jun-18 Excel Beginner Melbourne Course confirmed to run. Limited number of seats available.
Mon 09-Jul-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Tue 24-Jul-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Mon 06-Aug-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Thu 16-Aug-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Wed 22-Aug-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Fri 07-Sep-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Mon 17-Sep-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
Wed 03-Oct-18 Excel Beginner Melbourne Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $330Excel Training Price
Duration: One Day
Excel Training ClockTime: 9am – 4pm (approx)
Classes capped at 10 people (average 5 people)
Excel Training TeamReference manuals provided
Training computer provided

Course Outline
PDFExcel Beginner

Upcoming Dates
Tue 29-May-18 Excel Beginner Brisbane No more seats are available for this course.
Mon 04-Jun-18 Excel Beginner Brisbane Course confirmed to run. Limited number of seats available.
Tue 12-Jun-18 Excel Beginner Brisbane Course confirmed to run. Trainer has been allocated.
Wed 27-Jun-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Wed 04-Jul-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Mon 09-Jul-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Tue 24-Jul-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Mon 06-Aug-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Thu 16-Aug-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Wed 22-Aug-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Fri 07-Sep-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
Mon 17-Sep-18 Excel Beginner Brisbane Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $330Excel Training Price
Duration: One Day
Excel Training ClockTime: 9am – 4pm (approx)
Classes capped at 10 people (average 5 people)
Excel Training TeamReference manuals provided
Training computer provided

Course Outline
PDFExcel Beginner

Upcoming Dates
Thu 31-May-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Mon 18-Jun-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Wed 27-Jun-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Mon 09-Jul-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Tue 24-Jul-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Mon 06-Aug-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Thu 16-Aug-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Wed 22-Aug-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Fri 07-Sep-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Mon 17-Sep-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Wed 03-Oct-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
Tue 16-Oct-18 Excel Beginner Adelaide Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $330Excel Training Price
Duration: One Day
Excel Training ClockTime: 9am – 4pm (approx)
Classes capped at 10 people (average 5 people)
Excel Training TeamReference manuals provided
Training computer provided

Course Outline
PDFExcel Beginner

Upcoming Dates
Tue 29-May-18 Excel Beginner Perth Course confirmed to run. Limited number of seats available.
Tue 12-Jun-18 Excel Beginner Perth Course confirmed to run. Limited number of seats available.
Wed 27-Jun-18 Excel Beginner Perth Course has been scheduled to run but has not been confirmed.
Mon 09-Jul-18 Excel Beginner Perth Course has been scheduled to run but has not been confirmed.
Tue 24-Jul-18 Excel Beginner Perth Course has been scheduled to run but has not been confirmed.
Wed 01-Aug-18 Excel Beginner Perth Course has been scheduled to run but has not been confirmed.
Mon 06-Aug-18 Excel Beginner Perth Course has been scheduled to run but has not been confirmed.
Wed 22-Aug-18 Excel Beginner Perth Course has been scheduled to run but has not been confirmed.
Tue 28-Aug-18 Excel Beginner Perth Course has been scheduled to run but has not been confirmed.
Mon 17-Sep-18 Excel Beginner Perth Course has been scheduled to run but has not been confirmed.
Wed 03-Oct-18 Excel Beginner Perth Course has been scheduled to run but has not been confirmed.
Tue 16-Oct-18 Excel Beginner Perth Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $330Excel Training Price
Duration: One Day
Excel Training ClockTime: 9am – 4pm (approx)
Classes capped at 10 people (average 5 people)
Excel Training TeamReference manuals provided
Training computer provided

Course Outline
PDFExcel Beginner

Upcoming Dates
Fri 08-Jun-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Mon 18-Jun-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Tue 03-Jul-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Wed 11-Jul-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Wed 18-Jul-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Mon 30-Jul-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Fri 10-Aug-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Wed 15-Aug-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Tue 28-Aug-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Thu 06-Sep-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Wed 12-Sep-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
Mon 24-Sep-18 Excel Beginner Parramatta Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

BOOK NOW

Course Details
Price: $330Excel Training Price
Duration: One Day
Excel Training ClockTime: 9am – 4pm (approx)
Classes capped at 10 people (average 5 people)
Excel Training TeamReference manuals provided
Training computer provided

Course Outline
PDFExcel Beginner

Upcoming Dates
Mon 09-Jul-18 Excel Beginner Canberra Course has been scheduled to run but has not been confirmed.
Tue 10-Jul-18 Excel Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Wed 11-Jul-18 Excel Advanced Canberra Course has been scheduled to run but has not been confirmed.
Fri 20-Jul-18 Excel Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Mon 23-Jul-18 Excel Advanced Canberra Course has been scheduled to run but has not been confirmed.
Tue 24-Jul-18 Excel Beginner Canberra Course has been scheduled to run but has not been confirmed.
Wed 25-Jul-18 Excel Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Mon 30-Jul-18 Excel Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Mon 06-Aug-18 Excel Beginner Canberra Course has been scheduled to run but has not been confirmed.
Tue 07-Aug-18 Excel Intermediate Canberra Course has been scheduled to run but has not been confirmed.
Wed 08-Aug-18 Excel Advanced Canberra Course has been scheduled to run but has not been confirmed.
Thu 16-Aug-18 Excel Beginner Canberra Course has been scheduled to run but has not been confirmed.
  • Scheduled
  • Confirmed
  • Few seats
  • Class full

Course scheduled to run. Taking enrolments.
Course will run. Taking further enrolments.
Course will run. Limited seats available.
Sold out. Try another date.

Are you looking to understand the basics of Excel?
Excel Training Student

Learn how to analyse, share and manage your day-to-day data using Excel spreadsheets on our One-day course. Our Excel Training Beginner course, includes creating and formatting spreadsheets and charts, learning to sort and filter and gaining an understanding of Excel’s advanced formulas and functions. You can build on this course with the Intermediate and Advanced levels when it suits.

What do I need to know to attend?

There is no requirement for the Basic course. The course is suitable for people who have never worked with Excel or have just had very limited exposure to it. We will walk you through, right from the start.

Excel Training List

Learning Outcomes – Excel Basics

On completion of this course you should be able to:

      • navigate your way around Microsoft Excel
      • create and work with a new workbook
      • open and navigate within workbooks and worksheets
      • understand and work with ranges in a worksheet
      • understand, create and work with formulas and functions used to perform calculations
      • understand points to consider to avoid problems in your worksheets
    • use font formatting techniques to greatly enhance the look of a worksheet
    • alter the layout of a worksheet
    • sort and filter data in a worksheet
    • print your workbook data
    • create effective charts in Microsoft Excel
    • obtain help for Excel whenever you need it
Course Details
  • Excel Training Clock 2Courses will run from 9am – 4pm (approx.)
  • Excel Training NetworkClasses capped at 10 people (average 5 people)
  • Excel Training PriceListExcel Beginner course costs $330
  • Excel Training BooksReference Manuals provided
  • Excel Training MapsCentral city locations
Each Student receives
  • Excel Training WorkbooksReference Workbooks
  • Excel Training Certificatee-Certificate of attendance
  • Excel Training Customer ServiceComplimentary post course training e-support
  • Excel Training ExpertTrained by a Microsoft Certified Expert
  • Excel Training RefundSatisfaction guarantee or repeat FREE within 8mths
Related courses
InfoExcel Course Intermediate
InfoExcel Course Advanced
InfoExcel Macros/VBA
Course Content
Excel TrainingBasics
  • Starting Excel from the Desktop
  • Understanding the Excel Start Screen
  • The Excel Workbook Screen
  • How Excel Works
  • Using the Ribbon
  • Showing and Collapsing the Ribbon
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Using Shortcut Menus
  • Understanding Dialog Boxes
  • Launching Dialog Boxes
  • Understanding the Quick Access Toolbar
  • Adding Commands to the QAT
  • Understanding the Status Bar
  • Exiting Safely From Excel

Excel TrainingWorkbooks

  • Understanding Workbooks
  • Using the Blank Workbook Template
  • Typing Text
  • Typing Numbers
  • Typing Dates
  • Typing Formulas
  • Easy Formulas
  • Saving a New Workbook
  • Checking the Spelling
  • Making Basic Changes
  • Safely Closing a Workbook

Excel TrainingNavigating

  • Opening an Existing Workbook
  • Navigating a Workbook
  • Navigating Using the Keyboard
  • Using Go To
  • Recent Files and Folders
  • Understanding Data Editing
  • Overwriting Cell Contents
  • Editing Longer Cells
  • Editing Formulas
  • Clearing Cells
  • Deleting Data
  • Using Undo and Redo

Excel TrainingRanges

  • Selecting Contiguous Ranges
  • Selecting Non-Contiguous Ranges
  • Selecting Larger Ranges
  • Selecting Rows
  • Selecting Columns
  • Understanding Copying in Excel
  • Using Fill for Quick Copying
  • Copying from One Cell to Another
  • Copying from One Cell to A Range
  • Copying from One Range to Another
  • Understanding Filling
  • Filling a Series
  • Filling a Growth Series
  • Extracting with Flash Fill
  • Understanding Moving in Excel
  • Moving Cells and Ranges

Excel TrainingFormulas/Functions

  • Understanding Formulas
  • Creating Formulas That Add
  • Creating Formulas That Subtract
  • Formulas That Multiply and Divide
  • Understanding Functions
  • Using The SUM Function
  • Summing Non-Contiguous Ranges
  • Calculating An Average
  • Finding a Maximum Value
  • Finding a Minimum Value
  • Creating More Complex Formulas
  • What If Formulas
  • Absolute Versus Relative Referencing
  • Relative Formulas
  • Problems with Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • Common Error Messages

Excel TrainingFormatting

  • Understanding Font Formatting
  • Working with Live Preview
  • Changing Fonts
  • Changing Font Size
  • Growing and Shrinking Fonts
  • Making Cells Bold
  • Italicising Text
  • Underlining Text
  • Changing Font Colours
  • Changing Background Colours
  • Using the Format Painter
  • Understanding Cell Alignment
  • Horizontal Cell Alignment
  • Vertical Cell Alignment
  • Indenting Cells
  • Understanding Number Formatting
  • Applying General Formatting
  • Formatting for Money
  • Formatting Percentages
  • Formatting as Fractions
  • Formatting as Dates
  • Using the Thousands Separator
  • Increasing and Decreasing Decimals

Excel TrainingLayout

  • Approximating Column Widths
  • Setting Precise Columns Widths
  • Setting the Default Column Width
  • Approximating Row Height
  • Setting Precise Row Heights
  • Understanding Worksheets
  • Changing the Worksheet View
  • Worksheet Zooming
  • Viewing the Formula Bar
  • Viewing Worksheet Gridlines
  • Inserting Cells into a Worksheet
  • Deleting Cells from a Worksheet
  • Inserting Columns into a Worksheet
  • Inserting Rows into a Worksheet
  • Deleting Rows and Columns
  • More than One Worksheet
  • Worksheet Wisdom

Excel TrainingSorting/Filtering

  • Understanding Lists
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Sorting on Multiple Columns
  • Understanding Filtering
  • Applying and Using A Filter
  • Clearing a Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards

Excel TrainingPrinting

  • Understanding Printing
  • Previewing Before You Print
  • Selecting a Printer
  • Printing a Range
  • Printing an Entire Workbook
  • Specifying the Number of Copies
  • The Print Options

Excel TrainingCharts

  • Understanding the Charting Process
  • Choosing the Right Chart
  • Using a Recommended Chart
  • Creating a New Chart From Scratch
  • Working with an Embedded Chart
  • Resizing a Chart
  • Repositioning a Chart
  • Printing an Embedded Chart
  • Creating a Chart Sheet
  • Changing the Chart Type
  • Changing the Chart Layout
  • Changing the Chart Style
  • Printing a Chart Sheet
  • Embedding a Chart into a Worksheet
  • Deleting a Chart

Excel TrainingHelp

  • Understanding How Help Works
  • Accessing the Help Window
  • Navigating the Help Window
  • Using the Office Website for Help
  • Using Google to Get Help
  • Printing a Help Topic
  • Other Sources of Assistance

Excel TrainingGuidelines

  • Nothing Beats Good Planning
  • Organisation and Design
  • Spot On Formulas
  • Documented and Easy to Use
  • The Appropriateness of Spreadsheets

Excel Training Reviews
Average rating:  
 6052 reviews

Very happy with the course. Raj was able to provide me with the solution for an issue I was having. Course run at a good pace and if there was an issue Raj would not have any issues going over the problems. - Analysis & Dashboards Parramatta

Page 1 of 6052:
«
 
 
1
2
3
 
»
 
Download Course Content Here