Intermediate Excel Training Sydney
In-house face to face and Virtual Group Training Built Around Your Team’s Needs
Intermediate Excel Training
Learn the Excel skills that make a difference in your daily work. Trainers Direct offers hands-on Microsoft Excel training in Sydney or online anywhere in Australia. Our Intermediate level workshops teach you how to analyse data with Pivot Tables and apply logical functions to data and much more, apply your skills to real-world tasks. Additionally, we offer short virtual micro learning courses focused on key topic areas.
Duration
Our Intermediate Excel workshop can be run as half day or full day program
Prerequisites
Users should be able to demonstrate knowledge of all topics on our basic Excel course.
Quick Glance
Our Excel Intermediate course equips teams with the skills to analyse data and understand more advanced functions. Participants will learn how to create pivot tables, use IF functions and link data using 3D formulae through practical, hands-on exercises.
Excel Intermediate Training
Our Intermediate training on Excel is perfect for users eager to take their skills to the next level. Learn pivot tables, IF functions, charting and linking worksheets.
Recap
- An opportunity to recap on
formulas, quick tips and
shortcuts.
Working with Multiple worksheets
- Copy and paste across sheets
- Copy an entire sheet
- Calculating across worksheets
- Grouping sheets
Range names and Tables
- Defining range names
- Using names
- Navigating with names
- Creating Tables for Dynamic Data Ranges
Functions and formulas
- The COUNTIF function
- The SUMIF function
- The IF function
- Date functions & sequences
Conditional formatting
- Conditional formatting from cell value
- Conditional formatting from a formula
Database Features
- Format as a Table
- Freeze Panes
- Sorting and filtering
- Sorting lists
- Sorting by colour
- Filtering and searching
- Subtotalling a list
Protection
- Workbook protection
- Protecting cells
- Protecting structure
Charts
- Selecting data to chart
- Different chart types
- Formatting charts and layouts
Pivot Tables
- Create a pivot table report
- Applying filters and slicers
- Adding fields and modifying field settings
- Refreshing and redefining data
- Formatting a PivotTable
- Creating a PivotChart
Explore the next level Advanced Excel training for macros, lookups and automation – Advance your skills with data analysis, text cleaning, and advanced functions to work smarter with spreadsheets. We also offer short Excel masterclasses for busy professionals and Corporate Excel training tailored for teams
FAQS
Do you offer professional onsite Excel training for corporate teams?
Yes, we provide tailored in-house Excel training for corporate teams, designed to meet your specific skill levels, goals, and industry needs. Training is available onsite in Sydney, Brisbane and all major states or live online.
Can I get Tailored Excel training packages for my business' s specific needs?
Absolutely. We offer customised Excel training packages designed around your business goals, industry-specific requirements, and team skill levels whether it’s beginner focused on expert-level.
Do you deliver advanced Excel training courses directly at office locations?
Yes, we deliver advanced Excel training courses onsite at office locations in Sydney, Brisbane, and surrounding areas. We cater to all levels from beginner to advanced.
Can you offer flexible scheduling for Excel training workshops at work?
Yes, we offer flexible scheduling to fit around your team’s availability, including half-day, full-day, or multi-session Excel workshops during or sometimes outside regular work hours.
Can you provide Excel training that caters to different skill levels within one program?
Yes, our Excel training is designed to accommodate mixed skill levels. We tailor the content to ensure all participants—from beginners to advanced users—gain value from the program. Alternatively, we can break a day into several sessions aimed at different user cohorts.
Can you deliver onsite Excel training workshops for large enterprises in Sydney?
Yes, we offer onsite Excel training workshops for large enterprises in Sydney and other major states. Our sessions are tailored to suit all skill levels and can be delivered at your office or chosen venue.
Onsite Training
Roving Trainers
Virtual Training
Training Roll-outs
We're Here To Help!
Call Us
02 9454 7702
Hours
M-F: 9am - 5pm
S-S: Closed