IFNA Function - New logical function in Excel 2013

Finally MS Excel 2013, is available in the market. Along with the wonderful features like Flash Fill and Quick Analysis Tool there are lot of new features are enabled in Excel 2013.

Apart from the new features, Excel 2013 released new functions also. Here we are going to discuss about the new Logical Functions in Excel 2013 those are IFNA & XOR.

In this post we will concentrate on the function IFNA, which is only available from Excel version 2013 and above.

How to customize Quick Access Toolbar in MS Excel

Microsoft Excel has different parts. The Ribbon, Office Button, Quick Access Toolbar, Menu Group, Formula Bar, Address Bar, Status Bar, Headers, Vertical Scroll Bar, Horizontal Scroll Bar and so on.

Each part of excel has its own importance. Let me discuss one of the Important part of Excel, that is Quick Access Toolbar.

And also, we will see what are the new options in Excel 2013 relates to the quick Access Toolbar

Amazing Flash Fill Feature In Excel 2013 - How It Works? (10 examples) - (Topic 1/2)

Finally, the preview version of MS Office 2013 is out. Obviously, we would be more interest in visiting our lovely MS Excel 2013 preview. You can download the MS Excel 2013 preview from here. See the snaps of MS Excel 2013 here.

Since I heard about Flash Fill feature in MS Excel 2013 much earlier, immediately after opens the Excel preview I first tested Flash Fill feature. After experienced the Flash Fill option performance in Excel 2013, I can simply say that the trailer is bumper hit !!! One scene of Flash Fill Option in the trailer is sufficient to make the movie super hit.

Few Snaps From Microsoft Excel 2013 - So Tempting !!

Microsoft recently released the preview version of Office 2013. I have taken few snaps from Microsoft Excel 2013. The colors are so tempting and the Excel it self some posh look in 2013 version.

Below are some snaps of Microsoft Excel 2013

Learn About TRUNC Formula In Excel

TRUNC formula is one of the Maths formula. TRUNC formula is one of the important formula for finance professionals. Especially, if you are working with any financials statements preparation, you would appreciate TRUNC formula.

TRUNC Formula

Full form of TRUNC is TRUNCATION