The benefits of learning advanced Excel

Microsoft Excel is more than just a computer application. You can use it for a wide range of tasks, including the organisation and presentation of...

wrap text in Excel

In this article, we will learn about how to Wrap text in Excel in Excel. While writing in excel, when values get out of reach of cell length then ...

How to use Excel Box and Whiskers Chart

The Box and Whisker chart was invented by John Tukey in 1977. The graph was initially called Boxplot. Since then, it is being used in statical plottin...

How to Create Tornado / Funnel Chart in Excel

Tornado or funnel chart is basically a bar chart of decendingly sorted data. It looks like a funnel or tornado, from which it gets its name. In t...

Paste Special Shortcut in Mac and Windows

The paste special feature is undoubtedly a very useful option in Excel. It helps us control what we want to copy from the source and what we don't...

How to use Sunburst Chart in Excel

When we have hierarchical data, it's hard to represent it visually. In excel 2016, excel introduced two chart types to visualize hierarchical data. Th...

SUMIF with 3D Reference in Excel

So, we have already learned what 3D reference is in Excel. The fun fact is that the normal Excel 3D referencing does not work with conditional fun...

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.