Flexible Excel Training Live Online and Onsite
Trainers Direct offers Live online short courses and onsite face to face Excel training courses in Melbourne, designed for businesses who need flexible and cost effective staff training in the workplace. Our unique Pick & Mix workshops allow you to choose your own content and structure your training day into several sessions catering for different users or book onto one of our classroom online workshops.
Combine Topics
Choose from a huge list of subjects combining intro, intermediate and advanced course levels
Flexible Sessions
Break the day into several sessions to cater for different staff members and abilities
Free Advice and Support
Benefit from a free training needs analysis and lifetime membership of our support forum
Live 5* Online Reviews Speak Volumes
Trainers Direct
Level 1 - Introduction
Excel Courses Melbourne – 1 Day Intro Level
Trainers Direct beginner Excel courses are delivered by certified Excel Experts. This foundation level course is aimed at users who may be self taught with a basic knowledge of spreadsheets. Users with limited Excel skills who have little or no experience of Excel formulae and functions should attend this course prior to enrolling on the intermediate level. Customers may request an intermediate level course which can be customised to include
Course Overview
This course is ideal for beginners who want to learn how to produce formatted spreadsheets and perform calculations.
Course prerequisites
Participants will need to be familiar with Microsoft Windows and basic Windows techniques such as opening, closing and saving files.
What you will learn
- Create, modify and format a spreadsheet
- Use basic formulas and functions
- Customise the print settings and print
Course Topics
- Overview
- Keyboard and mouse shortcuts
- Entering data into your spreadsheet
- Data entry ranges
- Formatting the worksheet
- Number and date formats
- Fonts, colours, borders, sizes
- Adjust column widths
- Indenting
- Centre aligning
- Merging and centring
- Text Wrap
- Format Painter
- Formulas
- The Sum function
- AutoSum
- AutoFill a formula
- Basic formulas
- BODMAS (working with brackets)
- Editing formulae
- An introduction to relative and absolute references
- Functions
- The AVERAGE function
- The MAX function
- The MIN function
- The COUNT function
- Working with columns and rows
- Inserting columns/rows
- Deleting columns/rows
- Hiding columns/rows
- AutoFill
- Printing and page setup
- Print preview
- Margins, orientation, scaling
- Page layout
- Page break preview
- Headers and footers
- Repeating Print titles on all pages
- Setting a print area
- Save as PDF
Our Intermediate Excel Training Course may be more appropriate for you.
Level 2 - Intermediate
Excel Courses Melbourne – Intermediate Level – 1 Day
Users attending the intermediate Excel course should have a good working knowledge of how to set up an Excel spreadsheet using formatting and basic formulas. Users should be able to add, subtract, multiply and divide as well as being able to access page setup options and AutoSum.
Course Overview
This course is suitable for people who want to use Excel to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, link sheets, produce basic pivot table reports and conditionally format cells.
Course prerequisites
Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Introduction course.
What you will learn
- How to use a range of common worksheet functions
- Manage a database list by filtering and subtotalling
- Use Conditional Formatting to change cell appearance
- Create, modify and format a range of charts
- Produce linked worksheets and 3D formulae
- Create basic pivot table reports
Course Topics Summary
- Multiple worksheets
- Copy and paste
- Copy an entire sheet
- Calculating across worksheets
- Copying formulas
- Renaming sheets
- Inserting/deleting a sheet
- Grouping sheets
- Charts
- Selecting data to chart
- Creating a chart
- Changing the chart type
- Switching columns/rows
- Adding titles
- Reposition the legend
- Using chart layouts
- Printing a chart
- Plotting a secondary axis
-
Functions and formulas
- Absolute cell referencing
- The COUNTIF function
- The SUMIF function
- The IF function
- Working with date and time
- Date functions – TODAY and NOW
- NETWORKDAYS function
- AutoFill date sequences
- Conditional formatting
- Conditional formatting from cell value
- Conditional formatting from a formula
- Editing conditional formatting rules
- Adding sparklines
- Sorting and filtering
- Freeze Panes
- Sorting lists
- Sorting by colour
- Filtering criteria
- Searching for criteria
- Subtotalling a list
- Creating a PivotTable Report
- Create a PivotTable
- Rearranging data
- Applying filters and slicers
- Adding a timeline filter
- Adding fields
- Modify field settings
- Refreshing data
- Formatting a PivotTable
- PivotCharts
- Creating a PivotChart
- Filtering a PivotChart
- Protecting your data
- Workbook protection
- Protecting cells
- Protecting structure
- Range names
- Defining range names
- Using names in formulas
- Navigating with names
- Using named constants
- Documenting range names
Looking to cover Lookup functions and macros? Our Advanced Excel Training Course may be more appropriate for you.
Level 3 - Advanced
Excel Courses Melbourne – Advanced Level – 1 Day
Users attending the Excel advanced training course should be conversant with all topics at both intro and intermediate level.
ADVANCED EXCEL COURSE CONTENT 1 DAY
Course overview
This course covers many advanced features of Excel including lookup and advanced functions, What-if analysis, and how to automate processes and be more productive.
Course prerequisites
Participants will need to have attended or be familiar with the topics covered in the Microsoft Excel Intermediate course.
Course Topics Summary
-
Functions
- IF Function revision
- The AND function
- The OR function
- Nested IF function
- The VLOOKUP function
- The HLOOKUP function
- Transposing data
- Concatenating functions
- INDEX and MATCH functions
Data Validation
- Limiting cell values
- Creating drop-down cell lists
- Validation error messages
What-if analysis tools
- Using goal seek
- Scenario manager
Importing data
- Importing CSV files
- Text import wizard
- Converting text to columns
- Formatting imported data and troubleshooting
Workbook linking
- Workbook linking
- Dealing with broken links
- Data consolidation
Exporting data
- Saving as a different file type
- Exporting to Word
- Pasting data with a link
- Copying a graph with a link
Macros
- Recording a Macro
- Editing a Macro
- Relative/Absolute Recording
- Custom Macro buttons
- Customising the ribbon
- Editing a line of code
- Deleting a Macro
We also offer Excel VBA training for expert level Excel users and tailored Microsoft Excel macros training. Get in touch for the best advanced Excel Training in Melbourne.
Bespoke
Users who require a blend of topics from different levels may choose to combine topics to create a tailor made Excel course. Ask about our free online training needs analysis for a truly relevant and hands on learning experience. We can run any Excel course in Sydney and Melbourne and across most Australian states. All training courses are flexible and timings can be changed to suit any busy staff schedule.
Excel Versions
We offer the following Excel Training Course versions:-
Excel 2007 Training
2010 Training
2013 Training
2016 Training
FOLLOW US