About This Course
Course Content
Course Outline
Lesson 1: Manipulating data using statistical and lookup functions
• Forecast gdp using statistical functions
• Evaluate sales data using statistical functions
• Analyse stock data using statistical functions
• Mine data using the lookup and reference functions
Lesson 2: Analysing data using data analysis tools
• Analyse sales data using descriptive statistics
• Analyse time series data using exponential smoothing
• Analyse data using regression
• Identify the beta value of a security
• Analyse sector data using correlation and covariance matrices
• Optimize a stock portfolio using solver
Lesson 3: Working with data using financial functions
• Develop an investment schedule using financial functions
• Make investment decisions using financial functions
• Analyse sales data using math functions
• Calculate stock returns using math functions
• Aggregate GDP data using math functions
Lesson 4: Examining data using math functions
• Analyse sales data using math functions
• Calculate stock returns using math functions
• Aggregate GDP data using math functions
Lesson 5: Manipulating data using text and information functions
• Manipulate data using text functions
• Validate data using information functions
Lesson 6: Working with templates and charts
• Create advanced templates
• Create advanced charts
Lesson 7: Managing data in workbooks
• Retrieve and paste data
• Clean data in workbooks
Course Requirements
Prerequisites
Hard/Soft Requirements
Additional Information
Prerequisites
Hard/Soft Requirements
Additional Information
Book Your Seat
Don’t just take our word for it
Frequently Asked Questions
What do the courses include?
You can view each of the individual course details on our courses page.
What does the cost of training include?
The cost of the training is inclusive of the following:
- Course material for each learner including: Access keys & USB where applicable
- Meeting with client to confirm scheduling of training days
- Induction meeting with Stakeholders and ElectroFibe before commencement
- Classroom facilitation/Online VILT Training
Where can I go for help?
You can contact us if you have any questions or enquiries about any of our courses.
