Microsoft Excel - Advanced

This one-day course is aimed at experienced Excel users who need to create and manipulate more complex models using the advanced features of Excel. The course will cover the following:

• Functions - review basic excel functions; statistical functions; time/date functions; text functions; nesting functions; conditional formatting with functions
• Multiple sheets/files - review multiple sheets; grouping and linking sheets; workbook features
• Consolidation - building a consolidation; creating consolidation links
• Data validation and auditing - limiting entries into a cell; creating a dropdown list; data validation and functions; circling invalid data; tracing precedent and dependent cells
• Analysing data - creating data tables for what-if analysis; building a scenario; multiple scenarios; summary scenarios; using goal seel and solver
• Spreadsheet database features - advanced filtering; database functions; look-up functions; pivot tables - creating and updating the table, changing the table structure, creating charts from the data; grouping options; pivot table options; on-off subtotals; calculated items; showing/hiding fields
• Advanced charts - review of creating a chart; advanced chart options; advanced formatting; adding trend lines; user-defined charts
• Customising the work area - creating a template; using a template; styles; custom toolbars
• Sharing workbooks - tracking changes options; accepting and rejecting changes; merging workbooks
• Excel macros - macro fundamentals; creating a macro; running a macro; assigning a macro to a button/menu

In order to ensure that the tutor has an overview of the prior Excel experience and knowledge of the course participants, and to ensure that your current Excel proficiency is adequate for you to undertake and benefit from this course, please download and complete this questionnaire, and return it by e-mail to info@trainerslearningskillnet.com, by fax to 045-881192 or by post to Trainers' Learning Skillnet, Unit 4 Sycamore House, Millennium Business Park, Naas, Co. Kildare, to arrive no later than one week prior to commencement of your course. Please note that you may be recommended to undertake a more elementary course rather than participating on this Advanced course at this time.

Upon completion of this one-day course, you may decide to undertake the Microsoft Office Specialist examination in this subject area. Some additional individual preparation for this examination may be required. Please speak to your tutor if you are interested in pursuing this accreditation. Neither the additional preparation nor the examination itself are included in the fee for this course (arrangements to be made directly with training provider/assessment centre, and fee(s) to be paid directly to training provider/assessment centre).