Financial Arena

Financial Training & Consulting Experts

Risk Analysis

Business Analytics & Financial Modeling Training camp – an aftermath of our Athens event

By Leave a Comment

We want to say thank you to our participants, sponsors and partners of the Business Analytics & Financial Modeling Training Camp. We had a great outcome with almost 100 attendees across the two days. A special thank you to Microsoft Hellas for their tremendous support of the event.

Finance executives from Microsoft Hellas and industry experts in financial modeling, risk analysis and business analysis presented practical workshops and gave the opportunity to camp participants to learn about the advanced data analysis and manipulation capabilities of Power Pivot, Power Query and the visualization power of Microsoft Power BI tool. Other topics included how to apply best practice financial modeling methodologies to build business and financial models and also how to advance a spreadsheet sensitivity analysis using a risk analysis tool like Palisade’s @RISK.

power pivot power query and power bi courses

Check out the photos from the event on our Facebook page! Please feel free to tag yourself.

https://www.facebook.com/pg/financialarena/photos/?tab=album&album_id=1922868574624483

If you did not manage to join our training camp, here are some additional learning options for business analytics and financial modeling fans:

  1. If you or your colleagues would like to learn more about Financial Modeling based on FAST Modeling Standard you can register for our live workshop coming up on the 10th till the 13th of July. Seats are limited in this accredited seminar as we set a maximum number of 10 participants. For a limited number of seats there is a 50% discount if you book by July 5th. If you are interested contact us for the special discount code.

Here is the link to the upcoming financial modeling and risk analysis course: http://bit.ly/finmodath_july2017

2. Microsoft has created some free online courses on EDX.org and we suggest you to sign and attend them:

  • Introduction to Data Analysis using Excel
  • Analyzing and Visualizing Data with Excel
  • Analyzing and Visualizing Data with Power BI
We have created a free common account for our visitors to EDX so that you can sign up immediately and start learning (username: edx@financialarena.co.uk & password: financialarena) but feel free to open your free personal account so that to have the option to pay a small fee to EDX and receive a certificate.
Finally, we will be offering more specialized online and live courses on business analytics beginning in September 2017 so stay tuned and sign up to receive our updates and offers.

We hope to see you at our upcoming training events!

 

Should you have any additional questions or require a custom module, we have the capability to tailor our courses to your business’s needs and deliver just for you. With our in-house custom training, you select the date and location and we will work with you to meet your learning goals. For additional information please  contact Mrs. Lydia Spanou at training@financialarena.co.uk

 

Upcoming Financial Modeling & Risk Analysis Seminars schedule, Q3 2017

By Leave a Comment

seminaria-financial-modeling-excel

 

Check the schedule for our upcoming financial modeling courses and feel free to contact us for further details or for special requests (in-house financial modeling training or 1-on-1 courses):

1. “FAST Financial Modeling & Risk Analysis using Excel”, Athens – Greece, 10-13 July & 25-28 September, 2017

Total seminar duration: 16 hours

Απέκτησε τη #1 Διεθνή Πιστοποίηση στο Financial Modeling με τη χρήση του Excel

Αναβαθμίστε τις γνώσεις σας στο Excel και ετοιμαστείτε για την #1 Πιστοποίηση στο Financial Modeling

H δεξιότητα του financial modeling γίνεται ολοένα και πιο απαραίτητη στις επιχειρήσεις και στις ανεπτυγμένες χώρες αναζητούν στελέχη για την δημιουργία και ανάλυση financial & business models. Απέκτησε συγκριτικό πλεονέκτημα, μαθαίνοντας τη δεξιότητα που ζητάει η αγορά εργασίας. Παρακολούθησε ένα πρακτικό σεμινάριο βασισμένο στο πρότυπο FAST, το οποίο αποτελεί μια βέλτιστη πρακτική για τη διαχείριση και ανάπτυξη μοντέλων και αναλύσεων βασισμένων στο Excel και χρησιμοποιείται από κορυφαίες εταιρείες διεθνώς όπως: PwC, Grant Thornton, Mazars, Capita.

Το σεμινάριο εστιάζει στις βέλτιστες πρακτικές ανάπτυξης μοντέλων και χρήσης του Excel, μέσα από πρακτικά παραδείγματα και ασκήσεις. Παρακολουθώντας το συγκεκριμένο σεμινάριο θα είστε σε θέση να δώσετε τις εξετάσεις για τη διεθνή πιστοποίηση στη διαμόρφωση μοντέλων στο Excel, το FAST Level 1 Certificatιon.

Πέρα από την εκμάθηση του πρότυπου FAST, οι συμμετέχοντες μαθαίνουν πως να αναβαθμίσουν την ανάλυση τους, μέσω της ανάλυσης κινδύνου (risk analysis) με το @RISK, δημιουργώντας πιο ευέλικτα και δυναμικά μοντέλα βασισμένα σε κατανομές πιθανοτήτων.

