#ADVANCED DATA ANALYSIS EXCEL HOW TO#

This course builds on traineesР В Р вЂ Р В РІР‚С™Р Р†РІР‚С›РЎС› advanced knowledge of Excel tools and functions and incorporates these into a financial model.

Learn to rebuild, audit and validate an inherited model.

Translate business concepts into logically structured models and formats.

Maximize your analytical abilities by learning conventional and new approaches of modelling.

#ADVANCED DATA ANALYSIS EXCEL HOW TO#

Learn how to expedite and enhance the decision-making process.

Minimize manual labour and automate common tasks by building macros into your models.

Quantify uncertainty by applying various methods of scenarios and sensitivity analysis.

Apply commonly used formulas in new and different ways.

Streamline model building by applying best practice functions, tools and techniques.

These uncertainties would among others include inflations, variation in demand and supply, and variation in market price of commodities. Incorporate current economic uncertainties into the model in order to take calculated risks and make more informed business decisions.

This could feature but not limited to better discount to offer, better loan to acquire, better loan to issue, better investment to opt for, etc.), data pivoting, Vlookups and Hlookups, Escalation modelling, Visual presentation with trendy conditional formatting techniques, data bars, spark lines, water fall charts, etc. Learn to efficiently build an effective and robust model aimed at tracking the performance trend based on real-world Modelling challenges in the field of sales, finance, accounts, inventory and tracking of staff performance using advanced available tools such as scenario managers (for best, base and worst case scenarios. During the course, participants will hone their advanced Modelling skills and experience designing solutions to real-world examples.

Advanced data analysis excel