This course is for advanced Excel users who want to update their skills in advanced data analysis. By its focus on working with nested functions, advanced Pivot Tables, complex use of Data Validation and Conditional Formatting, this course will give the skills to tackle the most complex data analysis. By completing structured exercises, using data relevant to your work, this course will increase your competence in advanced data analysis helping you meet those targets more efficiently. This course also prepares you for moving on to the Microsoft Excel VBA Course.
To get the most from this course you will have attended the Burningsuit Microsoft Excel Level 3 Course.
Or you have been using Excel for a reasonable length of time and you are competent in spreadsheet analysis work and have used formulae and functions. You now need to know how to use complex functions and perform difficult data analysis.
We specialise on on-site training and can come to you to run our course either on your PC’s or provide our own high specification equipment. If you want specific training for your staff, we’re happy to customise this course to your requirements, adding or removing topics as necessary
(Including Inquire Add-In for Excel 2013).
Download course informationGet a Quote for this Course