(διάρκεια: 4 απογεύματα / σύνολο 16 ώρες)

Ημερομηνίες:

Ιούλιος 2017: Δευτέρα 10/7 έως & Πέμπτη 13/7

Σεπτέμβριος 2017: Δευτέρα 25/9 έως & Πέμπτη 28/9

Ώρες διεξαγωγής: 17:30 – 21:30

Προαπαιτούμενα: Βασική Γνώση Excel, το laptop σας και όρεξη για μάθηση

Click here for more details on this FAST accredited financial modeling course in Excel or email us at training[@]financialarena.co.uk

 

2. “FAST Financial Statements Modeling and Risk Analysis” , Athens – Greece

    • Σεπτέμβριος 2017: Δευτέρα 9/10 έως & Πέμπτη 12/10

Click here for more details on this advanced financial modeling seminar based on FAST Modeling Standard or email us at info[@]myfinancialmodeling.com with any possible questions.

 3. Data Analytics & Business Intelligence for Business Analysts

ΣΚΟΠΟΣ: Να μάθετε τα πλέον σύγχρονα εργαλεία της Microsoft για να αναλύετε δεδομένα πιο αποτελεσματικά και να τα παρουσιάζετε με το καλύτερο δυνατό τρόπο. Να αναβαθμίσετε τις γνώσεις στο Excel, μαθαίνοντας βέλτιστες πρακτικές στο data analytics με τη χρήση του Power Query & Power Pivot.

To 90% των δεδομένων / πληροφοριών που κυκλοφορούν παγκοσμίως, έχουν δημιουργηθεί μόλις τα τελευταία 2 χρόνια! Η αγορά εργασίας αναζητά ειδικούς στην ανάλυση δεδομένων (business & data analytics) και παγκοσμίως υπάρχει μεγάλη έλλειψη εξειδικευμένου προσωπικού.

OSLO – Norway

1. “FAST Financial Modeling & Risk Analysis using Excel”, Oslo, 15 November, 2017

Click here to learn more about this FAST accredited financial modeling seminar in Excel or email us at info[@]myfinancialmodeling.com

LONDON – UK

1. Data Analytics & Business Intelligence using Power Query & Power BI, 14-15 November, 2017

2. “FAST Financial Modeling & Risk Analysis using Excel”, London, 16-17 November, 2017

Click here to learn more about both our upcoming seminars in London or email us at info[@]myfinancialmodeling.com

 

Frequently Asked Questions

Q: What if I want to take the FAST Modeling Standard Level I Certificate?

In order to be well prepared for FAST Level 1 Certificate exam and be in position to use the FAST modeling Standard in a business environment you can attend the FAST Financial Modeling & Risk Analysis seminar but if you really want to master the FAST  Modeling Standard we suggest you to invest in our combo-seminar deal, starting with the FAST Financial Modeling using Excel seminar  and then move on with the FAST Financial Statement Modeling & Risk Analysis.

Are you interested in our financial modeling courses, 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 seminar prerequisites? 

No modeling experienced is required, just basic Excel knowledge, a laptop and passion to learn. For those with no modeling experience, this seminar provides a solid introduction to real-world financial modeling preparing participants to sit for FAST Level 1 certificate exam but most importantly to build flexible and transparent business models based on financial modeling best practices. For those with modeling experience this seminar will help the quality and productivity of your modeling and through the FAST Certification improve their personal “branding” and career prospects.

Q: What do  I need to bring to the seminar?

Participants should bring their own laptop, ideally one they are accustomed to using, with a Microsoft Windows operating system and Microsoft Excel 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 this financial modeling seminar accredited?

A: Our course is one of the few financial modeling courses in the EU 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 (FSO) 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 modeling 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 Organisation’s website.)

If you want to learn more about the FAST Standard Level 1 certificate exam read our post here.

 

Q: Are there any extras to this seminar offer?

A: Yes, your registration comes with many extras so please check our seminar page:

You are entitled to a 3-hour online mock exam where you will be given a case study to solve and then discuss the solution and your mistakes with the instructor so that you are better prepared for the FAST Certificate exam. One of our unique offerings in this training is the 1-on-1 session with the instructor once you have completed your practice and want him to check your model solution before registering for the exam. You will get personalized support and feedback that will help you improve and master FAST ahead of the FAST Level 1 certificate exam.

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 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 in 2016 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.myfinancialmodeling.com/about/testimonials/

 

 

All our seminars are either offered 100% in-person or in a blended delivery mode (60% face-to-face & 40% online) depending on the group size.

