This course is intended to help proficient users reach new heights with the advanced features of Excel, Microsoft’s powerful and easy-to-use spreadsheet program.
The course covers structured references, focusing on cell-based versus table-based references and table elements. You will learn to create and manage named ranges for more dynamic spreadsheets. The session also includes dynamic array functions like UNIQUE, SORT, and XLOOKUP. Pivot Tables will be emphasised, with guidance on creating, customising, and extracting insights from data sets. Finally, the training introduces advanced functions, including Date, Information, Math, Statistical, and Text functions, to handle various data analysis tasks proficiently.
By the end of the course, you'll have acquired the skills and knowledge necessary to work confidently with Excel at an advanced level.
This course builds on what was learned in Microsoft Excel - Beginner and Intermediate. After completing this course, you may be interested in Excel Expert or one of our Excel Specialist courses.
Note: This course introduces functions that require a Microsoft Office 365 version of Excel. These tools have no equivalent in prior Excel versions.
Nexacu Public Schedule
Nexacu is part of the Lumify Group, offering you the largest public schedule of end user applications and professional development training in Australia, New Zealand, and the Philippines. You can now access the schedule of courses and book, by clicking on the button below.
