Advanced Excel

How to use ‘What-If Analysis’ tools in Excel

Microsoft Excel is equipped with “What-If Analysis” tools like scenario manager, Goal-seek and Data table. These tools allow you to […]

In our day to day lives, at an individual level or at a business level, we come across questions like:

Ever wanted to use Excel to examine big data sets? This tutorial will show you how to analyze over 300,000

What is Monte Carlo Simulation? The name Monte Carlo simulation comes from the computer simulations performed during the 1930’s to

A waterfall chart is also called as a cascade chart or a bridge chart. This type of chart is not

An Array formula works with an array. You may see array formulas referred to as “CSE formulas,” because you press