Course Details
Price: $825
Duration: One Day
Time: 9am – 4pm (approx)
Class Size: 10 students (max)
Training computer provided
Course Outline
PDFExcel Beginner
Fri 01-Mar-19 | Excel Beginner | Sydney | ![]() |
Tue 12-Mar-19 | Excel Beginner | Sydney | ![]() |
Wed 27-Mar-19 | Excel Beginner | Sydney | ![]() |
Fri 05-Apr-19 | Excel Beginner | Sydney | ![]() |
Mon 15-Apr-19 | Excel Beginner | Sydney | ![]() |
Mon 29-Apr-19 | Excel Beginner | Sydney | ![]() |
Thu 09-May-19 | Excel Beginner | Sydney | ![]() |
Wed 22-May-19 | Excel Beginner | Sydney | ![]() |
Mon 03-Jun-19 | Excel Beginner | Sydney | ![]() |
Tue 11-Jun-19 | Excel Beginner | Sydney | ![]() |
Tue 25-Jun-19 | Excel Beginner | Sydney | ![]() |
Tue 02-Jul-19 | Excel Beginner | Sydney | ![]() |
Wed 10-Jul-19 | Excel Beginner | Sydney | ![]() |
Thu 25-Jul-19 | Excel Beginner | Sydney | ![]() |
Fri 02-Aug-19 | Excel Beginner | Sydney | ![]() |
Mon 26-Aug-19 | Excel Beginner | Sydney | ![]() |
Tue 03-Sep-19 | Excel Beginner | Sydney | ![]() |
Wed 11-Sep-19 | Excel Beginner | Sydney | ![]() |
Thu 26-Sep-19 | Excel Beginner | Sydney | ![]() |
Fri 04-Oct-19 | Excel Beginner | Sydney | ![]() |
Mon 14-Oct-19 | Excel Beginner | Sydney | ![]() |
Tue 22-Oct-19 | Excel Beginner | Sydney | ![]() |
Wed 30-Oct-19 | Excel Beginner | Sydney | ![]() |
Thu 14-Nov-19 | Excel Beginner | Sydney | ![]() |
Fri 22-Nov-19 | Excel Beginner | Sydney | ![]() |
Mon 02-Dec-19 | Excel Beginner | Sydney | ![]() |
Tue 10-Dec-19 | Excel Beginner | Sydney | ![]() |
Wed 18-Dec-19 | Excel Beginner | Sydney | ![]() |
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.
Course Details
Price: $825
Duration: One Day
Time: 9am – 4pm (approx)
Class Size: 10 students (max)
Reference manuals provided
Training computer provided
Course Outline
PDFExcel Beginner
Tue 26-Feb-19 | Excel Beginner | Melbourne | ![]() |
Fri 01-Mar-19 | Excel Beginner | Melbourne | ![]() |
Tue 12-Mar-19 | Excel Beginner | Melbourne | ![]() |
Tue 19-Mar-19 | Excel Beginner | Melbourne | ![]() |
Wed 27-Mar-19 | Excel Beginner | Melbourne | ![]() |
Mon 01-Apr-19 | Excel Beginner | Melbourne | ![]() |
Tue 09-Apr-19 | Excel Beginner | Melbourne | ![]() |
Wed 17-Apr-19 | Excel Beginner | Melbourne | ![]() |
Mon 29-Apr-19 | Excel Beginner | Melbourne | ![]() |
Wed 08-May-19 | Excel Beginner | Melbourne | ![]() |
Tue 21-May-19 | Excel Beginner | Melbourne | ![]() |
Wed 29-May-19 | Excel Beginner | Melbourne | ![]() |
Mon 03-Jun-19 | Excel Beginner | Melbourne | ![]() |
Tue 18-Jun-19 | Excel Beginner | Melbourne | ![]() |
Wed 19-Jun-19 | Excel Beginner | Melbourne | ![]() |
Mon 24-Jun-19 | Excel Beginner | Melbourne | ![]() |
Tue 02-Jul-19 | Excel Beginner | Melbourne | ![]() |
Wed 10-Jul-19 | Excel Beginner | Melbourne | ![]() |
Thu 25-Jul-19 | Excel Beginner | Melbourne | ![]() |
Fri 02-Aug-19 | Excel Beginner | Melbourne | ![]() |
Mon 26-Aug-19 | Excel Beginner | Melbourne | ![]() |
Tue 03-Sep-19 | Excel Beginner | Melbourne | ![]() |
Wed 11-Sep-19 | Excel Beginner | Melbourne | ![]() |
Thu 26-Sep-19 | Excel Beginner | Melbourne | ![]() |
Fri 04-Oct-19 | Excel Beginner | Melbourne | ![]() |
Mon 14-Oct-19 | Excel Beginner | Melbourne | ![]() |
Tue 22-Oct-19 | Excel Beginner | Melbourne | ![]() |
Wed 30-Oct-19 | Excel Beginner | Melbourne | ![]() |
Thu 14-Nov-19 | Excel Beginner | Melbourne | ![]() |
Fri 22-Nov-19 | Excel Beginner | Melbourne | ![]() |
Mon 02-Dec-19 | Excel Beginner | Melbourne | ![]() |
Tue 10-Dec-19 | Excel Beginner | Melbourne | ![]() |
Wed 18-Dec-19 | Excel Beginner | Melbourne | ![]() |
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.
Course Details
Price: $825
Duration: One Day
Time: 9am – 4pm (approx)
Class Size: 10 students (max)
Reference manuals provided
Training computer provided
Course Outline
PDFExcel Beginner
Tue 26-Feb-19 | Excel Beginner | Brisbane | ![]() |
Wed 06-Mar-19 | Excel Beginner | Brisbane | ![]() |
Mon 11-Mar-19 | Excel Beginner | Brisbane | ![]() |
Tue 19-Mar-19 | Excel Beginner | Brisbane | ![]() |
Wed 27-Mar-19 | Excel Beginner | Brisbane | ![]() |
Mon 01-Apr-19 | Excel Beginner | Brisbane | ![]() |
Tue 09-Apr-19 | Excel Beginner | Brisbane | ![]() |
Wed 17-Apr-19 | Excel Beginner | Brisbane | ![]() |
Tue 30-Apr-19 | Excel Beginner | Brisbane | ![]() |
Wed 08-May-19 | Excel Beginner | Brisbane | ![]() |
Tue 21-May-19 | Excel Beginner | Brisbane | ![]() |
Wed 29-May-19 | Excel Beginner | Brisbane | ![]() |
Mon 03-Jun-19 | Excel Beginner | Brisbane | ![]() |
Wed 19-Jun-19 | Excel Beginner | Brisbane | ![]() |
Mon 24-Jun-19 | Excel Beginner | Brisbane | ![]() |
Tue 02-Jul-19 | Excel Beginner | Brisbane | ![]() |
Wed 10-Jul-19 | Excel Beginner | Brisbane | ![]() |
Thu 25-Jul-19 | Excel Beginner | Brisbane | ![]() |
Fri 02-Aug-19 | Excel Beginner | Brisbane | ![]() |
Mon 26-Aug-19 | Excel Beginner | Brisbane | ![]() |
Tue 03-Sep-19 | Excel Beginner | Brisbane | ![]() |
Wed 11-Sep-19 | Excel Beginner | Brisbane | ![]() |
Thu 26-Sep-19 | Excel Beginner | Brisbane | ![]() |
Fri 04-Oct-19 | Excel Beginner | Brisbane | ![]() |
Mon 14-Oct-19 | Excel Beginner | Brisbane | ![]() |
Tue 22-Oct-19 | Excel Beginner | Brisbane | ![]() |
Wed 30-Oct-19 | Excel Beginner | Brisbane | ![]() |
Thu 14-Nov-19 | Excel Beginner | Brisbane | ![]() |
Fri 22-Nov-19 | Excel Beginner | Brisbane | ![]() |
Mon 02-Dec-19 | Excel Beginner | Brisbane | ![]() |
Tue 10-Dec-19 | Excel Beginner | Brisbane | ![]() |
Wed 18-Dec-19 | Excel Beginner | Brisbane | ![]() |
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.
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.
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.
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
- Courses will run from 9am – 4pm (approx.)
- Classes limited to approx 10 people
- Excel Beginner Course costs $330
- Reference Manuals provided
- Central city locations
- Excel Cheat Sheet
- Reference Workbooks
- e-Certificate of attendance
- Complimentary post course training e-support
- Trained by a Microsoft Certified Excel Expert
- Satisfaction guarantee or repeat FREE within 8mths
InfoExcel Course Advanced
InfoExcel VBA Course
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Understanding Printing
- Previewing Before You Print
- Selecting a Printer
- Printing a Range
- Printing an Entire Workbook
- Specifying the Number of Copies
- The Print Options
- 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
- 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
- Nothing Beats Good Planning
- Organisation and Design
- Spot On Formulas
- Documented and Easy to Use
- The Appropriateness of Spreadsheets
Raj was an exceptional trainer. Her fantastic explanation and guidance of the source material was core to optimising the retaining of knowledge among the group. - Excel Intermediate Sydney