Are you interested in our financial modeling and data analytics training courses in London, but still have some questions? We have created this page with frequently asked questions related to this seminar in order to help you decide. Feel free to contact us if you have more questions.
Q: What are the course prerequisites?
No modeling or data analytics experience is required, just basic Excel knowledge, a laptop and passion to learn.
For those with no modeling experience, our seminars provides a solid introduction to real-world data analytics and financial modeling and will allow you to build flexible and transparent business models based on industry best practices. Deliver critical information and get important insights from your data by visualizing your work with Microsoft Power BI and Power Pivot for Excel. We will teach you how you can take your analysis one step further using two versatile business intelligence tools.
Q:What are the key learning points from the Data Analytics and Business Intelligence seminar?
In this seminar, you will learn Power Query from basic level with importing data from different data sources. You will learn about different types of data transformations available in Query Editor. After this seminar you will be able to implement any types of data transformation through Power Query in Excel or Power BI. You will learn how to use Power Pivot and Power BI by applying the concepts taught to a real business situation. A real-life case study will help you examine how the analysis of Sales and Expenses can become more efficient, dynamic and advanced by using Microsoft’s Power BI and Power Pivot vs. more “traditional” methods of Excel analysis (pivots, vlookups etc). We will demonstrate how to avoid time-consuming and repetitive data manipulation, allowing us to focus on more important aspects and explore the new capabilities Excel has to offer to improve the quality of our analysis.
Participants should bring their own laptop, ideally one they are accustomed to using, with a Microsoft Windows operating system and Microsoft Excel 2010 or 2013 or 2016 installed and have a basic understanding of MS Excel (e.g. syntax of IF statement, purpose of $ for anchoring cell references).
The Mac version of Excel is dramatically different and it is not advised to use it during the seminar. If you have a Mac laptop you can join this seminar provided you have Windows and the Windows version of Ms Excel installed (using Parallels or Bootcamp)
Q: Is the financial modeling seminar in London accredited?
A: Our course is one of the few financial modeling courses in the UK market that is accredited and will allow you to sit for the FAST Standard Level 1 certificate exam. We have been accredited by the FAST Standard Organization to provide training based on FAST Modeling Standard.
If you are seeking to build more flexible and transparent spreadsheet models this is an option to learn and certify your modelling skills. The FAST Standard has been developed by professional financial modelers across the globe and provides a set of guidelines for building spreadsheets.
Q: What exactly is the FAST Level 1 Certificate?
A: The FAST Level 1 Certification awarded by the FAST Standard Organisation (FSO) provides evidence of your modeling skills and will be useful to present a case to potential employers of your financial modeling credentials and experience. (Financial Arena is one of the first to be accredited to provide FAST Modeling Standard training as listed in the FAST Standard Organization’s website.)
If you want to learn more about the FAST Standard Level 1 certificate exam read our post here.
Q: Do you provide any post-seminar support?
A: Of course, once you are done with the seminar, it will be important to practice – especially if you plan to take the FAST Certificate exam. We will provide you with some additional case studies to work and once you send us your solution, the instructor will send you detailed feedback and if needed schedule a follow-up 1-hour webinar (free of charge).
Q: Will the seminar help me with my career? Why your accredited financial modeling training is unique ?
A: We believe that attending this seminar will give you an edge and if you follow our instructions and practice and take the FAST Certificate you will be one of the first in the market with a Financial Modeling certification. The Standard is being around for 16 years and it is used by many firms like PwC, Grant Thornton, Mazars etc but the Certificate came out only this year so it is a unique opportunity to lead and distinguish from your peers. You can use these skills not only in Finance but almost in any company that is performing business analysis and valuation and uses advanced Excel. Literally, people with good financial modeling skills are highly sought in the industry.
Q: Is there any extra discount / offer ? What if I bring a friend?
We can offer an extra 10% on seminar price in case you register with a friend, so contact us now for details.
Q: I need to read what past participants are saying about your trainings. Are there any extra testimonials available?
A: We have trained more than 1,500 business and finance professional in Finance, Investments and Financial Modeling. You can read some of the testimonials of our courses and seminars at our financial modeling site here: http://www.