Using Names
A single cell or a range of cells can be named to simplify references in formulas and functions.
You’ll learn how to create Names, use Names in formulas and functions and Manage Names.
MON - FRI
9.00AM - 17.00PM
04 TRAINING
0487 24 64 64
Take your Excel skills to the next level with our Excel Advanced training course! This course is perfect for those looking to dive deeper into the power and versatility of Excel.
You’ll explore advanced referencing techniques, including named ranges and structured tables, that streamline your workflow and make your data more dynamic.
We’ll guide you through the process of analyzing data with sophisticated functions and powerful PivotTables, helping you uncover meaningful insights with ease.
Whether you’re managing complex datasets or optimizing reports, this course equips you with the tools and expertise to excel at a truly advanced level.
Microsoft Excel training course in Melbourne and across Australia. We can come to you for Face-to-face Excel training or you can join us online for Live online Excel training courses.
Using Names
A single cell or a range of cells can be named to simplify references in formulas and functions.
You’ll learn how to create Names, use Names in formulas and functions and Manage Names.
Using Tables
The fancy formatting options for tables are just the beginning, what makes tables excellent to work with, it the way they interact with Formulas, Functions, PivotTables, Data Validation and a host of other features.
Advanced Functions
Understanding Excel’s Functions is an import aspect of using Excel to it’s full potential. The advanced functions covered in this course aims to help you understand function structure and requirements which can be applied to any function.
Advanced Conditional Formatting
Conditional formats are a valuable method for error checking of data entries and highlighting discrepancies between numbers.
For example, when a cell entry exceeds a specified value or is outside a particular range, the user can be alerted by seeing the value displayed in a different colour.
Data Managment
Learn about Advanced techniques for Sorting, Filtering and Summarising Data with the SUBTOTAL function.
PivotTables and PivotCharts
A PivotTable is an interactive table that quickly summarises, or cross-tabulates, large amounts of data from lists or tables. Field headers can be dragged to various regions within the PivotTable structure with complete flexibility to create a report.
Once a PivotTable is populated with data it can be rearranged, charted, formatted, filtered, calculated, summarised and broken up into individual pages.
Macros (VBA for Excel)
When the same actions or tasks are repeatedly performed in documents, it might be time to create a macro. A macro is a recording of each command and action performed to complete a task. Then, whenever a task needs to be carried out in a document, the macro could be run instead.
Previous experience using Microsoft Excel at an Intermediate level is an essential prerequisite for this course.
Instructor - led Training
Menual & Files
Unlimited Free Support
Book a private session for 1 to 12 of your employees. Courses can be customised to suit your learning needs.
Join a public course session conducted LIVE ONLINE via Microsoft Teams.
$395
Using Names
A single cell or a range of cells can be named to simplify references in formulas and functions.
You’ll learn how to create Names, use Names in formulas and functions and Manage Names.
Using Tables
The fancy formatting options for tables are just the beginning, what makes tables excellent to work with, it the way they interact with Formulas, Functions, PivotTables, Data Validation and a host of other features.
Advanced Functions
Understanding Excel’s Functions is an import aspect of using Excel to it’s full potential. The advanced functions covered in this course aims to help you understand function structure and requirements which can be applied to any function.
Advanced Conditional Formatting
Conditional formats are a valuable method for error checking of data entries and highlighting discrepancies between numbers.
For example, when a cell entry exceeds a specified value or is outside a particular range, the user can be alerted by seeing the value displayed in a different colour.
Data Managment
Learn about Advanced techniques for Sorting, Filtering and Summarising Data with the SUBTOTAL function.
PivotTables and PivotCharts
A PivotTable is an interactive table that quickly summarises, or cross-tabulates, large amounts of data from lists or tables. Field headers can be dragged to various regions within the PivotTable structure with complete flexibility to create a report.
Once a PivotTable is populated with data it can be rearranged, charted, formatted, filtered, calculated, summarised and broken up into individual pages.
Macros (VBA for Excel)
When the same actions or tasks are repeatedly performed in documents, it might be time to create a macro. A macro is a recording of each command and action performed to complete a task. Then, whenever a task needs to be carried out in a document, the macro could be run instead.
Previous experience using Microsoft Excel at an Intermediate level is an essential prerequisite for this course.
Instructor - led Training
Menual & Files
Unlimited Free Support
I had the pleasure of being trained by Anton twice now for work. Always very informative and an enjoyable learning experience. His knowledge and training style definitely works for both individual and group sessions. Highly recommended!
Anton took our business through staff training with a lot of back end knowledge, patience and great communication.
We felt well supported and enjoyed our experience with Blank Page. We would highly recommend Anton for further training. Regards MA.
I had the pleasure of being trained by Anton twice now for work. Always very informative and an enjoyable learning experience. His knowledge and training style definitely works for both individual and group sessions. Highly recommended!
Anton is absolutely delightful; a great teacher and a wonderful tutor. I am a professional educator with well over 30 years experience and I can unconditionally recommend Anton and Blank Page in terms of professional instruction based on an in-depth understanding of the subject matter and great sensitivity to learner needs; personal engagement and great ability in teaching this ‘old dog’ plenty of new tricks! And I consider myself to be tech-challenged and yet I came away with confidence and as importantly competence I did not think I’d attain! Two thumbs up and Thank You Blank Page and Anton.
Anton took our business through staff training with a lot of back end knowledge, patience and great communication.
We felt well supported and enjoyed our experience with Blank Page. We would highly recommend Anton for further training. Regards MA.
Reviews
There are no reviews yet.