The Excel Intermediate course is suited to students who have either attended a basic course in Excel or spreadsheet training, or those who have been working experience with Excel and have a basic understanding of the features of Excel. Students attending this course are working with large amounts of data and are required to manipulate it to quickly locate information. They are looking for techniques to speed up their processes to manage and manipulate the lists of data they are required to work with. They are familiar with basic formulas and want to implement them more effectively.
As a result of this course students will be able to manage multiple workbooks including construction of formulas across worksheets. They will be learn how to utilise Excels advanced formatting features, manage large amounts of data and work with the sorting, filtering, outlining and subtotal tools. Competency will be gained in advanced charting, auditing techniques and templates.
Microsoft Excel Beginner 2007 or equivalent