Add to basket or enquire
Souter's experienced training staff have developed a new online Excel Training Course. This is a specialist course for Banking and Finance. The Course is fully CPD Accredited and certification is issued on successful completion. The trainer who has developed this course is a specialist in Finance, Banking and Microsoft Excel.
Our training staff have delivered training to major Financial Institutions such as Tokyo Mitsubishi, BNP Paribas, Barclays Bank, Nationwide, Credit Suisse, numerous accountancies and consultants and many more. This experience and exposure will ensure that the learner gains the correct skills for a job in Banking or Finance because our trainers truly understand the requirements of employers in this industry.
We have used our expertise in these fields to ensure that we can develop an affordable and accessible Excel Training Course that is specifically designed to meet the needs of people working in Banking, Financial Services, Finance and Accountancy. However, it would also be beneficial to any career that involves the analysis and manipulation of large amounts of data.
The training course is an online course and it is delivered on a state system. Our training system uses a virtual tutor who can instruct the user and can provide feeback on any errors and actions made by the learner, correcting any mistakes like you have your own personal tutor.
The course can be taken over a maximum of 3 months. However, it is possible to complete the course much faster. On average the course takes 20-25 hours to complete.
You will have access to the training modules for a full year, which is can be a useful reference point in the future.
Here is an outline of the course:
- Creating Business Charts; Using Charts to explain your data
- Sparklines and creating more advanced charts
- Working with multiple views, worksheets and freeze panes
- Formulas, absolute references
- Formats and Tables
- Conditional formats
- Pivot Tables and Pivot Charts
- Advanced Functions; Lookup functions, Array Formulas, Date Calculation, Time Calculations, Nested Functions, IF statements, Financial Functions
- Data Sort and Filters
- Solver, Goal Seeks, Scenarios, Detecting errors, audit of your spreadsheet and Templates
- Double Entry Data Tables
Who is this course for?
The course is ideal for anyone working in Finance or Banking. It is also ideal for anyone looking to work in Finance or Banking. It is excellent means of preparing for interviews and assessment centres, when applying for Banking and Finance jobs.
The course will require intermediate level excel skills. However, beginners can contact us to arrange a Beginner course, if it is required.
Intermediate Excel Skills are needed as a minimum. If you have doubts about your Excel skills, please contact us to arrange Beginner to Intermediate training for you.
Banking and Finance are the main London industry with great job options and high salaries.
Excel skills are fundamental to working in Finance and Banking. Most employers will look for Pivot Tables, Vlookups, Scenarios and other advanced functions.
Too many good candidates are held back by a lack of Excel skills, so this course enables applicants gain the skills to get Jobs in Finance / Banking.
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Currently there are no reviews for this course. Be the first to leave a review.