+91 99879 83270

  • Sign In
  • Create Account

  • Bookings
  • Orders
  • My Account

  • Bookings
  • Orders
  • My Account
Profectus Academy
Profectus Academy
  • Home
  • Events
    • Financial Modelling PRO
    • MS Excel and Power BI
    • SHORTS
  • Blogs
  • Downloads
  • Contact
    • Home
    • Events
    • Courses
      • Financial Modelling PRO
      • MS Excel and Power BI
      • SHORTS
    • Blogs
    • Downloads
    • Contact

+91 99879 83270

  • Sign In
  • Create Account

  • Bookings
  • Orders
  • My Account

  • Bookings
  • Orders
  • My Account

Signed in as:

filler@godaddy.com

  • Home
  • Events
  • Blogs
  • Downloads
  • Contact

Account


  • Bookings
  • Orders
  • My Account

  • Sign In
  • Bookings
  • Orders
  • My Account

Financial Modeling Pro

A course that sets standards for the industry

Our flagship Financial Modeling Pro program is one of the most comprehensive and up to date training program that is filled with practical real life case studies and at the same time engages in thorough academic understanding of the discipline.


This is one of its kind program that treats financial modeling as an interdisciplinary subject. We are proud to claim that this program does not merely meet the industry standards but it is aimed at setting a benchmark for the industry.


While most training program on the topic approaches financial modeling from an end user perspective, this is among the few course that targets financial modeling from a professional model developer perspective.


In this program you will be working on close to 100 exercises including three comprehensive case studies covering business forecasting and valuation, project finance and portfolio management. The program 


Learn the latest best practice including data modeling approaches and dynamic array from financial modeling guru, Viswanathan.


Duration: 64 hours


Course outline


  • Overview of financial modeling
  • Mathematics for financial modeling
  • Role of statistical techniques in financial modeling
  • Basic and advanced MS Excel for financial modeling
  • Reverse flow charting technique
  • Budgeting and forecasting
  • Asset valuation
  • Project appraisal 
  • Portfolio management
  • Stochastic modeling for risk analysis


Click here to download the course brochure.


Register now

Analytics with MS Excel and Power BI

The analytics program designed for everyday analysis

 Our advanced MS Excel program rechristened as Analytics with MS Excel and Power BI is focused on boosting productivity and analytical capability of professionals across discipline.


Whether you are in finance, marketing, production or HR, our wide variety of practical case studies will help you directly relate this to your work and help you improve your productivity and your capability to handle data. This program does not just cover formulas and functionalities but our proprietary module on reverse flow charting technique will also enable you to develop your own solutions to problems in hand.


In this program, you will be working with over 60 practical case studies including two full fledged analytical case studies all inspired from real life corporate situations. 


The program is up to date and covers all the latest functions and functionalities including XLOOKUP, XMATCH and Dynamic Arrays.
Duration: 40 hours (36 hours in case of virtual training sessions)


Course outline

  • Best practices in storing data
  • Cleaning unclean data
  • Advanced MS Excel functions 
  • Working with date and text
  • Reverse flow charting technique to develop algorithms and solutions
  • Working with tables and arrays
  • Dash boarding in MS Excel
  • Working with power query and power Pivot
  • Fundamentals of working with Power BI
  • Introduction to DAX functions
  • Introduction to VBA

Register now

Analysis by Objective

Group of executive going through a report

Course overview

This course is specifically designed for consultants, equity analysts and decision makers who often have to make sense out of available information and recommend or chart out a course of action.


In this program you will learn everything from how to define a problem correctly, how to break it into logical parts, framing the correct conclusion and most importantly you would also learn how to communicate it in a persuasive manner to your audience.


In this course, you will be working on wide variety of case studies across multiple disciplines including case studies on HR strategies, go to marketing strategies, product position, financial analysis, equity valuation and many more.


Duration: 20 hours


Course outline

  • Defining a problem based on its outcome
  • Breaking a problem into its parts
  • Framing the conclusion
  • Communicating it effectively to the participants

Enquire

Course Brochures

Download detailed brochure to our training programs from this section.

Financial Modelling PRO brochure (pdf)

Download

Terms and conditions

Copyright © 2019 Profectus Talent Management Solutions and Services - All Rights Reserved.

  • Terms and Conditions
  • Privacy Policy
  • Register for our courses
  • Terms and Conditions