CoursesExcel OptimisingLength: 1 Day Cost: $410 + GST Version: Excel = Scheduled class  = Guaranteed to run  = Fully bookedClick on the dates to book online
Can't find a class in your area? Contact our sales team and request a class date. About this CourseThis course is designed for the advanced Excel user and is focused on two areas. One is to use Excel itself more efficiently. The other is to improve the actual performance of workbooks Our aim is to improve and extend on the skills you already have as well as to provide you with a basis to re-evaluate existing projects. We will introduce a significant timesaving feature, which is the ability to add some basic automation to your work. It is important that you use your new skills as soon as possible on completion of this training course. We encourage you to take your own notes and to review this Course Guide once you are back at your workplace. PrerequisitesWe recommend that students: First complete our Essential Skills and Timesaving courses, OR have: A thorough understanding of formulae. A thorough understanding of using Excel’s common functions such as Average, Maximum, Count, IF, and so forth. The knowledge to create and use range names. A high level of overall knowledge of, and comfort with, Excel At Course CompletionWe work with some of the more advanced features of tools and methods covered in the previous Excel courses. We discuss ways to optimise Excel’s performance when working with large datasets and use the Record Macro functionality to automate repetitive tasks. Course Outline
|
|
||||||||
