Trusted Training Partners
Home / Non-Accredited / Software & IT Non-Accredited / Beyond Advanced Excel 2010 Training Course
Quick Look Course Summary:Beyond Advanced Excel 2010 Training Course
-
Next Public Course Date:
-
Length: 1 day(s)
-
Price (at your venue): 1 Person R 4,811 EX VAT 3 Person R 3,654 EX VAT 10 Person R 2,719 EX VAT
-
Certification Type:Accredited
-
Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.
Get Free & personalised
Training Advice
Beyond Advanced Excel 2010 Training Course Course: Introduction
This course is intended for advanced Excel users who wish to have an expert knowledge of Excel and it’s various advanced features and functions. This course has two follow on courses, Microsoft Excel Pivot Tables and Excel macros with VBA.
Beyond Advanced Excel 2010 Training Course Course :Course Outline
1. Manipulating Data Using Statistical and Lookup Functions.
Forecast GDP Using Statistical Functions
Evaluate Sales Data Using Statistical Functions
Analyze Stock Data Using Statistical Functions
Mine Data Using the Lookup and Reference Functions
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
Analyze Sector Data Using Correlation and Covariance Matrices
Optimize a Stock Portfolio Using Solver
3. Working with Data Using Financial Functions
Develop an Investment Schedule Using Financial Functions
Make Investment Decisions Using Financial Functions
4. Examining Data Using Math Functions
Analyse Sales Data Using Math Functions
Calculate Stock Returns Using Math Functions
Aggregate GDP Data Using Math Functions
5. Manipulating Data Using Text and Information Functions
Manipulate Data Using Text Functions
Validate Data Using Information Functions
6. Working with Templates and Charts
Create Advanced Templates
Create Advanced Charts
7. Managing Data in Workbooks
Retrieve and Paste Data
Clean Data in Workbooks
Beyond Advanced Excel 2010 Training Course Course: Course Duration
1 day/s
Who should attend: Beyond Advanced Excel 2010 Training Course Course
This course is intended for advanced users of Microsoft Excel.
**Quote does not include Any Exam Fees (if applicable)
IMPORTANT ACTION: Do Not Wait To Improve Your Skills.
Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal
Frequently Asked Questions
Is this course accredited?
BOTI offers a mix of SETA-accredited, internationally-certified (VMEdu) and non-accredited skills-programme courses. Please confirm a specific course's accreditation status with us when you enquire. All delegates receive a certificate of completion.
Can this course be delivered in-house at our premises?
Yes. Every BOTI course can be delivered on-site at your offices anywhere in South Africa, or at a scheduled public venue, and can be customised to your team and industry.
How do I book or get a quote?
Use the enquiry form on this page for a tailored quote, or call 011 882 8853 / email [email protected]. The course length and next public course date are shown in the Quick Look summary.
Can this training count towards our B-BBEE scorecard?
Yes - skills development training can contribute to your B-BBEE scorecard, and where learnerships apply you may also access SETA grants and the Section 12H tax allowance. Ask us how to structure it for maximum points.
Do you tailor the training to our industry?
Yes. Our training is built around your business, using practical, real-world examples relevant to your team and sector.