Welcome         Tel:  Fax:   0844 33 505 87 0207 806 8355       Microsoft Excel Intermediate (all versions) - providing you a good foundation in using basic formulas and features of Excel Customer Rating:  read customer comments Duration: 1 Day Cost: £140 + VAT Discounts: Discounts available for group bookings - call 0844 33 505 87 for information Date Availability: Dates Location Status Overview This one day course is designed for people who have created a spreadsheet and now wish to manipulate and interrogate the data in greater detail. What you will gain You will gain enhanced skills in the techniques associated with large and multiple spreadsheet design, including data manipulation, worksheet consolidation and more complex functions and formulae. Who should attend this course? You should attend this course if you are currently using Excel for basic formulas and would like to develop your skills in the creation and understanding of functions. Course Objectives This course covers the following key topics: - Work with multiple spreadsheet workbooks Dynamically link worksheets and workbooks using more complex formulae and consolidation tools Work with lists and manipulate data using sort and filters Understand and utilise some of Excel's more advanced functions Create nested logical functions Create and manipulate charts Further development Microsoft Excel Advanced What some delegates have said about this course ”Trainer was very helpful, knowledgeable and made sure all delegates needs were met.” KV (Communities and Local Government) “Very fluent and tailored presentation.” PS (Communities and Local Government) “Very good, I will recommend colleagues to attend this” TB (Department for Transport)