Advanced Excel for Analysts
Course
In Droitwich
Description
-
Type
Course
-
Level
Advanced
-
Location
Droitwich
-
Duration
3 Days
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. Suitable for: Advanced Excel for Analysts Personnel who possess a basic knowledge of Microsoft Excel and have identified a need for advanced skills.
Facilities
Location
Start date
Start date
Reviews
Course programme
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
Advanced Excel for Analysts