Advanced Excel techniques for Intelligence Analysts and those needing to manipulate complex data sets using Microsoft Excel.
This 3 day course will be held at Land Rover House Droitwich.
The price for this course is £550.00 per delegate
.
There are still places available. Click here to book your place or ring us on 44 (0) 870 919 4745
Course Details
Who should Attend - Advanced Excel for Analysts
Personnel who possess a basic knowledge of Microsoft Excel and have identified a need for advanced skills.
Course Aim
To develop skills in advanced features of Microsoft Excel, shortcuts, automated processes and add-ins. To introduce concepts of statistics, practical significance testing and probability.
Learning Outcomes
At the conclusion of the course delegates will be able to: -
-
Apply testing for significance to statistics
-
Demonstrate an understanding of Trends and Trend Lines
-
Update values automatically in spreadsheets
-
Differentiate between relative and absolute cell references
-
Prepare Pivot Tables and Frequency Histograms
-
Utilize goal seek
-
Employ solver to achieve an objective
Last updated - 21 Apr 2007
|