ADVANCED EXCEL FOR ANALYSTS

Advanced Excel techniques for Intelligence Analysts and those needing to manipulate complex data sets using Microsoft Excel.

Through the use of a case study, 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.

Course Aims

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.

Who Should Attend

Personnel who possess a basic knowledge of Microsoft Excel and have identified a need for advanced skills.

Learning Outcomes

  • ply 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.

What people said about this course

I thoroughly enjoyed this course. It is one of the best courses I have attended and I would recommend it to all analysts.

Ruth , Greater Manchester Police

Formulas for telephone analysis will improve my work no end and I will save hours, thanks.

Karen , Greater Manchester Police

Private Courses

This course is available to be run privately at your discretion.

Click here to fill in our enquiry form.

Advanced Excel, Excel for Analysts

Get to grips with some of the most advanced Excel techniques for intelligence analysts with Focus Training. To learn more about these courses, visit us here

Learn Advanced Excel - Focus Training