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

 

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