In the case of face-to-face / live seminars, we rigorously uphold our policy of purposely limiting the number of individuals that can attend each financial modeling seminar up to 10 persons so that participants receive the optimal amount of personal training from our instructors and to ensure the quality of training.

Seminars will take place at our offices in London (Regent street) and in centrally located venue in Athens.

financial modeling seminar dealEmail us to learn for our special combination offers. There is an extra discount in case more than one delegate / participant from the same firm joins.

For more information / feedback please contact us at customercare[@]financialarena.co.uk

Check our Facebook Fan page for up-to-date news on our offerings and topics related to financial modeling and do not forget to share our page with friends and colleagues that might be interested.

As of January 2016, our firm is one of the first globally to become a FAST accredited provider, as we have gone through a formal accreditation process with the FAST Standard Organisation (“FSO”). We are offering financial modeling training courses that have been subject to a formal accreditation process with the FSO and prepare our seminar participants for the FAST modeling certification.

Best Practice Financial Modeling and Risk Analysis Using Excel – Philadelphia, USA

By Leave a Comment

Our firm is partnering with Lebow College of Business at Drexel University and starting on April 2017, we will be offering two 3-day training courses on Best Practice Financial Modeling and Risk Analysis using Excel.

Who Should Participate

This hands-on seminar is designed for junior to senior business and finance professionals as well as general managers who need to use financial models to measure business performance, including: Directors, GMs, VPs, Senior Managers, Managers, with responsibility in the following functional areas:

  • Business& Financial Analysts
  • Investment& Corporate Bankers
  • CFOs& Finance Managers
  • Risk Managers and Portfolio Managers
  • Financial Controllers and Accountants
  • MBA’s and Business Undergraduates
  • Anyone seeking to improve their financial and valuation modeling skill set
  • Industry Consultants
  • Project Managers and Risk Analysts
  • Corporate Finance and Business
  • Development Professionals
  • Finance& Accounting staff
  • Heads of Business Units& Business
  • Planners

The training  is split in 2 training sessions so that potential attendees can decide if they attend either or both of them. Here are some more details on our upcoming Financial Modeling courses at USA:

Session I: Financial Modeling and Risk Analysis Using Excel

The purpose of this training is to enhance your existing Excel modeling skills and learn how to build and modify financial models faster by learning and applying FAST Modeling Standard principles. The seminar highlights the core financial model design and construction techniques that every modeler should know. This seminar will allow participants to adopt a structured and comprehensive design strategy to develop rigorous financial models, in less time and with greater accuracy.

Participants will learn how to apply best practice financial modeling and perform sophisticated business analysis. This hands-on workshop will also teach you how to perform risk analysis and apply uncertainty into a model and undertake a more dynamic analysis to improve decision making by developing a risk assessment into an @RISK model.

Learning Outcomes

  • Build models accurately and efficiently through a series of best practice modeling rules
  • Develop financial models that improve the reliability and quality of financial decision-making
  • Improve financial model efficiency by using shortcuts and learn to recognize the sensitivity of key drivers
  • Learn and practice the main principles and techniques in quantitative risk analysis and apply uncertainty into models
  • Undertake a more dynamic analysis to improve decision making
  • Expand existing deterministic Excel analysis skills into an @RISK model so that to quantify exposure and test mitigation strategies
  • Adopt a structured and comprehensive design strategy to develop rigorous financial models, in less time and with greater accuracy.

 

 

Session II: FAST Financial Statement Modeling

The purpose of this training is to enhance your existing Excel modeling skills and to teach you how to integrate and model the three major financial statements (balance sheet, income statement and cash flow statement) based on the globally recognized FAST Modeling Standard. Participants will learn how to apply best practice financial modeling and perform sophisticated business analysis, including analyzing financial statements and building pro-forma financial statements. Develop a full scale model and learn how to model all respective financial statement items (assets, debt, depreciation etc).

 Learning Outcomes

  • Apply FAST modeling principles to improve financial models’ design, style and structure and better analyze financial data
  • Expand deterministic Excel analysis into an @RISK model.
  • Learn how to develop a full scale model to account of risk elements of all respective items (assets, debt, depreciation etc.).
  • Integrate all financial statements to produce a comprehensive financial profile
  • Model business operations (including revenue, costs, taxation and inflation / indexation / escalation);
  • Learn how to structure business assets (including non -current assets, accounting depreciation and working capital – and impacts on tax); and how to model financing (including debt principal and interest calculations)
  • Advance your financial models one step further from the simple static input/output to a more dynamic decision making analysis.
  • Identify the importance of uncertainty for model building and decision making and LEARN how to select distributions and incorporate uncertainty in a financial model.

Visit the dedicated pages at Lebow College of Business site to learn more details about Session I and Session II and feel free to contact us for more details.

Instant SSL Pro
X