Training

Reserve your place
Join us for one of our Excel training sessions. You can choose the course to suit your level, or, if booking for a group, contact us to discuss tailoring the course to your requirements. If in doubt, give us a call and we can discuss what would be suitable.
SharePoint training also available. Learn how to move from Excel to SharePoint Lists for more effective validation and permissions. Discover how SharePoint provides a good solution for assigning tasks, and automating approval processes.
Training can be arranged by contacting us by phone or email, as detailed below, or by completing the form on the Contact page.
e : info@montalba.com.au
t : Australia: +61 (0)493 594 071
Course Overview:
Below are highlights of the areas to be covered in each course
Excel Intro
Navigation, Customisation, Editing and Sorting.
Learn your way around Excel, customising the command ribbon and quick menu, and understand some of the Options available.
Basic data manipulation and shortcuts to help speed up some regular repetitive tasks. 
Excel Intermediate
Excel Tables, Ranges and Referencing Filtering Conditional formatting Intro to Formulae and Functions Maths functions (e.g. SUM, SUMIF, MAX) Text functions (e.g. LEN, LEFT, RIGHT, FIND) Date functions (e.g. YEAR, DATEVALUE, EOMONTH) XLOOKUP, VLOOKUP, HLOOKUP functions Nested/Embedded Functions 
Excel Advanced
Overview of Charts, Pivot Tables Exporting to Word, Powerpoint and other applications Page Layout 
From Excel to SharePoint Lists
What is it, and how it can fit into your organisation Sites, Lists and Libraries: demo creating a site with basic Lists and Document Libraries Excel versus SharePoint Lists